H
Help with cell function
when I try to sort a spreadsheet by certain columns, why does it mix
everything up?
everything up?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
TedMi
"mix everything up" is not very informative. More information, please: What
columns are in your data range? By what columns are you sorting? What is the
result you get?
-TedMi
columns are in your data range? By what columns are you sorting? What is the
result you get?
-TedMi
T
trip_to_tokyo
Be careful when you highlight the data that you want to sort: make sure that
you have included all the required rows and columns.
It might be that you are not including everything and this is why things are
becoming mixed up.
If you highlight all of the required data I always find it works for me 100%
of the time.
If my comments have helped please hit Yes.
you have included all the required rows and columns.
It might be that you are not including everything and this is why things are
becoming mixed up.
If you highlight all of the required data I always find it works for me 100%
of the time.
If my comments have helped please hit Yes.
F
Fred Smith
If you have empty rows or columns, that can mess up a sort. Better
spreadsheet design is no empty columns or rows -- use column width and row
height to adjust spacing.
Regards,
Fred
spreadsheet design is no empty columns or rows -- use column width and row
height to adjust spacing.
Regards,
Fred
T
trip_to_tokyo
Just came across the article that may help / be of assistance:-
http://www.pcw.co.uk/personal-computer-world/features/2249478/hands-question-spreadsheets-q5
If my comments have helped please hit Yes.
Thanks
http://www.pcw.co.uk/personal-computer-world/features/2249478/hands-question-spreadsheets-q5
If my comments have helped please hit Yes.
Thanks