Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort 2 columns alphbetic and make dictionary
I'm Mahmoud from Egypt
and recently joined to ur group I have a problem with excel file , and need help from u or anyone can help to solve the problem I have a dictionary excel file contains 2 columns in about 40 pages now I need to sort all the data alphbetic the problem is I can sort only one column and cann't sort the second one ... I tried to put all words in one column and made sort ...but the problem now I can not devide the words of the dictionary file into 2 columns can u help me Thanks Mahmoud |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort 2 columns alphbetic and make dictionary
DataSort by Column A and then by Column B as the second sort Column.
-- Regards Dave Hawley www.ozgrid.com "Mahmoud Mustafa" wrote in message ... I'm Mahmoud from Egypt and recently joined to ur group I have a problem with excel file , and need help from u or anyone can help to solve the problem I have a dictionary excel file contains 2 columns in about 40 pages now I need to sort all the data alphbetic the problem is I can sort only one column and cann't sort the second one .. I tried to put all words in one column and made sort ...but the problem now I can not devide the words of the dictionary file into 2 columns can u help me Thanks Mahmoud |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort 2 columns alphbetic and make dictionary
I'd put all the data in one column, do the sort, then split the data again.
Another alternative would be to put the data into MSWord. It has some nice formatting features (including using multiple columns for displaying your list of words). And MSWord allows you to sort that list, too. Mahmoud Mustafa wrote: I'm Mahmoud from Egypt and recently joined to ur group I have a problem with excel file , and need help from u or anyone can help to solve the problem I have a dictionary excel file contains 2 columns in about 40 pages now I need to sort all the data alphbetic the problem is I can sort only one column and cann't sort the second one .. I tried to put all words in one column and made sort ...but the problem now I can not devide the words of the dictionary file into 2 columns can u help me Thanks Mahmoud -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort 2 column in the same time "" as dictionary "" | Excel Worksheet Functions | |||
Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Excel Worksheet Functions | |||
Sort by color: Is there an easy way to sort columns or rows in EX | Excel Worksheet Functions | |||
sort by two columns ends up with wrong sort in 2nd col | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) |