How do I put worksheets in alphabetical order

D

DLee

I have created a database which has been worked on by someone else.

I have made the necessary alterations but how do I check for duplicate
entries on each worksheet.

Thansk
 
B

Bill Ridgeway

First you need two helper columns -
One column to give each row a number - so that you can at least get it
back to the same order as it started.
One column to contain a formula =IF(a2=a1,1,0) (where column A is
suspected to have duplicated cells)

Sort on the suspicious column

Find any incidents of 1 in the second helper column. This indicates a
duplication.

Regards.

Bill Ridgeway
Computer Solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting personal templates alphabetically in Office 365 for mac OS? 3
Space at end of multi page list to accommodate new entries 1
How can the font and size of (all) citation numbers be altered? 1
How to sync OL365 contacts and calendar to iPhone without iTunes? 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Saving files in alphabetical order 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Merging from an Excel file with graphics 1

Top