Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced filter - blanks
id like to filter out the rows that have blanks in a certain column.
what condition do i give for criteria range? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced filter - blanks
Hi
Use an AutoFilter, and select NonBlank as criteria. Hopes this helps. --- Per "Mortir" skrev i meddelelsen ... id like to filter out the rows that have blanks in a certain column. what condition do i give for criteria range? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced filter - blanks
On 8 feb., 10:44, "Per Jessen" wrote:
Hi Use an AutoFilter, and select NonBlank as criteria. Hopes this helps. --- Per "Mortir" skrev i ... id like to filter out the rows that have blanks in a certain column. what condition do i give for criteria range? hi. tnx, but id like to do it with advanced filter plus id like to get the result of advanced filter so that Only the rows that have blanks in a certain column show up |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced filter - blanks
got it. criteria for blanks is "" under the column name with blanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced filter for blanks | Excel Discussion (Misc queries) | |||
Blanks and Advanced Filters | Excel Discussion (Misc queries) | |||
Advanced Filter (Criteria + Blanks) | Excel Discussion (Misc queries) | |||
Advanced filtering on text and blanks | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |