Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to filter only the numbers I need
I have a list of phone numbers, some of the numbers have multiple numbers
associated with them, some do not. When I autofilter, I see all the numbers I need, but I cannot copy the autofilter list, nor can I select an option to list all the numbers that I see when I open the autofilter. I just need what I see when I autofilter, how can I copy the autofilter list. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to filter only the numbers I need
What does that mean, do you get an error message when you copy them or what?
Normally you just select the range in a filtered list and copy it then paste it somewhere else, you can also try by selecting the visible list, press F5, click special and select visible cell only press enter and then copy. -- Regards, Peo Sjoblom "10john01" wrote in message ... I have a list of phone numbers, some of the numbers have multiple numbers associated with them, some do not. When I autofilter, I see all the numbers I need, but I cannot copy the autofilter list, nor can I select an option to list all the numbers that I see when I open the autofilter. I just need what I see when I autofilter, how can I copy the autofilter list. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to filter only the numbers I need
Are you saying that you use the auto filter to get the numbers you want, and
then you try to copy those numbers and paste them to another worksheet? And are you saying that instead of only copying the visible filtered numbers, it is also copying the non visible numbers? It seems to work for me. When I past, it only pastes the numbers that were visible. Which Excel version are you using? Regards, Paul -- "10john01" wrote in message ... I have a list of phone numbers, some of the numbers have multiple numbers associated with them, some do not. When I autofilter, I see all the numbers I need, but I cannot copy the autofilter list, nor can I select an option to list all the numbers that I see when I open the autofilter. I just need what I see when I autofilter, how can I copy the autofilter list. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to filter only the numbers I need
With list filtered, F5SpecialVisble cells onlyOK
Now copy the highlighted range. Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 07:26:00 -0700, 10john01 wrote: I have a list of phone numbers, some of the numbers have multiple numbers associated with them, some do not. When I autofilter, I see all the numbers I need, but I cannot copy the autofilter list, nor can I select an option to list all the numbers that I see when I open the autofilter. I just need what I see when I autofilter, how can I copy the autofilter list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter works on letters not numbers | Excel Discussion (Misc queries) | |||
filter for even numbers in Excel | Excel Worksheet Functions | |||
scrolling numbers in auto filter? | Excel Discussion (Misc queries) | |||
Keep text filter away numbers | Excel Worksheet Functions | |||
My filter is not working for numbers & text | New Users to Excel |