how to check/trace duplicate number or data in list

**sputet** · 01-14-2010, 02:47 AM

hi there..
is anyone know how to trace/check the duplicate number/data in excell list?
e.g: phone no.

**contaminated** · 01-14-2010, 02:54 AM

Vist this sites

With Conditional Formatting

Prevent duplicate with data validation

**sputet** · 01-19-2010, 02:03 AM

TQ very much..

**teylyn** · 01-19-2010, 02:06 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**sputet** · 01-19-2010, 02:29 AM

hi everybody..
need ur help
did anyone know how to separate the data as attached here
which i want to separate data in column D between data contains word "info" and "poskod"
TQ