Hi Experts,
I need macro /formula for query given in attached file. The result should
come based on values given in column A.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
h
Solution Attached
On 16/07/2013 14:10, Mukesh Kumar wrote:
Hi Experts,
I need macro /formula for query given in attached file. The result
should come based on values given in column A.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s =TIME(
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is
coming twice in result. Can it also come single time.
Regards,
Mukesh Kumar
On Tue, Jul 16, 2013 at 1:48 PM, De Premor wrote:
> Solution Attached
>
>
> On 16/07/2013 14:10, Mukesh Kumar wrote:
>
>> Hi Experts,
>>
>> I n
Ups sorry, my mistake
i've attached new file for revision
Rgds,
[dp]
On 16/07/2013 15:27, Mukesh Kumar wrote:
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar
is coming twice in result. Can it also come single time.
Regards,
Mukesh Kumar
On Tue, Jul 16, 2013 at 1:48 P
Hi, Mukesh Try to change this code:
*For Each Rng In Data**
**If RangeCriteria.Cells(Rng.Row, 1) = Criteria Then Buf.Add
Rng.Value, Rng.Value**
**Next**
*
to
*For Each Rng In Data**
**i = i + 1**
**If RangeCriteria.Cells(i, 1) = Criteria Then Buf.Add
Rng.Va
Thanks DP Sir, the code is now working perfectly.
Regards,
Mukesh Kumar
On Wed, Jul 17, 2013 at 6:40 AM, De Premor wrote:
> ignore my last email, i've made some change in variable declaration
> PFA
>
>
> On 17/07/2013 7:32, De Premor wrote:
>
> Hi, Mukesh Try to change this code:
>
> *For