Double Entries in Excel
 

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

Double Entries in Excel
 

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

Double Entries in Excel
 

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