] *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
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@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
Thanks guys I have figured it out
@googlegroups.com
Subject: RE: $$Excel-Macros$$ Lookup and return 2nd occurrance
=INDEX($A$1:$B$10,MAX(--($A$1:$A$10=A2)*ROW($A$1:$A$10)),2) with CSE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
a...@lovetour.info
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 02:42:58
To: excel-macros@googlegroups.com
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
@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 but the last
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@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup and return 2nd occurrance
** **
Thanks guys I have figured
@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
Sent from my BlackBerry® smartphone from Airtel Ghana
** **
-Original Message-
From: resp
: $$Excel-Macros$$ Lookup and return 2nd occurrance
** **
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
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
Thanks Haseeb, will try now, very grateful
On Fri, Jun 1, 2012 at 3:53 PM, Haseeb A haseeb.avarak...@gmail.com 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)
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: excel-macros@googlegroups.com
Reply-To:
-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
Thanks guys I have figured it out with index and match and countif. Thanks
Sent from my BlackBerryR
12 matches
Mail list logo