Robert Mika
MrExcel MVP
- Joined
- Jun 29, 2009
- Messages
- 7,256
I have a spreadsheet with about 6000 words in one column.
I would like to sort them in alphabetic order in another sheet:
First column in this worksheet (A) will host only words starts on A second column B will host only B words.,etc..
I can created formula which will do this by starting always from the first row in the Words spreadsheet but this always will leave empty cells:
Words in column B will start in row where A words have finished, C where B finished and so one.
Any help?
I would like to sort them in alphabetic order in another sheet:
First column in this worksheet (A) will host only words starts on A second column B will host only B words.,etc..
I can created formula which will do this by starting always from the first row in the Words spreadsheet but this always will leave empty cells:
Words in column B will start in row where A words have finished, C where B finished and so one.
Any help?