COUNTIF on range within a range

[Stedman]

I have data (below) where there can be multiple rows for each permit. I need to count the permits based on the MAX number of days it took to review them. So, if one permit had reviews of 1, 3 and 5 days, I need to count only the review that took 5 days.

Can anyone tell me how to look at a range within a range and tell Excel "Only count the permit review with the highest "Days" value?

 

[Stan_C]

Give this a try:

Excel Workbook
	A	B	C	D	E
1	Number	Days
2	1-13-00209	5
3	1-13-00209	6		Number	Max Days
4	1-13-00209	2		1-13-00210	11
5	1-13-00210	4
6	1-13-00210	5
7	1-13-00210	2
8	1-13-00210	1
9	1-13-00210	11
10	1-13-00210	2
11	1-13-00210	1
12	1-13-00210	4
13	1-13-00210	5
14	1-13-00210	6
15	1-13-00210	9
16	1-13-00211	8
17	1-13-00211	7
18	1-13-00212	4
19	1-13-00213	3
Sheet1

 

[Stedman]

Works! Thank you very much!!

 

[Stan_C]

Works! Thank you very much!!

You're Welcome! Thanks for the feedback