Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 criteria
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 criteria
"robzrob" ha scritto nel messaggio ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
have input box. Need criteria entered to refer to cond. format criteria | Excel Programming |