To return the last five numerical values from K28:K97 in a range of cells, let's say B2:B6, try...

B2, copied down:

=INDEX($K$28:$K$97,MATCH(9.99999999999999E+307,$K$28:$K$97)-ROWS($B$2:B2)+1)

Or, in reverse order...

B2, copied down:

=INDEX($K$28:$K$97,MATCH(9.99999999999999E+307,$K$28:$K$97)-5+ROWS($B$2:B2))

## Like this thread? Share it with others