lookup duplicate value
One potent pair of simple formulae that delivers all of the duplicate
extractions
Your source data as posted is assumed in A2:C2 down
In E2: =IF(AND($A$2:$A$100="abc")*($B$2:$B$100="def"),ROW (),"")
In F2: =IF(ROWS($1:1)COUNT(E:E),"",INDEX(C:C,SMALL(E:E,R OWS($1:1))))
Copy E2:F2 down to cover the max expected extent of source data, say down to
F100? Minimize col E. Col F returns the required results. arrive`? celebrato,
hit the YES below
--
Max
Singapore
---
":)" wrote:
I have the following lookup formula. It works fine except when the lookup
values are the same, it produces similar results when it should actually
produce another value.
{=INDEX(DATA!$AA$2:$AA$1018,MATCH(1,(DATA!$G$2:$G$ 1018=B29)*(DATA!$R$2:$R$1018=C29),0))}
A B C
1 abc def 123
2 abc def 456
In my data, it sometimes create the above example and thus, the formula
produce the result 123 twice, when it should be 123, followed by 456.
Is there anyone who can help me on this? Thanks in advance
|