Need help with a formula that detects highest number in a col based on 2 matching criteria

Hi Guys,

I recently used a formula that worked well but breaks for unknown reasons. I was hoping that someone can tell me why it is breaking and also a solution to fix the formula so that it will not break again. Please let me know if any additional information is needed.

This is the information I am working with and the expected results in Column D:

	A	B	C	D (does not exist yet - this is where the formula is inserted)
1	Apples	Iris	234	NO
2	Apples	Iris	235	NO
3	Apples	Iris	236	YES

Formula used in Column D:

Formula:

Please Login or Register  to view this content.

Goal: I am trying to get Column D to display YES for the rows matching the critieria specified that contain the highest number in column C (I have other rows with varying other info for A, B, and C columns)

Problem: Column D is showing as all NO even though clearly C3 is the highest number. When I change any of the numbers in column C to higher than 999, the corresponding D column of that row suddenly becomes YES.

Thanks in advance for your help!

Thanks so much worked out great!