Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sorting
i have a worksheet that has tables (for lack of a better word) that are ten
rows long. it has about 100 of these tables. the heading for each table is in the upper most left art of each table. is there a way that i can sort by using that cell? something that will give me the rows beneath it when it is selected. i have a sample copy of the worksheet but dont know how to post it. it would clear up what i am askin if anyone is interested in helping. thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...chart/200703/1 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sorting
Some thoughts ..
Assuming the top left table header cells are in A1, A11, A21, ..., place in an adjacent col just to the right of the tables, eg in E1 (assuming the tables are in cols A to D): =OFFSET(INDIRECT("A"&INT((ROW(A1)-1)/10)*10+1),,) Copy E1 down as far as required. Then select cols A to E, sort by col E ascending/descending. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TimB via OfficeKB.com" <u32108@uwe wrote in message news:6f606c6154a6b@uwe... i have a worksheet that has tables (for lack of a better word) that are ten rows long. it has about 100 of these tables. the heading for each table is in the upper most left art of each table. is there a way that i can sort by using that cell? something that will give me the rows beneath it when it is selected. i have a sample copy of the worksheet but dont know how to post it. it would clear up what i am askin if anyone is interested in helping. thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...chart/200703/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting | Excel Discussion (Misc queries) | |||
sorting | New Users to Excel | |||
sorting | Excel Discussion (Misc queries) | |||
sorting | Excel Discussion (Misc queries) |