Thanks EB..!
Karan Singh
On Wed, Nov 14, 2012 at 7:32 PM, >>Excel Beginner<< wrote:
> Hi Karan,
>
> use this CSE formula
>
>
> "=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8&$B$1:$B$8=G3&H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))"
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Be
Hi Karan,
use this CSE formula
"=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8&$B$1:$B$8=G3&H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))"
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Nov 14, 2012 at 1:08 PM, Karan Singh wrote:
> Dear All,
>
> Please suggest me to get value fro
You can also use..
=SUMPRODUCT(($A$2:$A$8=G3)*($B$2:$B$8=H3)*($C$2:$C$8))
On Wed, Nov 14, 2012 at 1:15 PM, NOORAIN ANSARI wrote:
> Dear karan,
>
> Please try it..
>
>
> =INDEX($C$2:$C$8,SMALL(IF(($A$2:$A$8=$G3)*($B$2:$B$8=$H3),ROW($C$2:$C$8),""),COUNTIFS($A$2:$A$8,G3,$B$2:$B$8,H3))-1)
>
> press
Dear karan,
Please try it..
=INDEX($C$2:$C$8,SMALL(IF(($A$2:$A$8=$G3)*($B$2:$B$8=$H3),ROW($C$2:$C$8),""),COUNTIFS($A$2:$A$8,G3,$B$2:$B$8,H3))-1)
press ctrl+shfit+enter
see attached sheet for more reference.
On Wed, Nov 14, 2012 at 1:08 PM, Karan Singh wrote:
> Dear All,
>
> Please suggest
