Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 68

Counting Unique Values with Multiple Criteria

My data contains 2 columns of data

I want to count column A if column B has not already been counted.
A B
1951 X911
2614 X911
2618 X911
2614 X911
1031 X911
2614 X911
2614 WAT
2614 WAT
2614 WAT
2614 WAT
2614 WAT

In other words, I want to see how many different lines of X911. The answer
I want is 3 because there are 3 different numbers associated with X911

HELP!!!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Counting unique values with criteria	Kevin McCartney	Excel Worksheet Functions	10	December 31st 09 04:02 PM
Counting Unique Items with Multiple Criteria	Joe Gieder	Excel Worksheet Functions	3	March 5th 07 10:08 PM
Counting Unique Items with Multiple Criteria	Teethless mama	Excel Worksheet Functions	0	March 2nd 07 11:12 PM
Counting Unique Items with Multiple Criteria	Ron Coderre	Excel Worksheet Functions	0	March 2nd 07 10:51 PM
Counting Unique Values Given Criteria	carl	Excel Worksheet Functions	2	August 20th 05 04:22 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us