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:
Please Login or Register to view this content.
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)
Bookmarks