Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort
Hi!
In cells A1 to A20 codes of products, and in columns B to L associated data, name, and some other data about it. In cells O1 to O20 I have also that codes but in order that I want. How to sort codes and associated data in columns A to L in the same order like the codes in column O??? Please help! Ana -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200910/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort
Go to Tools - Options, Custom list. In the box to import a list, input
$O$1:$O$20. Click Add. Now, select all the data you want sorted, and go to Data - Sort. Click the Options button, and then choose the custom list that you want to use as a key. Then make sure you choose to sort by the A column. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ana via OfficeKB.com" wrote: Hi! In cells A1 to A20 codes of products, and in columns B to L associated data, name, and some other data about it. In cells O1 to O20 I have also that codes but in order that I want. How to sort codes and associated data in columns A to L in the same order like the codes in column O??? Please help! Ana -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200910/1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort
I did as you said but I get nothing, when I come to Add he just ignores me,
says "Cell without simple text were ignored." I also made a mistake by telling I have A1 to A10 , but acctualy I have A1 to A520. Maybe that's the reason? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200910/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
how can I hide sort ascending and sort descending options in the . | Excel Discussion (Misc queries) |