Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i view only the filtered results from autofilter ?
If a use an autofilter on a long list of data, it shows the filtered items at
the top of the page with blue line numbers, but it also shows the remaining results underneath. Is there anyway of just showing the filtered results ? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i view only the filtered results from autofilter ?
Hi Simon,
I think you have a empty row between your data, if it's true, exclude the row and try to filter again hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "simon" escreveu: If a use an autofilter on a long list of data, it shows the filtered items at the top of the page with blue line numbers, but it also shows the remaining results underneath. Is there anyway of just showing the filtered results ? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i view only the filtered results from autofilter ?
thanks, that works a treat. Very Clever.........
"Marcelo" wrote: Hi Simon, I think you have a empty row between your data, if it's true, exclude the row and try to filter again hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "simon" escreveu: If a use an autofilter on a long list of data, it shows the filtered items at the top of the page with blue line numbers, but it also shows the remaining results underneath. Is there anyway of just showing the filtered results ? thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i view only the filtered results from autofilter ?
thanks for the feedback
-- regards from Brazil Thanks in advance for your feedback. Marcelo "simon" escreveu: thanks, that works a treat. Very Clever......... "Marcelo" wrote: Hi Simon, I think you have a empty row between your data, if it's true, exclude the row and try to filter again hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "simon" escreveu: If a use an autofilter on a long list of data, it shows the filtered items at the top of the page with blue line numbers, but it also shows the remaining results underneath. Is there anyway of just showing the filtered results ? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count rows in a filtered list when using AutoFilter? | Excel Worksheet Functions | |||
save filtered results | Excel Discussion (Misc queries) | |||
create sheet from autofilter results | Excel Discussion (Misc queries) | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |