software

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.
Dmitry,

Select a blank column next to your filtered database, use Edit / Go to... Special Visible Cells
Only then press OK. Then type quot;Filteredquot; 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 quot;Filtered Outquot; and press Ctrl-Enter.

HTH,
Bernie
MS Excel MVPquot;Dmitry Kopnichevquot; gt; wrote in message ...
gt; Hello
gt; How to get a reverse filter list? I have a filtered by many complex filters
gt; list. I want to get a list of items, which were filtered out by those
gt; filters?
gt; Excel version is 2003 sp2.
gt;
gt;
Thanks Bernie. I'm trying this.
quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; сообщил/сообщила в новостях
следующее: ...
gt; Dmitry,
gt;
gt; Select a blank column next to your filtered database, use Edit / Go to...
Special Visible Cells
gt; Only then press OK. Then type quot;Filteredquot; without the quotes, and press
Ctrl-Enter. Then remove
gt; the filters, filter the new column for blanks, then select those cells,
use Edit Go To special
gt; Visible Cells IK, then type quot;Filtered Outquot; and press Ctrl-Enter.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Dmitry Kopnichevquot; gt; wrote in message
...
gt; gt; Hello
gt; gt; How to get a reverse filter list? I have a filtered by many complex
filters
gt; gt; list. I want to get a list of items, which were filtered out by those
gt; gt; filters?
gt; gt; Excel version is 2003 sp2.
gt; gt;
gt; gt;
gt;
gt;
How to quot;filter the new column for blanksquot;?
quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; сообщил/сообщила в новостях
следующее: ...
gt; Dmitry,
gt;
gt; Select a blank column next to your filtered database, use Edit / Go to...
Special Visible Cells
gt; Only then press OK. Then type quot;Filteredquot; without the quotes, and press
Ctrl-Enter. Then remove
gt; the filters, filter the new column for blanks, then select those cells,
use Edit Go To special
gt; Visible Cells IK, then type quot;Filtered Outquot; and press Ctrl-Enter.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Dmitry Kopnichevquot; gt; wrote in message
...
gt; gt; Hello
gt; gt; How to get a reverse filter list? I have a filtered by many complex
filters
gt; gt; list. I want to get a list of items, which were filtered out by those
gt; gt; filters?
gt; gt; Excel version is 2003 sp2.
gt; gt;
gt; gt;
gt;
gt;
I selected the column, selected quot;Autofilterquot;, then seleted Blanks!
Thanks!
quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; сообщил/сообщила в новостях
следующее: ...
gt; Dmitry,
gt;
gt; Select a blank column next to your filtered database, use Edit / Go to...
Special Visible Cells
gt; Only then press OK. Then type quot;Filteredquot; without the quotes, and press
Ctrl-Enter. Then remove
gt; the filters, filter the new column for blanks, then select those cells,
use Edit Go To special
gt; Visible Cells IK, then type quot;Filtered Outquot; and press Ctrl-Enter.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;Dmitry Kopnichevquot; gt; wrote in message
...
gt; gt; Hello
gt; gt; How to get a reverse filter list? I have a filtered by many complex
filters
gt; gt; list. I want to get a list of items, which were filtered out by those
gt; gt; filters?
gt; gt; Excel version is 2003 sp2.
gt; gt;
gt; gt;
gt;
gt;
Dmitry,

Select the new column (click on the letter heading above row 1), use Data / Filter / Auto Filter...
Then on the drop down, select quot;Blanksquot; - down at the bottom.

HTH,
Bernie
MS Excel MVPquot;Dmitry Kopnichevquot; gt; wrote in message ...
gt; How to quot;filter the new column for blanksquot;?
gt; quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; сообщил/сообщила в новостях
gt; следующее: ...
gt;gt; Dmitry,
gt;gt;
gt;gt; Select a blank column next to your filtered database, use Edit / Go to...
gt; Special Visible Cells
gt;gt; Only then press OK. Then type quot;Filteredquot; without the quotes, and press
gt; Ctrl-Enter. Then remove
gt;gt; the filters, filter the new column for blanks, then select those cells,
gt; use Edit Go To special
gt;gt; Visible Cells IK, then type quot;Filtered Outquot; and press Ctrl-Enter.
gt;gt;
gt;gt; HTH,
gt;gt; Bernie
gt;gt; MS Excel MVP
gt;gt;
gt;gt;
gt;gt; quot;Dmitry Kopnichevquot; gt; wrote in message
gt; ...
gt;gt; gt; Hello
gt;gt; gt; How to get a reverse filter list? I have a filtered by many complex
gt; filters
gt;gt; gt; list. I want to get a list of items, which were filtered out by those
gt;gt; gt; filters?
gt;gt; gt; Excel version is 2003 sp2.
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;