Friday, August 10, 2012

yogi_Select Specified Number Of Most Recent Dates From A Column And Return Corresponding Entries From Adjacent Column

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #684   Aug 10, 2012     www.energyefficientbuild.com.

user wbartram said: (http://productforums.google.com/forum/?zx=7f7ur772n8c8#!category-topic/docs/spreadsheets/UZg1CAmcTWk%5B1-25%5D)
Selection the two most recents dates from a column and returning the correct adject cell value
Hi
Can any body help?
A1: 08/09/2012 B1:Great Service
So I have a long list of dates in column A1, and a long list of comments in B1, what I want to do is just select the two most recents comments based on the date?
The functions I am looking at are IF and MAX and vlookup, can anybody provide help
Many Thanks
William
---------------------------------------------------------------------------------------------------------

following is a solution to a bit more generalized problem