Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choose highest value duplicate
Hi,
Got a list of customers. Can identify duplicates by address I only want to keep the highest value customer at each address: e.g. Tom 15 Essex Place £30000 Pete 1 George Street £25000 Katy 15 Essex Place £45000 Sally 12 Bath Rd £40000 In the example above, I'd want to pick all entries except the first, as the third is the same address and a higher value. This needn't be complicated - a column of formulas which check all identical addresses and only return a "Yes" if the row is the highest value for that address would be great. Apologies if this is easy - I played about for ages and just couldn't see it. Cheers, Tom. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what function do I use for excel to choose the 2nd highest number | Excel Worksheet Functions | |||
Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
average of highest 48 of 52 radom numbers with duplicate low #'s | Excel Worksheet Functions |