| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to find duplicate values, then delete
Hi,
I have about 2000 data on Excel file and many have duplicate values (numberic) in the cell on Column A. Is there a function that will look for duplicate and delete (or highlight) all, but one of the duplicate value. For example: row 50-59 on column A has a value of 50006420, I like the macro to delete row 51-59. Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use the vlookup function to return a sum of the values? | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions | |||
| find duplicate entries and delete them? | Excel Worksheet Functions | |||
| need to save values from a function before it changes | Excel Worksheet Functions | |||
Threaded Mode
