Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating Duplicates in Excel 2007
I have a customer name (Tina) and numbers that go with Tina's information
(575, 125, and 700). How can I find the highest number, and delete the other numbers as well? I want to find her highest score, and keep it, and then remove any other numbers. I tried putting a table in, and then filtering, and finding the highest number (MAX function) but I still have all her other numbers. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating Duplicates in Excel 2007
Hi,
Sort the data on the Number column in Descending order and then with both the Name and Number column selected use the Data, Remove Duplicates command, uncheck Number and click OK. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Té" wrote: I have a customer name (Tina) and numbers that go with Tina's information (575, 125, and 700). How can I find the highest number, and delete the other numbers as well? I want to find her highest score, and keep it, and then remove any other numbers. I tried putting a table in, and then filtering, and finding the highest number (MAX function) but I still have all her other numbers. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating Duplicates in Excel 2007
Thank you soooo much!
"Shane Devenshire" wrote: Hi, Sort the data on the Number column in Descending order and then with both the Name and Number column selected use the Data, Remove Duplicates command, uncheck Number and click OK. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Té" wrote: I have a customer name (Tina) and numbers that go with Tina's information (575, 125, and 700). How can I find the highest number, and delete the other numbers as well? I want to find her highest score, and keep it, and then remove any other numbers. I tried putting a table in, and then filtering, and finding the highest number (MAX function) but I still have all her other numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
eliminating hyperlinks from a complete column in Excel | Excel Discussion (Misc queries) | |||
Need help eliminating text duplicates! | Excel Discussion (Misc queries) | |||
is it possible to combine data sets, eliminating duplicates? | Excel Worksheet Functions | |||
Eliminating rows in Excel worksheet | Excel Worksheet Functions | |||
Excel - eliminating repeated data | Excel Discussion (Misc queries) |