Accounting for duplicates when using INDEX/MATCH forumulas

Hello,

This is a very specific question to a very specific problem, that is described in text boxes on the attached spreadsheet.

Basically (as possible) I have a INDEX/MATCH formula that is looking for the lowest value that falls within a date range. There are 3 date ranges that the table covers. All works well UNLESS the lowest value within 1 date range is identical to the lowest value within another date range. In this case, the lowest value for theearlier date range and associated times/dates/values/etc are assigned to both date ranges.

Please have a look at the attachment and hopefully the question will be more clear.

Thanks!

Hi
=SMALL(IF(($F$20:$F$32>=$P8)*($F$20:$F$32<=$Q8),$I$20:$I$32,""),1) CSE

=INDEX($F$20:$F$32,MATCH(SMALL(IF(($F$20:$F$32>=$P5)*($F$20:$F$32<=$Q5),$I$20:$I$32,""),1),IF(($F$20:$F$32>=$P5)*($F$20:$F$32<=$Q5),$I$20:$I$32,""),0)) cse

Originally Posted by martindwilson

change c34 to say screen instead of screening then you can use
=INDEX($F$20:$F$32,MATCH(C34&I34,INDEX($C$20:$C$32&$I$20:$I$32,0),0))

This worked perfectly. QUick and easy. Thanks Martin.

Eisayew, thanks for your suggestions as well. Still working on them, they just didn't seem to work on the first try.