LinkBack URL
About LinkBacks
Is there a way to find the second to last value in a column?
In the example sheet i'd need to find the second to last value in column B which should result in 2.31 being output.
Is there a way to find the second to last value in a column?
In the example sheet i'd need to find the second to last value in column B which should result in 2.31 being output.
Last edited by ssword; 01-05-2011 at 02:33 PM.
Using your posted workbook...
This formula returns the next to the last number in the Col_B list:
If there will be NO blanks between values:
If there MAY be blank cells between the values:
Please Login or Register to view this content.
Does that help?Please Login or Register to view this content.
This will work. If the next to the last cell is blank, you'll return 0
=INDEX(B:B,MATCH(9999999,B:B,1)-1)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks