> I like my solution.
>>>
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>> *From:* Sourabh Salgotra
>>> *Sent:* Sunday, June 03, 2012 12:53 PM
>>> *To:* excel
--
> *From:* dguillett1
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, June 3, 2012 6:55 PM
>
> *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper
> result.
>
> I like my solution.
>
> Don Guillett
> Microsoft MVP
Don,
love it (great reply) :)
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Sunday, June 3, 2012 6:55 PM
Subject: Re: $$Excel-Macros$$ Records found but unable to get proper result.
I like my solution.
Don
Guillett
Microsoft MVP
I like my solution.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sourabh Salgotra
Sent: Sunday, June 03, 2012 12:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Records found but unable to get proper result.
thanks for help.
plz provide
thanks for help.
plz provide index/atch solution also
On Sun, Jun 3, 2012 at 6:35 PM, dguillett1 wrote:
> How about a nice macro? Change your formatting and use in macro enabled
> workbook
>
> Sub filtercopy()
> With Sheets("COURSES").UsedRange
> .AutoFilter Field:=1 'criteria IF needed
>
How about a nice macro? Change your formatting and use in macro enabled workbook
Sub filtercopy()
With Sheets("COURSES").UsedRange
.AutoFilter Field:=1 'criteria IF needed
.AutoFilter Field:=2
.AutoFilter Field:=3, Criteria1:=Sheets("form").Range("n1")
.Offset(1, 3).Resize(, 2).SpecialCell
Hi,
Use Vlookup formula, I think it should help you.
Rgds
On Sun, Jun 3, 2012 at 1:08 PM, Sourabh Salgotra wrote:
>
> Dear sir,
>i am using index/match formula. in my problem i am getting the
> 1st occurrence result only.
> Sr. No. Subject Code Subject/Paper code 1 BF 1 MAT
