Finding Min/Max of B:B to match criteria in A:A

**Pilgrimpete** · 02-27-2015, 06:33 AM

Hi All,

I'm looking to pull the min value and max value of column B if column A meets criteria (country name)

For example what is the max in column B if A = France:

France 3
France 7
Germany 1

Sounds like it should be easy!

Thanks in Advance

**samba_ravi** · 02-27-2015, 06:47 AM

=MAX(IF(A:A="France",B:B))
=MIN(IF(A:A="France",B:B))
Try this array formulas confirm with shift+ctrl+enter

**Pilgrimpete** · 02-27-2015, 06:55 AM

Great Stuff, many thanks for your fast response.

Finding Min/Max of B:B to match criteria in A:A

LinkBack

Thread Tools

Rate This Thread

Display

Finding Min/Max of B:B to match criteria in A:A

Re: Finding Min/Max of B:B to match criteria in A:A

Re: Finding Min/Max of B:B to match criteria in A:A

Thread Information

Users Browsing this Thread

Similar Threads

Need Macro Coding for the finding the match case with multiple conditions and write match

[SOLVED] Combining 3 Formulas: Return all Names that Match Criteria Using Index/Match

vlookup for finding out wrongly spelled names and yet match the match

Finding a closest match with more than one criteria

Tough One: Finding Match Based on Criteria, Returning Value

Bookmarks

Bookmarks

Posting Permissions