same X,Y values with multiply Z values

[jaystewie]

I have the same X,Y values with multiply Z values. I wondering if there is a program or something that exists that will delete all of the cooresponding x,y,z values where the x and y are the same and just keep the lowest z value and at the same time keep the associated x,y value. Please get back to me on this ASAP.

 

[Oaktree]

Welcome to the board.

If your X values are in A1:A100, your Y values are in B1:B100, and your Z values are in C1:C100, try:

1) Selecting A1:B100, going to data --> filter --> advanced filter
2) Choose to copy to a new location, where the list range is A1:B100, the copy to range is the upper left cell where you'd like to paste (Say, F1), and you check the "unique records only" box. That will give you a list of the unique pairs of X and Y.
3) In cell H2 (or whatever cell is to the right of your first value from the unique list table) enter the formula =MIN(IF($A$2:$A$100=F2,IF($B$2:$B$100=G2,$C$2:$C$100))). Note that this is an array formula and must be confirmed with CTRL+SHIFT+ENTER instead of just ENTER (doing so correctly will result in Excel putting { }'s around your formula in the formula bar).

Then, copy H2's formula down through the end of your list.