LinkBack URL
About LinkBacks
I have two rows of numbers, the top one are years, 2016 through 2025. The second is 1-10. I want to find the left-most cell that is >= 5 and return the year directly above that cell.
tia
I have two rows of numbers, the top one are years, 2016 through 2025. The second is 1-10. I want to find the left-most cell that is >= 5 and return the year directly above that cell.
tia
With this sample data, random values in Row_2:
This formula returns the Row_1 heading that corresponds to the first Row_2 value that is greater than or equal to the M1 value
EDITED TO INCLUDE THIS COMMENT:
Please Login or Register to view this content.
Actually, this is a bit less complicated:
In that example, the formula returns: 2017Please Login or Register to view this content.
Is that something you can work with?
Last edited by Ron Coderre; 02-04-2016 at 04:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks