:11
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name
Hi Sunita,
Please try it..
=INDEX($B$3:$B$16,SMALL(IF($K33=$P$3:$P$16,ROW($B$3:$B$16),""),COUNTIF($K$24:K33,K33))-2)
with ctrl+shift+enter
or
=OFFSET($B$2,SMALL(IF($K24=$P$3
; ** **
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Shaik Wa
gt;> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Shaik Waheed
>> Sent: 25 June 2012 12:32
>> To: excel-macros@googlegroups.com
>>
>>
>> Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name
>>
>&
s@googlegroups.com
Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name
PFA
On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
Dear all,
It has always been previlege to query on this group whenever needed and thanks
from heart.
I need one help regarding finding out
ulate the name.
>>
>> Warm Regards
>> Ankur Aggarwal
>> 91-8010614628
>> Analyst
>> Mckinsey Knowledge Center
>> Mckinsey & Co.
>>
>> --------------
>> *From:* NOORAIN ANSARI
>> *To:* excel-macros@googlegr
legroups.com
> *Sent:* Monday, 25 June 2012 1:29 PM
> *Subject:* Re: $$Excel-Macros$$ need help on maximum value and thier name
>
> Hi Sunita,
>
> Please you can also use..
>
> Through Vlookup
>
> *=VLOOKUP(LARGE($B$2:$B$15,1),CHOOSE({1,2},$B$2:$B$15,$A$2:$A$15),2,0)
&
& Co.
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Monday, 25 June 2012 1:29 PM
Subject: Re: $$Excel-Macros$$ need help on maximum value and thier name
Hi Sunita,
Please you can also use..
Through Vlookup
=VLOOKUP(LARGE($B$2:$B$15,1),CHOOSE({1,2},$B$2
Hi Sunita,
Please you can also use..
Through Vlookup
*=VLOOKUP(LARGE($B$2:$B$15,1),CHOOSE({1,2},$B$2:$B$15,$A$2:$A$15),2,0)
*
Through Lookup
*=LOOKUP(2,1/((LARGE($B$2:$B$15,1)=$B$2:$B$15)),$A$2:$A$15)
*
Through Indirect
*=INDIRECT("A"&MATCH(LARGE($B$1:$B$15,1),$B$1:$B$15,0))
*
See attached sh
Thanx :)
On Mon, Jun 25, 2012 at 1:08 PM, Shaik Waheed wrote:
> Hi Sunita,
>
> In my case, I have used filters since it becomes more easier
>
> On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल wrote:
>
>> did you filtre the column?
>> thank you
>>
>> On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed
Hi Sunita,
In my case, I have used filters since it becomes more easier
On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल wrote:
> did you filtre the column?
> thank you
>
> On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed wrote:
>
>> PFA
>>
>>
>> On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrot
Can you please little explain about 1 in last
=INDEX($A$2:$A$15,MATCH(I2,$B$2:$B$15,0),1)
Thank you,
On Mon, Jun 25, 2012 at 12:51 PM, Anil Gawli wrote:
>
> Pls find attached sheet FY Ref.
> On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
>
>> Dear all,
>>
>> It has always been previle
did you filtre the column?
thank you
On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed wrote:
> PFA
>
>
> On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
>
>> Dear all,
>>
>> It has always been previlege to query on this group whenever needed and
>> thanks from heart.
>>
>> I need one help re
Pls find attached sheet FY Ref.
On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
> Dear all,
>
> It has always been previlege to query on this group whenever needed and
> thanks from heart.
>
> I need one help regarding finding out maximum number and their name in one
> cell ?
>
> Have a won
PFA
On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
> Dear all,
>
> It has always been previlege to query on this group whenever needed and
> thanks from heart.
>
> I need one help regarding finding out maximum number and their name in one
> cell ?
>
> Have a wonderful day !!
>
> Thank you
14 matches
Mail list logo
