View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luvin lunch Luvin lunch is offline
external usenet poster
 
Posts: 2
Default Filter for value 1 in two columns

Hi,

I have two columns: Tutor 1; Tutor 2. Both columns contain tutor
initials, e.g. AA, BB, CC. So the initials AA could appear in the
Tutor 1 or Tutor 2 columns. I need to know all of the work that AA
has done. How can I filter my excel 2003 to show me all rows
containing AA either in the Tutor 1 column or in the Tutor 2 column.

Will I have to do it in VBA? Am I missing something?

All help gratefully received.

LL