Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of em,ployees I want to alphabatize,. It has 2 pages with 2
columns of names on each sheet. I want the first part of the list on page 1 to have the name in the first half of the alphabet and the 2nd sheet to have the second half. currently the first column has A-K and K is on the bottom of the 2nd page and the 2nd column on page 1 startrs with K and goes through S and carries through to the 2nd page and finishes with Z on the 2nd column of page 2. So in short I would like A-K on page 1 in the 2 columns on page 1 and L-Z on page 2 in the 2 columns on page 2 Thanks for the help -- crunchnin numbers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up entry box to auto-alphabatize each entry in list? | Excel Discussion (Misc queries) | |||
How do I alphabatize my files? | Excel Discussion (Misc queries) | |||
How do I auto-alphabatize in XL03? | Excel Discussion (Misc queries) | |||
Alphabatize | Excel Discussion (Misc queries) | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions |