Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 61
Default Microsoft Excel spreadsheet

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default Microsoft Excel spreadsheet

datafilterautofilter

--
Don Guillett
SalesAid Software

"Diana" wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Microsoft Excel spreadsheet

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Query is lost when opening Excel 2002 file dlb Excel Discussion (Misc queries) 0 January 24th 07 12:29 AM
Excel vs. Spreadsheet in MS Works 8.0 helen Excel Discussion (Misc queries) 5 November 24th 06 08:41 AM
Excel Open Dialog Improper Sort [email protected] Excel Discussion (Misc queries) 4 May 17th 06 02:40 PM
How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo D at Spectra Excel Discussion (Misc queries) 0 May 15th 06 07:39 PM
can you use cell references from Microsoft spreadsheet in excel ch Deb Excel Worksheet Functions 0 May 23rd 05 11:40 PM


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"