I have Office XP. I am working with Excel How can I check if I didn't enter
something twice? I found that I entered many rows twice. It would take me at
least an hour to go through the whole file.
Sol

A quick way:

Assuming unique entries are in column A, in a helper column input
=COUNTIF(A:A,A1)
and copy down.
Now use a filter (Data-Filter-Autofilter) to find anything greater than 1.
These indicate where you have duplication.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"S1L1Y1" wrote:

I have Office XP. I am working with Excel How can I check if I didn't enter
something twice? I found that I entered many rows twice. It would take me at
least an hour to go through the whole file.
Sol

They are complete rows.
"Luke M" wrote in message
...
A quick way:

Assuming unique entries are in column A, in a helper column input
=COUNTIF(A:A,A1)
and copy down.
Now use a filter (Data-Filter-Autofilter) to find anything greater than 1.
These indicate where you have duplication.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"S1L1Y1" wrote:

I have Office XP. I am working with Excel How can I check if I didn't
enter
something twice? I found that I entered many rows twice. It would take
me at
least an hour to go through the whole file.
Sol