Control+shift+enter:

=LOOKUP(9.99999999999999E+307,IF(MOD(COLUMN(A1:Z1)-COLUMN(A1),5)=0,IF(ISNUMBER(A1:Z1),A1:Z1)))

Ron Weaver wrote:
That works perfectly. Now, what if I want to do the same thing across:
Formula in B1
Values in A1,E1,J1,N1, etc.
Thanks

"Ron Coderre" wrote:

Try something like this:

B1:
=INDEX(A1:A1000,MAX(INDEX((MOD(ROW(A1:A1000),5)=0) *ISNUMBER(A1:A1000)*ROW(A1:A1000),0)))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Ron Weaver" wrote:

Is it possible to specify a group of cells like A1,A5,A10,A15,A20, and have
Excel find the last non blank cell in the group? These are numeric values
that update a report weekly.
Thanks