welcome dear.
Regards
Ashish koul
akoul.blogspot.com
2010/8/27 ҉Shine
> Hi Ashish, Bruno & Maries
>
> Thanks a lot I appreciate your help. All the three solutions work.
>
> Thank you :)
>
> Shine
>
> On 25 August 2010 05:06, Bruno Bruno wrote:
>
>> See if this helps.
>>
>> Regards,
>> Br
Hi Ashish, Bruno & Maries
Thanks a lot I appreciate your help. All the three solutions work.
Thank you :)
Shine
On 25 August 2010 05:06, Bruno Bruno wrote:
> See if this helps.
>
> Regards,
> Bruno
>
> 2010/8/24 ҉Shine
>
>> Thank you Ashish. I appreciate your effort and time you spent for i
Hi! Shine,
Pls. find the attached file. This is also one of the way to solve your query
by using V LOOKUP.
Regards,
Maries
On Mon, Aug 23, 2010 at 5:32 PM, wrote:
> Attached: Lookup Multiple values and display horizontally
> Message from shin...@gmail.com:
>
> Hi
>
> It would be helpful if s
See if this helps.
Regards,
Bruno
2010/8/24 ҉Shine
> Thank you Ashish. I appreciate your effort and time you spent for it. But
> I am looking for a combination function that can do the job. VBA cannot be
> used
>
> Thank you
>
> Best Regards
> Shine
>
>
> On 23 August 2010 20:52, ashish koul
HI
see if this helps you
regards
ashish koul
akoul.blogspot.com
2010/8/24 ҉Shine
> Thank you Ashish. I appreciate your effort and time you spent for it. But
> I am looking for a combination function that can do the job. VBA cannot be
> used
>
> Thank you
>
> Best Regards
> Shine
>
>
> On 23
Thank you Ashish. I appreciate your effort and time you spent for it. But I
am looking for a combination function that can do the job. VBA cannot be
used
Thank you
Best Regards
Shine
On 23 August 2010 20:52, ashish koul wrote:
> hi sort your data on item basis first
>
> try this
>
>
> Sub Ma
hi sort your data on item basis first
try this
Sub Macro1()
Dim i, z, k, t As Long
t = 2
z = Application.WorksheetFunction.CountA(ActiveSheet.Range("a:a"))
k = 2
For i = 2 To z
If Range("a" & i + 1).Value <> Range("a" & i).Value Then
Range("B" & k & ":B" & i).Select
Selection.Copy
Attached: Lookup Multiple values and display horizontally.xls
Sent using Google Docs http://docs.google.com/
Hi
It would be helpful if someone can provide a solution without using VBA
I have a series of data as shown on left side of the sheet. I want to get a
summary of it as shown on right s
