ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Double Entries in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/229988-double-entries-excel.html)

S1L1Y1

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



Niek Otten

Double Entries in Excel
 
http://www.cpearson.com/excel/NoDupEntry.aspx

and

http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"S1L1Y1" wrote in message
...
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




S1L1Y1

Double Entries in Excel
 
Thank You. where can I get the validation tool or how?
"Niek Otten" wrote in message
...
http://www.cpearson.com/excel/NoDupEntry.aspx

and

http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"S1L1Y1" wrote in message
...
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






Niek Otten

Double Entries in Excel
 
It is a standard feature of Excel. In HELP, type "Validation".

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"S1L1Y1" wrote in message
...
Thank You. where can I get the validation tool or how?
"Niek Otten" wrote in message
...
http://www.cpearson.com/excel/NoDupEntry.aspx

and

http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"S1L1Y1" wrote in message
...
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








All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com