Find highest based on criteria

**timtrag12** · 03-27-2011, 04:06 PM

I am trying to figure out a way to determine the highest value in a column but only if a certain value is in a different column.

Example: I want it to find the highest number in Column C, but only out of the rows that have 2 in column A.

Hopes this is clear enough.

**Ron Coderre** · 03-27-2011, 04:17 PM

This regular formula returns the highest Col_C value
where the corresponding Col_A value = 2:

Please Login or Register  to view this content.

Note: if there are no 2's in Col_A, that formula returns: 0

This regular formula returns a message if there are no 2's in Col_A

Please Login or Register  to view this content.

Is that something you can work with?

**timtrag12** · 03-27-2011, 05:42 PM

That worked perfectly.

Would Min work in that formula as well to find the lowest Value?

Thanks a lot.

Find highest based on criteria

LinkBack

Thread Tools

Rate This Thread

Display

Find highest based on criteria

Re: Find highest based on criteria

Re: Find highest based on criteria

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions