View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tamara
 
Posts: n/a
Default formula looking up multiple information.

Here's an example of what I'm trying to do:

ColA ColB ColC ColD
L1 15 15 tin
L2 15 plea
L3 15 tin
L4 19 19 tin
L5 19 19 serial
L6 22 22 tin

I would like to know how many items in column c there are for each number in
column A. If however tin and plea appear in the same group, they would only
count as 1.

"Tamara" wrote:

Excel 2003. I'm wanting a formula that encompasses all 3 requirements:
1. If a number in column A appears multiple times in column B.
2. Then if 2 different pre-determinded names appear in column C (there's
one name per cell) that are in the same rows as the numbers found in column
B.
3. Bring back the count of times the number appears in column B, less the
number of times the 2 names appear in column C (if only 1 name appears, just
the total count of numbers found in column B)