View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Khardy3352 Khardy3352 is offline
external usenet poster
 
Posts: 13
Default Auto filter for multiple columns

I am creating an excel (2003) template using custom views and auto filtering
to create a filtered document from a master document. I have hidden columns
with no problem. I have placed auto filter on one column to show values
greater than one.

In Column A, cells include name, acct# and phone number. Column O contains
dates in every 3rd row and is auto filtered as stated above

A O
Name date1
John smith 1/2/09
acct #
phone number

Jane Smith 2/1/09
acct #
phone number

In my results, I would like to show the rows with customer name and the acct#
Is this possible and if so, how?