Prev: Can I 'hyperlink' within a workbook from the first worksheet?
Next: Convert SPI Open Access Spreadsheet
From: Mike on 7 Nov 2009 21:50
im tring to use these formulas 52 cells horizontally examples
g5,k5,o5,s5,w5,aa5 etc can i please get some help or an example
From: Jacob Skaria on 7 Nov 2009 22:27
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=MIN(IF((MOD(COLUMN(G5:AA5),4)=3)*(ISNUMBER(G5:AA5)),G5:AA5))
=MAX(IF((MOD(COLUMN(G5:AA5),4)=3)*(ISNUMBER(G5:AA5)),G5:AA5))
=AVERAGE(IF((MOD(COLUMN(G5:AA5),4)=3)*(ISNUMBER(G5:AA5)),G5:AA5))


If this post helps click Yes
---------------
Jacob Skaria


"Mike" wrote:

> im tring to use these formulas 52 cells horizontally examples
> g5,k5,o5,s5,w5,aa5 etc can i please get some help or an example
 | 
Pages: 1
Prev: Can I 'hyperlink' within a workbook from the first worksheet?
Next: Convert SPI Open Access Spreadsheet