Microsoft Excel spreadsheet

[Diana]

If I had a Microsoft Excel spreadsheet for several months and have entered
data for 1,000 customer problems, how would I use the spreadsheet to find all
of the problems for a particular customer?

 

[Don Guillett]

data>filter>autofilter

 

[Gord Dibben]

Diana

Look at Data>Filter. Either auto or advanced.

For working with filters see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html


Gord Dibben MS Excel MVP