Sorting based on Drop Down choice
Hi,
you can use auto filter.
Thanks,
--
Farhad Hodjat
" wrote:
I have a spreadsheet in which I'd like to be able to sort several
columns at different times (depending on what info I'm interested
in). Is there a way I could get excel to automatically sort the data
based on a selection I make from a drop down?
Example:
A1:A10 are names. B1:B10 are their hours worked. C1:C10 is their
output. D1:D10 is their hourly wage. I'd like a cell (say E1) to be
a drop down with three different options: 'hours worked', 'output',
and 'hourly wage.' Based on which of those three I select, the entire
data set would be sorted based on that criteria.
Can anyone help??
Thanks!
-ADH
|