hey all,
i have some data i need to filter in 3 fields but can't get it to work hope somone can help in someway or suggest a work around in some way
data is similar to
Subject 1 .......1/9/14......42
Subject 2 ........2/9/14.....32
Subject 1.........1/9/14.....56
I need it filtered so it has subject by date and the hours field (col C) organised by highest to lowest.
Subject 1.....1/9/14....56
Subject 1.....1/9/14.....42
Subject 2 .....2/9/14.....32
above is an example of the desired outcome
any ideas would be great it's given me such a headache today.
...yes i've obviously tried the sort method in Excel
note: what appears to be Col, A,B,C above is really E,K,M if that makes a difference.
I'd welcome a work around as am totally lost on getting this working.
i have some data i need to filter in 3 fields but can't get it to work hope somone can help in someway or suggest a work around in some way
data is similar to
Subject 1 .......1/9/14......42
Subject 2 ........2/9/14.....32
Subject 1.........1/9/14.....56
I need it filtered so it has subject by date and the hours field (col C) organised by highest to lowest.
Subject 1.....1/9/14....56
Subject 1.....1/9/14.....42
Subject 2 .....2/9/14.....32
above is an example of the desired outcome
any ideas would be great it's given me such a headache today.
...yes i've obviously tried the sort method in Excel
note: what appears to be Col, A,B,C above is really E,K,M if that makes a difference.
I'd welcome a work around as am totally lost on getting this working.