Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HEADER | |||
---|---|---|---|
K1 | 12 | 23 | 34 |
L1 | 14 | 26 | 65 |
C1 | 33 | 33 | 53 |
D1 | 32 | 98 | 67 |
E1 | 23 | 54 | 66 |
hi Everyone,
above figure is my pivot table and I'm using match to get the order as i want
but whenever I'm selecting the field ,the selected field comes at the top ,suppose i select C1 then
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 |
---|---|---|---|---|
C1 | ||||
K1 | ||||
L1 | ||||
D1 | ||||
E1 |
I want to select C1 without disturbing its order,how can i do this?
Please read these two documents:
in your match function use set analysis
Can you please explain how can i do so?