View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eric H Eric H is offline
external usenet poster
 
Posts: 16
Default autofilter function

If you can sort by what you are trying to isolate, then you can assemble your
data so that it is contiguous. You can then cut and paste your data.
Another solution might be a Pivot Table.

"Kevin H" wrote:

I am using Excel 2003 and need to use the autofilter function to group small
groups of related keywords from a list of over 1300 keyword phrases. I can
do the custom search using "contains", but when I cut the results and paste
to a different column not all the results show. Somtimes just the first
result. Other times when I paste the filtered results there is other data in
there that wasn't in the filter results. Can someone explain how to cut and
paste autofilter results.

Thanks,

Kevin H.