?B?c3RldmU=?= wrote:

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.

The idea is to sort by the helper column.

Below is an example. Save it in a file with the ".csv" extension.

Double-clicking the csv file should open it in Excel.

Select everything and sort bon the Helper column.

--------------------- cut here ------------------------
Project Name,Project status,Salesman,Date,Helper
walmart,estimate,km,6/21,=A2
,detail,,,=A2
,barlist,,,=A2
sears,estimate,ab,2/13,=A5
,detail,cd,3/22,=A5
,cancelled,tr,4/11,=A5
penney,estimate,mi,6/16,=A8
,detail,,,=A8
,barlist,,,=A8