2 criteria

R

robzrob

Hi

In Col A I have dates, many of the dates appearing more than once and
not in any order in the column, and in Col H I have a Y R or CN
corresponding to each date. I want, in 3 columns, to show the number
of Ys, Rs and CNs for each date.

Hope that's clear!
 
P

plinius

robzrob said:
Hi

In Col A I have dates, many of the dates appearing more than once and
not in any order in the column, and in Col H I have a Y R or CN
corresponding to each date. I want, in 3 columns, to show the number
of Ys, Rs and CNs for each date.

Hope that's clear!

Supposing that dates are in range A2:A27, put in J1 Y, in K1 R and in L1 CN

In I2 formula is:
=SMALL(IF(FREQUENCY($A$2:$A$27,$A$2:$A$27),$A$2:$A$27),ROW(A1))
to fill down until you get dates

In Y2:
=SUM(($A$2:$A$27=$I2)*($H$2:$H$27=J$1))
matricial
to fill down and right

Hi,
E.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top