Hi Deepak,
you can also use MIN with if condition with CSE
like {=MIN(IF($C$3:$C$9=G3,$D$3:$D$9))}
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 4:47 PM, अनिल नारायण गवली
wrote:
> Dude i want the Shiptocode of that minimum value.
>
>
>
> On Tue, Mar 26, 2013 at 4:44 PM, De
Hi Anil,
Just paste the following formula in Cell J8 and Drag it out.
=INDEX(C6:$F$20,MATCH(SMALL(F6:$F$20,(ROW($F$6:$F$20)-MIN(ROW($F$6:$F$20))+1)),$F$6:$F$20,0),3)
with CSE
Regards
Prince
On Tuesday, March 26, 2013 4:27:59 PM UTC+5:30, अनिल नारायण गवली wrote:
>
> Dear Friends,
>
>
>
Dude i want the Shiptocode of that minimum value.
On Tue, Mar 26, 2013 at 4:44 PM, Deepak Singh wrote:
> Hi friend,
>
> Use below formula with CTR + SHift + Enter...
>
> =MIN(IF($E$6:$E$20=I8,$F$6:$F$20))
>
> Thanks and Regards
> Deepak Singh
>
>
> On Tuesday, March 26, 2013 4:27:59 PM UTC+5:3
