Hi all,
Got a database with some 175 document numbers that I need to extract the top 10 from (based on value). Have been working with a combination of INDEX, MATCH and LARGE function and I managed to get a top 10.
The current code:
=INDEX(PIVOT!$B:$B;MATCH(1;INDEX((PIVOT!$D:$D=LARGE(PIVOT!$D:$D;ROWS(D$1:D1)))*(COUNTIF(D$1:D1;PIVOT!$B:$B)=0)
;0))
- PIVOT!B:B = Document number
- PIVOT!D:D = Value of document
My struggle now is to get two different criteria included in it. So it should be a top 10 of document numbers that have:
1. Due date "<24-11-2014" (Found in PIVOT!C:C)
2. Document number "<3900143000" (Found in PIVOT!B:B)
Hoping that anyone here can help me find a way to do this!?
Thanks in advance!
Got a database with some 175 document numbers that I need to extract the top 10 from (based on value). Have been working with a combination of INDEX, MATCH and LARGE function and I managed to get a top 10.
The current code:
=INDEX(PIVOT!$B:$B;MATCH(1;INDEX((PIVOT!$D:$D=LARGE(PIVOT!$D:$D;ROWS(D$1:D1)))*(COUNTIF(D$1:D1;PIVOT!$B:$B)=0)
- PIVOT!B:B = Document number
- PIVOT!D:D = Value of document
My struggle now is to get two different criteria included in it. So it should be a top 10 of document numbers that have:
1. Due date "<24-11-2014" (Found in PIVOT!C:C)
2. Document number "<3900143000" (Found in PIVOT!B:B)
Hoping that anyone here can help me find a way to do this!?
Thanks in advance!