finding duplicate data

[ROLG]

is there a way to select a cell of data and then see if there is an
duplicated data ? all the data is within one column

 

[Guest]

Data|Filter|AutoFilter

Filter for one of the Values.
If more than one cell is shown, there are duplicates in that column.

tj

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

 

[Guest]

You can try conditional formatting.

For this example, my values are in F3:F13. Go into cell F3, and select
Format, Conditional Formatting. Click on the drop down box and change "Cell
Value Is" to "Formula Is". Put in this formula: =COUNTIF(F$3:F$13,F3)>1

Then click the format button and choose something that will notify you, like
the color.
Then copy the formats (use paste special) to the other cells, F4:F13.

This should do it.

Art

 

[ROLG]

the problem with that is it tells me which cells are duplicates of othe
cells-
but i don't know which cells are duplicates. i want to choose cell
at will
by plugging it into a formula and find which cells are duplicates o
it. then
select another cell that wasn't a duplicate of any cells alread
determined to be a duplicate. and find the duplicates of it. s
forth--i want to group all this data manually so that i can simplify i
to use in a microcontroller sun tracking program