Hello -

I have a spreadsheet (2007) and need to mark the first instance of a "1" occurring in one column, but only if the "1" is within a given range of numbers in another column.

I attached an example spreadsheet. In column D (highlighted yellow), I did what I need manually. Is there a formula that can be placed in D to do this automatically?

Example_MultCriteria.xls

Basically, each Person (column A) saw 10 Videos (column B) and they recognized something (a "Hit", column C). I want to mark the first point they recognized something in each video. Each video might have multiple Hits, but I only want to mark/flag the first Hit.

Thoughts?