Hi, if i have list of several data columns and want to filter top5 rezult for one column i use top10 filter, but if i want to filter top5 rezult for one column and then filter the rezults i got again for top2 in another column?
example:
col1 col2
10 10
11 9
12 8
13 7
14 6
15 5
16 4
17 3
18 2
19 1
top10 filter for top5 rezults in col1 give:
col1 col2
15 5
16 4
17 3
18 2
19 1
now i need to get top2 for col2. I can't find the solution.
must look like this
col1 col2
15 5
16 4
Note i must do it in excel 2003
example:
col1 col2
10 10
11 9
12 8
13 7
14 6
15 5
16 4
17 3
18 2
19 1
top10 filter for top5 rezults in col1 give:
col1 col2
15 5
16 4
17 3
18 2
19 1
now i need to get top2 for col2. I can't find the solution.
must look like this
col1 col2
15 5
16 4
Note i must do it in excel 2003
