View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default 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