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:
A B C D E F G H I J K L M 1 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Threshhold 5 2 3 10 3 1 10 4 2 1 1 7
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)
Bookmarks