so I have a spreadsheet... Columns: date (one row) Jobsite (one row)
Contractors (1-10 rows) When I arrange my cells in descending or ascending
order it only arranges the rows with the actual date on them. Is there any
way to arrange the cells to where if the rows does NOT have a date on there
it is still arranged in the proper place. (NOTE: I WILL NOT PUT MULTIPLE
CONTRACTORS ON ONE CELL BECAUSE IT WILL RUIN MY GRAPHS THAT ARE LINKED TO MY
SPREADSHEET)

If anyone need to see my spreadsheet I would gladly send it to them for any
suggestions. I'm having quite a bit of trouble with it.

short answer is no, excel sort assumes each row is a unique chunk of data, it
sounds like you would have to totally re-do the spreadsheet to get it to sort
correctly.

"HoganD87" wrote:

> so I have a spreadsheet... Columns: date (one row) Jobsite (one row)
> Contractors (1-10 rows) When I arrange my cells in descending or ascending
> order it only arranges the rows with the actual date on them. Is there any
> way to arrange the cells to where if the rows does NOT have a date on there
> it is still arranged in the proper place. (NOTE: I WILL NOT PUT MULTIPLE
> CONTRACTORS ON ONE CELL BECAUSE IT WILL RUIN MY GRAPHS THAT ARE LINKED TO MY
> SPREADSHEET)
>
> If anyone need to see my spreadsheet I would gladly send it to them for any
> suggestions. I'm having quite a bit of trouble with it.

are selecting all of the data before you sort, or just the one column?
are the other cells based on formulas with relative cell referencing or
absolute cell referencing.

"HoganD87" wrote:

> so I have a spreadsheet... Columns: date (one row) Jobsite (one row)
> Contractors (1-10 rows) When I arrange my cells in descending or ascending
> order it only arranges the rows with the actual date on them. Is there any
> way to arrange the cells to where if the rows does NOT have a date on there
> it is still arranged in the proper place. (NOTE: I WILL NOT PUT MULTIPLE
> CONTRACTORS ON ONE CELL BECAUSE IT WILL RUIN MY GRAPHS THAT ARE LINKED TO MY
> SPREADSHEET)
>
> If anyone need to see my spreadsheet I would gladly send it to them for any
> suggestions. I'm having quite a bit of trouble with it.