Sorting multiple values

[stewyb]

Hi Guys, hopefully an easy question for you.

I have a list of town names (col A) and a list of figures (col B). they are random but what I would like to do is take out the lowest figure from column B against the town name.

For example
Col A Col B
york 10
york 9
york 5
london 20
london 12
london 54
london 32
reading 10
reading 41
newbury 22

I have the town name, once, in another sheet and was thinking of doing a vlookup but to only bring the lowest number out. So for London, it would bring back '12'

Hope thats enough info.

Thanks

Stew

 

[Domski]

Try something like: =MIN(IF(Sheet1!A1:A10=A1,Sheet1!B1:B10))

Confirmed with Ctrl+Shift+Enter as it's an array formula.

Dom

 

[AlphaFrog]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=604608

 

[stewyb]

Yeah apologies, genuine error, didn't think the first one posted.

Cheers Domski, I'll give it a go!