;
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *resp...@gmail.com
> *Sent:* Sunday, June 03, 2012 4:23 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ L
cel-macros@googlegroups.com]
On Behalf Of resp...@gmail.com
Sent: Sunday, June 03, 2012 4:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks for the explanation. What I like abt this formula is it actually
picks not only the 2nd occurance bu
t;
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 02:42:58
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance
Hi Hilary,
INDEX(NamesRange,1) returns the first row of the range (which is a single
cell since the range is only
cel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks Asa
Attached is what i attempted doing, but after testing my formula this
morning with other examples i realised, its doesnt work for all, i will try
your now. thanks
On Fri, Jun 1, 2012 at 1:06 AM, A
2. Array formula:
=INDEX($B$2:$B$13,SMALL(IF($A$2:$A$13=$A$17,ROW($A$2:$A$13)),2)-ROW($A$2)+1)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: Friday, June 01, 2012 1:34 AM
To: excel-macros@googlegroups.com
Subject
: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks Asa
Attached is what i attempted doing, but after testing my formula this
morning with other examples i realised, its doesnt work for all, i will try
your now. thanks
On Fri, Jun 1, 2012 at 1:06 AM, Asa Rossoff wrote:
Hi Hilary
Thanks Haseeb, will try now, very grateful
On Fri, Jun 1, 2012 at 3:53 PM, Haseeb A wrote:
> Hello Hilary,
>
> If you want to return the exact 2nd occurrance value, you can use VLOOKUP
> like this,
>
> =VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0)
>
> Regards,
> Haseeb
>
> --
Hello Hilary,
If you want to return the exact 2nd occurrance value, you can use VLOOKUP
like this,
=VLOOKUP(A14,INDEX(A:A,MATCH(A14,A:A,0)+1):INDEX(B:B,65536),2,0)
Regards,
Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor threa
---it has
>> less work to do. If there is no match it either returns an NA error or if
>> the only match was on the very last row of the range, a REF error.
>>
>>
>> =INDEX(NamesRange,MATCH(NameToFind,NamesRange,0)+MATCH(NameToFind,INDEX(NamesRange,MATCH(NameToFind,NamesRang
,INDEX(NamesRange,MATCH(NameToFind,NamesRange,0)+1):INDEX(NamesRange,ROWS(NamesRange)),0))
>>
>>
>> ** **
>>
>> Asa
>>
>> ** **
>>
>> -Original Message-
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroup
amesRange)),0))
>
>
> ** **
>
> Asa
>
> ** **
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of resp...@gmail.com
> Sent: Thursday, May 31, 2012 2:01 PM
> To: excel-macros@googlegro
ually be slower since it has the
added countif.
{
=IF(COUNTIF(NamesRange,NameToFind)mailto:excel-macros@googlegroups.com]
On Behalf Of resp...@gmail.com
Sent: Thursday, May 31, 2012 2:01 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thank
Thanks guys I have figured it out with index and match and countif. Thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 31 May 2012 19:42:32
To:
Reply-To: excel-macros@googlegroups.com
Su
13 matches
Mail list logo
