| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting into Alphaebeticla orde
I am using Excel 97 and I have a list of surnames in
Column A of a spreadsheet. What I am trying to achieve is to sort them into order but place A Capital letter in the row immediatley above when the lfirst letter changes For example:- A ADAMS ARTHURS ABBOTT B BRIGGS BAMFORTH BENTLEY C CHILDS COLDWELL through to Z What I also need in the routine is an error check so that if a letter of the alphabet does not exist it moves down to the next letter Can anyone assist me with some code to do this please? Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| How to sort XX/XX (the last 2 digits is the year in ascending orde | Excel Discussion (Misc queries) | |||
| Can We Arrange Multiple Sheets of Excel File in Alphabetical Orde | Excel Discussion (Misc queries) | |||
| Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
| Custom Filter that Displays All But in Ascending or Decending Orde | Excel Discussion (Misc queries) | |||
Threaded Mode
