Yes Please. It is working perfectly.
Regards
Eugene
On Sat, Jan 26, 2013 at 11:04 PM, ashish koul wrote:
> Hi
>
> Its working at my place . Please find the working file attached
>
>
> Regards
> Ashish Koul
>
>
>
> On Sat, Jan 26, 2013 at 10:58 PM, Eugene Bernard > wrote:
>
>> Mr Koul,
>>
>>
Hi
Its working at my place . Please find the working file attached
Regards
Ashish Koul
On Sat, Jan 26, 2013 at 10:58 PM, Eugene Bernard
wrote:
> Mr Koul,
>
> Tested the macro, the result is not exactly matching requirement requested
> by Chris.
>
> Regards
> Eugene
>
>
> On Sat, Jan 26, 201
Mr Koul,
Tested the macro, the result is not exactly matching requirement requested
by Chris.
Regards
Eugene
On Sat, Jan 26, 2013 at 9:50 PM, ashish koul wrote:
> Try this
>
> Sub sample()
> Dim i As Long, j As Long
>
> Range("a1:b" & Range("a65356").End(xlDown).Row).Sort key1:=Range("a:a"),
Try this
Sub sample()
Dim i As Long, j As Long
Range("a1:b" & Range("a65356").End(xlDown).Row).Sort key1:=Range("a:a"),
order1:=xlAscending, Header:=xln0
For i = 1 To Range("a65356").End(xlUp).Row
j = Application.WorksheetFunction.CountIf(Range("a:a"), Range("a" &
i).Value)
Range("a1").E
Hey there -
a very simple problem that I'm trying to solve without any code if at all
possible. It's so simple that I don't even need to post a workbook:
Imagine you have two columns worth of data whereas the 2nd column is 100%
unique but items in column 1 will appear multiple times such as i