|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 11th, 2009, 09:35 PM
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
June 11th, 2009, 11:01 PM
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
June 11th, 2009, 11:19 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
