You are welcome !!
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't pos
Hi Kris,
Thanks a lot its working, now and i am getting perfect data thanks a lot
kris.
Thank you.
Regards
Lokesh.M
On Wed, Jan 4, 2012 at 7:35 PM, Kris wrote:
> Hi,
>
> Try this macro.
>
> Sub kTest()
>
> Dim k, i As Long, s As String, Flg As Boolean
> Dim x, r As Range, txt As Strin
Hi,
Try this macro.
Sub kTest()
Dim k, i As Long, s As String, Flg As Boolean
Dim x, r As Range, txt As String
Set r = Range("a2:a" & Range("a" & Rows.Count).End(3).Row)
k = r
With CreateObject("scripting.dictionary")
.comparemode = 1
For i = 1 To UBo
Hi Kris,
Its not working, please put button on attached excel fine and send it to me.
Please test once and send back to me sir.
Regards
lokesh.M
On Wed, Jan 4, 2012 at 7:19 PM, Kris wrote:
> Hi
>
> You could try this macro.
>
> Sub kTest()
>
> Dim k, i As Long, s As String, Flg As Boolean
Hi
You could try this macro.
Sub kTest()
Dim k, i As Long, s As String, Flg As Boolean, x
k = Range("j2:j" & Range("j" & Rows.Count).End(3).Row)
With CreateObject("scripting.dictionary")
.comparemode = 1
For i = 1 To UBound(k, 1)
k(i, 1) = Re
Dear Lokesh,
Please try it..
Sub Delete_Date()
For Each Rng In Sheet1.UsedRange
If IsDate(Rng) = True Then
Rng.EntireRow.Delete
End If
Next
End Sub
On Wed, Jan 4, 2012 at 6:23 PM, lokesh wrote:
> Hi Rajan
>
> As discussed, you have solved this query very quickly but i need some
> changes beca
Hi Rajan
As discussed, you have solved this query very quickly but i need some
changes because of every time when i am pulling the data in the
application that time below mentioned names are changed every time. so
want in one click
it shows what ever names are there in cell A those names comes her
In the example Kumar Raje Gowda should be 1.
Another one
=COUNT(INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)):INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)+MIN(IFERROR(MATCH("*",INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)+1):$A$595,0),
Kris
--
FORUM RULES (934+ members already BANNED for violat
Hi Rajan,
Please find a list of data and i want numbers counts under names. And
delete dates in the coloum.
A1 cell (containing name, date, and numbers)
Jack
9/20/2011
120
121
122
123
james
9/21/2011
124
125
126
127
jack
9/22/2011
128
129
130
I need the formula of deleting the dates and count