Use advanced filter in recoding macro
See this
http://www.youtube.com/watch?v=B_sd5lJX65M
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hanumant shinde
Sent: Friday, August 05, 2011 10:50 PM
To: Excel Group
Subject: $$Excel-Macr
=VLOOKUP(B35;B25:C31;2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anwar Mohd
Sent: Thursday, July 28, 2011 6:48 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need formula to summarize based on multiple
crteria
Hi Experts,
Sub delRow()
LastRow = Range("j" & Rows.Count).End(xlUp).Row
For Each cl In Range("j2:j" & LastRow)
If cl = 0 Then
cl.EntireRow.Delete
End If
Next cl
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Thursd
PUT THIS FORMULA IN "C2"
=IF(COUNTA(B:B)mailto:excel-macros@googlegroups.com]
On Behalf Of kannan excel
Sent: Saturday, May 28, 2011 7:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Matching excel formula
Hi Excel Guru,
i don't want to enter same mobile number. so
in a
Selection
@omar - try this
Sub InsertRowChange()
Dim i, j, k, z As Long
k = Range("a65356").End(xlUp).Row
Debug.Print k
For i = k To 2 Step -1
If Not IsEmpty(Cells(i, 1)) And Not IsEmpty(Cells(i - 1, 1)) Then
If Cells(i, 1).Text <> Cells(i -
Selection
Just add add the following to the condition
If Sheets(1).Cells(i, 1).Text <> Sheets(1).Cells(i - 1, 1).Text and
Len( Sheets(1).Cells(i - 1, 1).Text) > 0 Then
On Wed, Feb 23, 2011 at 1:51 PM, Omar wrote:
When we run macro again it insert two blank lines
From: exc
When we run macro again it insert two blank lines
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, February 23, 2011 6:24 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Insert Row after Change in Value in
Range("a:a").RemoveDuplicates 1, xlNo
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Saturday, January 15, 2011 6:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unique records
check the attachement see if it h
r column2 then you
can base your pivot table on this column to get your solution.
Hope that helps,
Anand Kumar
On Jan 14, 2:23 am, "Omar" wrote:
> I have a pivot table
>
> how to use " Or" in two columns
>
> I want to view all rows which
>
iS there any help?
I have a pivot table
how to use " Or" in two columns
I want to view all rows which
Column1 = "cat" Or column2 = "cat"
Not
Column1 = "cat" AND column2 = "cat"
By code or any way
Thanks!
--
-
I have a pivot table
how to use " Or" in two columns
I want to view all rows which
Column1 = "cat" Or column2 = "cat"
Not
Column1 = "cat" AND column2 = "cat"
By code or any way
Thanks!
--
--
Some
visit :
http://excel-para-todos.blogspot.com/2009/08/convertir-numeros-letras-en-excel.html
number to words.
2009/8/8 sachin patil
> Dear Mr. Ayush,
>
> I gone thru your Numbers+in+Words(Rs) file which is uploaded in Group.
>
> But if i use this formula in my normal excel file, it's not working
Visit :
http://excel-para-todos.blogspot.com/2009/08/convertir-numeros-letras-en-excel.html
number to words.
2009/8/8 sachin patil
> Dear Mr. Ayush,
>
> I gone thru your Numbers+in+Words(Rs) file which is uploaded in Group.
>
> But if i use this formula in my normal excel file, it's not working
13 matches
Mail list logo