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
