Return first number in Range based on multiple criteria

**Perk1961** · 10-21-2015, 09:11 AM

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.

**6StringJazzer** · 10-21-2015, 09:19 AM

Try this formula:

Formula:

Please Login or Register  to view this content.

**Perk1961** · 10-21-2015, 09:35 AM

Thank you. This formula certainly worked. I was curious as to how the below number reference came into play:
9.99999999999999E+307

Thanks!

Return first number in Range based on multiple criteria

LinkBack

Thread Tools

Rate This Thread

Display

Return first number in Range based on multiple criteria

Re: Return first number in Range based on multiple criteria

Re: Return first number in Range based on multiple criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to return multiple values to a single cell based on multiple criteria

[SOLVED] Return a number from a range of cells based on criteria?

[SOLVED] Return Column Number Based On Multiple Criteria

Lookup values in multiple columns based on a date range, return single value per criteria

Formula to return multiple answers based on a number in a range

return all range based on criteria

[SOLVED] Return number OR sum based on two criteria

Bookmarks

Bookmarks

Posting Permissions