ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I sort rows w/o losing a picture (https://www.excelbanter.com/excel-worksheet-functions/89967-how-do-i-sort-rows-w-o-losing-picture.html)

nbCLE

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

CLR

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



All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com