How can i find the dublicate cells in excel table and mark them automatically?

Question

there is a table in excell full with many nubers and text. but i want to eliminate i they were written more then 1 time.
for example:
1 2323445
2 4e22rerr
3 2323445
4 4435245

i want to use a formula that leaves first "2323445" number in 1st line and erase the other "2323445" or mark in red colour.

Answer 1

First sort the spreadsheet on the column with the duplicates in.
Now create a new column next to the duplicate column.
Assuming the duplicates column is A type the following in the new column assumed to be B.
=a1=a2
Now copy this to the end of the list.

A value of true will indicate a duplicate.
You can now use auto filter to select only the true rows and delete them.

You may have to repeat this exercise if there are more than two entries for a value.

Answer 2

You can do this easily with data filtering. Here's how:

1) Highlight desired rows of data.
2) Click on Data, choose Filter, then Advance filter

You will then see an Advance Filter window.

3) Choose "Copy to another location"
4) Check box for "Unique records only"
5) Click OK

You're done. Enjoy.

Hope this helps!
Kind Regards,
QwertyKPH @ Yahoo!

Answer 3

sure, you take advantage of Conditional Formatting, below format. a million. click on the cellular you want to position your huge form 2. click format>Conditional Formatting 3. situation a million: cellular fee is>decrease than>0 (> shows diverse field) click format button and choose color pink 4. click upload button 5. situation 2: cellular fee is>more beneficial than>0 click format button and choose color eco-friendly 6. click ok Now in case you style or use a formula to get a unfavourable outcome you'll see pink and eco-friendly for effective outcomes. desire this helped :)

Answer 4

press ctrl+F, and look for the entry that is duplicate and replace it with a blank.