How do you check for double entry in excel?
- 1 Answers
- 719 Views
- I also Faced
- E-Mail Answers
Answer / Bhoopendar Singh
To check for duplicate entries in Excel, follow these steps:
1. Select the entire column of data.
2. Go to the 'Data' tab, and click on 'Remove Duplicates.'
3. A dialog box will appear asking which columns contain unique values (in most cases, select 'All').
4. Click OK.
5. Any duplicate entries will be removed.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you write a summary report?
What are pivot tables used for?
How do I write a formula in excel?
What is vlookup explain with example?
How do I make div 0 disappear in excel?
What is meant by lookup table?
How many rows and columns are in ms excel 2007?
What is lookup value in vlookup?
I know I can use the fill handle (the small black box in the lower-right corner of the range) to copy data and formulas in excel, but is there a way to use it to clearranges in excel?
How do I keep text in one cell in excel?
How can I compare two data in excel?
How do I create column headings in excel?
MS Excel Microsoft 
