Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Excel advanced filter be used in "and NOT" mode
Can Excel 2000 advanced filter be used to select rows in a list that do not
match the comparison criteria? Or, otherwise, once advanced filter is employed and a list a matching rows is identified, can the hidden rows be selected and copied? |
#2
|
|||
|
|||
Why don't you use <criteria, that way you would get those rows only and can
copy and paste them? meaning that is you for instance filter on =criteri or criteria if you reverse that to <criteria or <=criteria Regards, Peo Sjoblom Regard "Robert" wrote: Can Excel 2000 advanced filter be used to select rows in a list that do not match the comparison criteria? Or, otherwise, once advanced filter is employed and a list a matching rows is identified, can the hidden rows be selected and copied? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|