| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort rows w/o losing a picture
My picture is in 4 rows and I need to display all the rows but only want to
sort by 1 cell w/in the rows and not lose the information in the other cells that i would like to display together |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sort rows w/o losing a picture
You need to "associate" the four rows together. Normally done using a helper
column and concatenating a name and row number, like ="Picture1"&"_"&"Row101" ="Picture1"&"_"&"Row102" ="Picture1"&"_"&"Row103" ="Picture1"&"_"&"Row104" And then doing your sort on this column..... hth Vaya con Dios, Chuck, CABGx3 "nbCLE" wrote: My picture is in 4 rows and I need to display all the rows but only want to sort by 1 cell w/in the rows and not lose the information in the other cells that i would like to display together |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
| sort according to the colored rows | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| Sort with multiple header rows | Excel Discussion (Misc queries) | |||
| I want to sort selected cells in Excel, not entire rows. | Excel Discussion (Misc queries) | |||
Linear Mode
