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.

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" <kopn@bk.ruDelete> wrote in message news:ePbFznDHGHA.3036@tk2msftngp13.phx.gbl...
> 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.
>
>

Thanks Bernie. I'm trying this.
"Bernie Deitrick" <deitbe @ consumer dot org> сообщил/сообщила в новостях
следующее: news:upj8u0DHGHA.2836@TK2MSFTNGP14.phx.gbl...
> 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" <kopn@bk.ruDelete> wrote in message
news:ePbFznDHGHA.3036@tk2msftngp13.phx.gbl...
> > 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.
> >
> >
>
>

How to "filter the new column for blanks"?
"Bernie Deitrick" <deitbe @ consumer dot org> сообщил/сообщила в новостях
следующее: news:upj8u0DHGHA.2836@TK2MSFTNGP14.phx.gbl...
> 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" <kopn@bk.ruDelete> wrote in message
news:ePbFznDHGHA.3036@tk2msftngp13.phx.gbl...
> > 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.
> >
> >
>
>

I selected the column, selected "Autofilter", then seleted Blanks!
Thanks!
"Bernie Deitrick" <deitbe @ consumer dot org> сообщил/сообщила в новостях
следующее: news:upj8u0DHGHA.2836@TK2MSFTNGP14.phx.gbl...
> 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" <kopn@bk.ruDelete> wrote in message
news:ePbFznDHGHA.3036@tk2msftngp13.phx.gbl...
> > 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 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" <kopn@bk.ruDelete> wrote in message news:uOfuA$DHGHA.596@TK2MSFTNGP10.phx.gbl...
> How to "filter the new column for blanks"?
> "Bernie Deitrick" <deitbe @ consumer dot org> сообщил/сообщила в новостях
> следующее: news:upj8u0DHGHA.2836@TK2MSFTNGP14.phx.gbl...
>> 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" <kopn@bk.ruDelete> wrote in message
> news:ePbFznDHGHA.3036@tk2msftngp13.phx.gbl...
>> > 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.
>> >
>> >
>>
>>
>
>