by John MacDougall | Aug 28, 2017 | Formulas
Example =MATCH(MIN(B3:B10),B3:B10,0) Download Example File Generic Formula =MATCH(MIN(Range),Range,0) Range – This the range of values in which you would like to find the relative position of the minimum value. What It Does This formula will return the relative...
by John MacDougall | Aug 28, 2017 | Formulas
Example =MATCH(MAX(B3:B10),B3:B10,0) Download Example File Generic Formula =MATCH(MAX(Range),Range,0) Range – This the range of values in which you would like to find the relative position of the maximum value. What It Does This formula will return the relative...
by John MacDougall | Aug 20, 2017 | Formulas
Example =COUNTIF($B$3:$B$11,REPT(“?”,D3)) Download Example File Generic Formula =COUNTIF(Range,REPT(“?”,N)) Range – This is the range of cells to count. N – This the number of characters to count. What It Does This formula will...
by John MacDougall | Aug 18, 2017 | Formulas
Example =ISREF(INDIRECT(“‘”&B3&”‘!A1”)) Download Example File Generic Formula =ISREF(INDIRECT(“‘”&SheetName&”‘!A1”)) SheetName – This is the text which you want to test if it...
by John MacDougall | Aug 17, 2017 | Formulas
Example =CHAR(RANDBETWEEN(B3,C3)) Download Example File Generic Formula =CHAR(RANDBETWEEN(Lower,Upper)) Lower – This is an integer value and will depend on what type of character you want to generate. Upper – This is an integer value and will depend on...