Thread: computer help
View Single Post
  #4  
Old 14th December 2004, 05:25 PM
gizzard gizzard is offline
Member
 
Join Date: Jan 1970
Posts: 30
Default

Have you tried highlighting the data that you want to filter and then Tools => Filter => Autofilter? Or is that not what you mean?
It only restricts the rows that you want to show but does not affect any totals etc.

Another option is perhaps the VLOOKUP or HLOOKUP functions.
Reply With Quote