Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I put worksheets in alphabetical order
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 |
#2
|
|||
|
|||
Take a look at
http://cpearson.com/excel/duplicat.htm In article , "DLee" wrote: 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 |
#3
|
|||
|
|||
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 "DLee" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i re-sort multiple worksheets into alphabetical order | Excel Discussion (Misc queries) | |||
Using a macro to sort your data in alphabetical order? | Excel Discussion (Misc queries) | |||
how do i sort excel worksheets by alphabetical order? | Excel Worksheet Functions | |||
how can i sort excel worksheets in alphabetical order? | Excel Worksheet Functions | |||
I want to sort worksheets in a workbook into Alpha order? | Excel Worksheet Functions |