;
> ** **
>
> 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
om
Sender: <mailto:excel-macros@googlegroups.com>
excel-macros@googlegroups.com
Date: Thu, 31 May 2012 19:42:32
To: < <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com>
Reply-To: <mailto:excel-macros@googlegroups.com>
excel-macros@googlegroups.com
Sub
: 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
l.com
>> Sent: Thursday, May 31, 2012 2:01 PM
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance****
>>
>> ** **
>>
>> Thanks guys I have figured it out with index and match and countif. Thanks
>>
,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
Subject: $$Excel-Macros$$ Lookup and return 2nd occurrance
Hello Excel Masters
if I have a list if names like below in column A and say I have corresponding
different figures in column B.
Hilary
Rajan
Maries
Noorain
Hilary
Rajan
Don
Kris
Asa
And so on and I want to return for instance the
Hello Excel Masters
if I have a list if names like below in column A and say I have corresponding
different figures in column B.
Hilary
Rajan
Maries
Noorain
Hilary
Rajan
Don
Kris
Asa
And so on and I want to return for instance the second occurance of hilary with
its corresponding figure. Kind
14 matches
Mail list logo
