Dear All,
This is a query on one of the Lukes's post in Chandoo.org (Formula Forensics No. 003 – Lukes Reward).
Here in the specified formula we can have only one condition can be fulfilled ie., in the below example it is cell D2. what if i need to add more that one condition say <2 .
{=IF(COUNTIF(A:A,$D$2)<ROWS($G$2:G2),"",INDEX(B:B,SMALL(IF(A:A=$D$2,ROW(B:B)),ROW(A1))))}
i tried to edit the formula but was not successful.
Luke, if you see this post...can you pls help me on this?
Thanks in advance,
Dee...
This is a query on one of the Lukes's post in Chandoo.org (Formula Forensics No. 003 – Lukes Reward).
Here in the specified formula we can have only one condition can be fulfilled ie., in the below example it is cell D2. what if i need to add more that one condition say <2 .
{=IF(COUNTIF(A:A,$D$2)<ROWS($G$2:G2),"",INDEX(B:B,SMALL(IF(A:A=$D$2,ROW(B:B)),ROW(A1))))}
i tried to edit the formula but was not successful.
Luke, if you see this post...can you pls help me on this?
Thanks in advance,
Dee...