PDA

View Full Version : Excel function to get last value of collection of numbers?



volabos
03-01-2008, 08:18 PM
I wonder if there is any excel function to get the last value of ordered collection of numbers. for example I want to get last value of :

D32,E31,F30,G29,H28

I understand it can be done manuall, however I want some general solution, to handle large set.

asingh
03-02-2008, 01:06 AM
Hi,

By your description..your data is like the screen shot below..

what would be last..."a" in D32 or "f" in H28...will give this a try...?

volabos
03-02-2008, 06:34 AM
the last value should be, means I should get : 'f'

volabos
03-03-2008, 10:43 AM
Any suggestion pls?