finding duplicate data

R

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
 
T

tjtjjtjt

Data|Filter|AutoFilter

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

tj
 
A

Art

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
 
R

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
 
Top