Excel Data Sorting
OK, so you have the sheet filtered and are attempting to sort after
filtering? That will sort the visible cells, but that means they sort
everywhere within the sheet.
You can sort first, then filter. This all depends on what you are trying to
do.
"Cheryl" wrote:
I am not a technical person and this might be the wrong group, but I have to
start somewhere. I have autofilters on my excel (2003 version) spreadsheet,
but when I try to sort within the filters it does not sort correctly...it
leaves in things I don't want and separates the data I do want with some of
that I don't want. This leaves me with incorrect numbers for reports. Any
Suggestions please?
Cheryl
|