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
following is a solution to a bit more generalized problem
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
No comments:
Post a Comment