right, that's what i did. The problem i am running into is that there are
blank cells for entries that have not been entered yet. so when i sort, the
equations like =A1 get messed up. here is what it looks like
Project Name Project status Salesman Date
walmart estimate km 6/21
detail
barlist
estimate, detail, barlist are seperate cells, but when i sort by project
name, i need these three rows to be considered one row.
"Jay" wrote:
i need to keep three rows together while i sort by column. so it will
be groups of three.
i thought to copy the name down three times, but is there a way i can
automate this? this is a sheet that gets updated everyday.
One way is to use a helper column.
I'm supposing that column A has the field to be sorted, and you want to
sort by the first of the three values.
In the helper column, put this in row 1:
=A1
Put the identical formula in rows 2 and 3.
Select the three cells and extend down for the length of the list.
Then select the whole table and sort by the helper column.
|