Diana

Look at DataFilter. 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

On Sun, 4 Feb 2007 12:56:01 -0800, Diana
wrote:

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?