Hi Domenic,

Apologies to you and Teethless mama. I forgot that I'd conditionally
formatted Column "I" to hide errors.

Answered questions below.

Cheers,
Sam

Domenic wrote:
I've read through this thread and find myself somewhat confused.

You mentioned the second criteria was giving you the problem. My
understanding is that the second criteria has to do with Column I.

Yes

However, when I asked for the formula, it looks like the formula you
posted has to do with Column H.

Can you please clarify?

Yes, apologies.

This is the Formula for Column "I"
=INDEX(Hire,LARGE(IF(Date-DAY(Date)+1=DATE(YEAR($A5),MONTH($B$4),1),ROW(Hire )-
MIN(ROW(Hire))+1),1))

By the way, in your first post you mentioned that the formula returned
#NUM!. Does your range contain #NUM! values? You can test it by trying
the following...

=COUNTIF(Range,#NUM!)

Yes, my sincere apologies. I forgot that I'd conditionally formatted Column
"I" to hide errors.

--
Message posted via http://www.officekb.com