| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to get a reverse filter list?
Hello
How to get a reverse filter list? I have a filtered by many complex filters list. I want to get a list of items, which were filtered out by those filters? Excel version is 2003 sp2. |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
How to get a reverse filter list?
Dmitry,
Select a blank column next to your filtered database, use Edit / Go to... Special Visible Cells Only then press OK. Then type "Filtered" without the quotes, and press Ctrl-Enter. Then remove the filters, filter the new column for blanks, then select those cells, use Edit Go To special Visible Cells IK, then type "Filtered Out" and press Ctrl-Enter. HTH, Bernie MS Excel MVP "Dmitry Kopnichev" wrote in message ... Hello How to get a reverse filter list? I have a filtered by many complex filters list. I want to get a list of items, which were filtered out by those filters? Excel version is 2003 sp2. |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
How to get a reverse filter list?
Thanks Bernie. I'm trying this.
"Bernie Deitrick" <deitbe @ consumer dot org сообщил/сообщила в новостях следующее: ... Dmitry, Select a blank column next to your filtered database, use Edit / Go to... Special Visible Cells Only then press OK. Then type "Filtered" without the quotes, and press Ctrl-Enter. Then remove the filters, filter the new column for blanks, then select those cells, use Edit Go To special Visible Cells IK, then type "Filtered Out" and press Ctrl-Enter. HTH, Bernie MS Excel MVP "Dmitry Kopnichev" wrote in message ... Hello How to get a reverse filter list? I have a filtered by many complex filters list. I want to get a list of items, which were filtered out by those filters? Excel version is 2003 sp2. |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
How to get a reverse filter list?
How to "filter the new column for blanks"?
"Bernie Deitrick" <deitbe @ consumer dot org сообщил/сообщила в новостях следующее: ... Dmitry, Select a blank column next to your filtered database, use Edit / Go to... Special Visible Cells Only then press OK. Then type "Filtered" without the quotes, and press Ctrl-Enter. Then remove the filters, filter the new column for blanks, then select those cells, use Edit Go To special Visible Cells IK, then type "Filtered Out" and press Ctrl-Enter. HTH, Bernie MS Excel MVP "Dmitry Kopnichev" wrote in message ... Hello How to get a reverse filter list? I have a filtered by many complex filters list. I want to get a list of items, which were filtered out by those filters? Excel version is 2003 sp2. |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
How to get a reverse filter list?
I selected the column, selected "Autofilter", then seleted Blanks!
Thanks! "Bernie Deitrick" <deitbe @ consumer dot org сообщил/сообщила в новостях следующее: ... Dmitry, Select a blank column next to your filtered database, use Edit / Go to... Special Visible Cells Only then press OK. Then type "Filtered" without the quotes, and press Ctrl-Enter. Then remove the filters, filter the new column for blanks, then select those cells, use Edit Go To special Visible Cells IK, then type "Filtered Out" and press Ctrl-Enter. HTH, Bernie MS Excel MVP "Dmitry Kopnichev" wrote in message ... Hello How to get a reverse filter list? I have a filtered by many complex filters list. I want to get a list of items, which were filtered out by those filters? Excel version is 2003 sp2. |
|
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
How to get a reverse filter list?
Dmitry,
Select the new column (click on the letter heading above row 1), use Data / Filter / Auto Filter... Then on the drop down, select "Blanks" - down at the bottom. HTH, Bernie MS Excel MVP "Dmitry Kopnichev" wrote in message ... How to "filter the new column for blanks"? "Bernie Deitrick" <deitbe @ consumer dot org сообщил/сообщила в новостях следующее: ... Dmitry, Select a blank column next to your filtered database, use Edit / Go to... Special Visible Cells Only then press OK. Then type "Filtered" without the quotes, and press Ctrl-Enter. Then remove the filters, filter the new column for blanks, then select those cells, use Edit Go To special Visible Cells IK, then type "Filtered Out" and press Ctrl-Enter. HTH, Bernie MS Excel MVP "Dmitry Kopnichev" wrote in message ... Hello How to get a reverse filter list? I have a filtered by many complex filters list. I want to get a list of items, which were filtered out by those filters? Excel version is 2003 sp2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| advanced filter | Excel Worksheet Functions | |||
| Need help with mailing list | Excel Discussion (Misc queries) | |||
| Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
| Update master list with other lists | Excel Worksheet Functions | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
Linear Mode
