Hello,
I need assistance with duplicates in Excel. I work with spreadsheets and tables. Currently I have a table that I know contains duplicates which is driving inaccurate numbers. I know how to find duplicates using conditional formatting BUT that doesn't solve my problem. I need to find how many instances of the identification number there are and remove the second or greater duplicate. In other words if identification number 22334455 has 3 instances in my table I want to keep the first and remove the second and third.
Would I still use conditional formatting to identify the duplicates? I thought I could use countifs, but I must be doing something wrong because it's not providing me the results I'm looking for.
I would really appreciate any help as soon as possible. I hope I'm asking my question correctly. Please let me know if any clarification is needed.
I need assistance with duplicates in Excel. I work with spreadsheets and tables. Currently I have a table that I know contains duplicates which is driving inaccurate numbers. I know how to find duplicates using conditional formatting BUT that doesn't solve my problem. I need to find how many instances of the identification number there are and remove the second or greater duplicate. In other words if identification number 22334455 has 3 instances in my table I want to keep the first and remove the second and third.
Would I still use conditional formatting to identify the duplicates? I thought I could use countifs, but I must be doing something wrong because it's not providing me the results I'm looking for.
I would really appreciate any help as soon as possible. I hope I'm asking my question correctly. Please let me know if any clarification is needed.