Re: chech if two or more cells = and return a value

Tech-Archive recommends: Fix windows errors by optimizing your registry

Think using a pivot table is quite ideal for your instance, Tom.

Assuming your data in cols A and B,
with headers in row1, eg:

States Job
CA Union
AK Non Union
MI Non Union
ME Union
CA Non Union
etc

Select cols A and B, click Data > Pivot table
Click Next > Next

In step 3 of the wiz, click Layout
Drag n drop States in ROW area
Drag n drop Job in COLUMN area
Drag n drop Job in DATA area
(it'll appear as Count of Job)
Click OK > Finish, That's it.

Hop over to the PT *** for the results

It'll look something like this:

Count of Job Job
States Non Union Union Grand Total
AK 2 1 3
CA 1 2 3
ME 2 1 3
MI 1 2 3
etc

viz it gives you the required unique listing of all the States,
and the breakdown counts of union/non union for each state

For charting, you could tinker by just right-clicking on any cell inside the
pivot table > choose PivotChart. This would instantly yield a chart linked to
the pivot table that you can further dress up to taste.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tom" wrote:


"Tom" wrote:

Hi there Max

I was browsing through the Microsoft Office Discussions Group and noticed
that you were able to help someone out with an Excel 2003 question similar to
what I have for you.

Here is my question:

I have a resume Excel spread*** in which Col. A lists the “states” in
America (i.e. CA, AK, MI, ME, etc …) Column B states if the job position is
“Union” and Column C states if the job position is “Non Union”. What I would
like to do is to “COUNT” the number of “Union” and “Non Union” jobs in ANY
particular state. Could you please assist me with that?. I’d like to graph it
out.

Thank you and have a great day.

With sincere respect,

Tom
.

Quantcast