Return lowest value for unique sets of data

[jjack85302]

I need to look at 3 columns of data and return the lowest value in the third column once column 1 & 2 are unique.
I need the formula to first look at column 1, then 2, if 2 has multiples then I need the lowest number from column 3. In my example there is a W05546 that falls under column 1 under 11 and 12. my results would show a line for 11, W05546, 0 and 12, W0546, 8. Since W05550 only appears under 11 that value would return 11, W05550, 34. I am pretty good with pivots and vlookup, but this is way over my head. Any help would be great.




11 W05546 0.00
11 W05546 13.00
11 W05550 34.00
11 W05566 0.00
11 W04927 14.00
11 W05113 6.00
11 W05113 14.00
11 W05113 22.00
11 W05150 26.00
11 W05150 32.00
11 W05260 10.00
11 W05261 11.00
11 W05269 19.00
12 W05546 14.00
12 W05546 8.00
12 W05387 8.00
12 W05442 11.00
12 W05451 4.00
12 W05465 1.00
12 W05472 6.00
12 W05486 4.00

[oeldere]

with pivot table

A and B in row

C in value's (choose min)

[jjack85302]

We tried that first and the values aren't returning correctly.

[oeldere]

I get this pivot table, what's wrong with the result?

Waarden
Rijlabels Min van C Max van C Aantal van C
11 0 34 13
W04927 14 14 1
W05113 6 22 3
W05150 26 32 2
W05260 10 10 1
W05261 11 11 1
W05269 19 19 1
W05546 0 13 2
W05550 34 34 1
W05566 0 0 1
12 1 14 8
W05387 8 8 1
W05442 11 11 1
W05451 4 4 1
W05465 1 1 1
W05472 6 6 1
W05486 4 4 1
W05546 8 14 2
Eindtotaal 0 34 21

[jjack85302]

I was looking at two sets of data by mistake. The pivot works. Thank you for your help.
I don't suppose you can tell me is I can then use that data to pull an average for each location (column a)? I have tried a couple of things and it keeps wanting to average all data instead of the filtered data.

[oeldere]

You get better help if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html