How do I sort rows w/o losing a picture

N

nbCLE

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
 
C

CLR

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
 
Top