LinkBack URL
About LinkBacks
Perk1961 
I am trying to generate a result equal to the first number in a range where the field to the right is not blank. See attached excel file.
Test calc multiple Range.xlsx
Thank you in advance.
I am trying to generate a result equal to the first number in a range where the field to the right is not blank. See attached excel file.
Test calc multiple Range.xlsx
Thank you in advance.
Try this formula:
Formula:
=INDEX($C$6:$C$18,MATCH(9.99999999999999E+307,$E$6:$E$18))
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thank you. This formula certainly worked. I was curious as to how the below number reference came into play:
9.99999999999999E+307
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks