Yes. You can establish a criteria range and put in conditions like equal to
, less than, greater than using the operators
Header1
="<=21"
for example.
for multiple columns, being on the Same row is an AND relation and in
sequential rows is an OR relation.
You can have a computed condition as well. You use a dummy column name for
this (shouldn't match any column name in the data and the formula refers to
the first row of data.
Excel help is fairly good for explaining the possibilities and has examples.
--
Regards,
Tom Ogilvy
"Dave" wrote in message
u...
Hi Gord,
Nice, I didn't realise that Advanced Filter could handle whole rows for
unique records.....
Do you know if it is possible to use criteria with Advanced Filter in VBA?
When I've used Advanced Filter with VBA I've always inserted a blank
column,
added the criteria criteria, done the filtering then removed the inserted
column.
Thanks
Dave
<Gord Dibben wrote in message
...
ali
Recorded macro.....
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 12/14/2003 by Gord Dibben
Sheets.Add
''inserts a sheet and copies unique rows to A1 on new sheet
Sheets("Day").Range("C1:H500").AdvancedFilter Action:=xlFilterCopy,
_
CopyToRange:=Range("A1"), Unique:=True
End Sub
Gord Dibben Excel MVP
On Sun, 14 Dec 2003 16:21:04 -0600, ali
wrote:
Tom, apologies for missing your question. In response, i am only
interested if the whole row matches another.
In response to the suggestion to use macro recorder and advanced
filter... when i tried it the advanced filter part was not recorded.
Is this normal?
Thanks for all the help
---
Message posted from http://www.ExcelForum.com/