Excell Formulas
 

I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job #.
If I wanted to see all of company "A's" Jobs over the last year, how would I
do this? Thank you

Look in Help under the keyword FILTER
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tara" wrote in message
...
I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job
#.
If I wanted to see all of company "A's" Jobs over the last year, how would
I
do this? Thank you

Hi

assuming your column headings are in row 1 and your list of jobs start in
row 2 with no totally blank rows between each job, click in A2 choose data /
filter / autofilter ...
click on the little arrow that appears on the company name column and choose
the company you want
you can also filter on the date column - to get the info for a specific year
use the arrow and the word custom
in the first box choose
greater than or equal to and in the date box type the 1/1/05
choose
and
and then choose
less than or equal to and type 12/31/05

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tara" wrote in message
...
I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job
#.
If I wanted to see all of company "A's" Jobs over the last year, how would
I
do this? Thank you

Tara wrote:
I have a job list of all jobs we have in our shop, is has about 1500
customers on it with a company name, job description, date, P.O. # and Job #.
If I wanted to see all of company "A's" Jobs over the last year, how would I
do this? Thank you

High light the entire sheet then go to Date Filter Auto filter
This will put a dropdown box at the top of every column. Go to
the Company field hit the drop down and select the Company you would like
to see.

gls858