Hi All

I need a formula that returns the 4 latest numbers in a row, ignoring the blanks.

I have the formula: =INDIRECT(ADDRESS(5,MAX((BL5:DK5<>"")*COLUMN(BL5:DK5)),1)) as an array in cell at the end of the row

=OFFSET(INDIRECT(ADDRESS(5,MAX((BL5:DK5<>"")*COLUMN(BL5:DK5)),1)),0,-1) as an array after the above

=OFFSET(INDIRECT(ADDRESS(5,MAX((BL5:DK5<>"")*COLUMN(BL5:DK5)),1)),0,-2) as an array after the above

=OFFSET(INDIRECT(ADDRESS(5,MAX((BL5:DK5<>"")*COLUMN(BL5:DK5)),1)),0,-3) as an array after the above

This works great when there are no empty cells.

I have tried to reverse this formula which uses small to return the first cell but am getting myself in knots =INDEX($V$3:$NV$3,SMALL(IF($V$3:$NV$3<>"",COLUMN($V$3:$NV$3)-COLUMN($V$3)+1),1))

Any help will be appreciated.

Thanks

Scott