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 Chirs,
I dont think it is possible to from excel only we need to have a macro for
this
regards
prince
On Friday, January 25, 2013 12:56:26 AM UTC+5:30, Chris wrote:
>
> Hey there -
>
> a very simple problem that I'm trying to solve without any code if at all
> possible. It's so simple th
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"),
Hi Richard
just a suggestion - Why don't u consolidate/ merge all the input sheets to
single then create a simple pivot table for ur analysis
below macro will merge data from multiple sheets to single you might have
to do minor changes so that it meets your requirement
Sub merge1()
Dim i As Lon
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
How to quickly select all the values of a column, including the last
Cell of the column is blank: Click to select the final Cell and press
Ctrl + Shift + up arrow and press 2 times.
2013/1/26, Sadia Khalid :
> What is the short cut of select the values of a column if there are missing
>
> values i
What is the short cut of select the values of a column if there are missing
values in the column. Ctrl +Shift + down arrow key is the short cut to
select all the values of a column . how to select all the values of column
if there are missing values.
--
Join official Facebook page of this for
