Find the nth row that meets multiple conditions

[CSpeelm1]

I have an Excel table of data with multiple fields. For simplicity, let say one field is Region and another is StartDate. I am trying to find a formula that would give me the row number for the nth value that meets conditions for both fields (let's say Region = "North" and StartDate > 12/31/2010). I found an array formula that will work with one condition, but not both. Any thoughts?

Thanks!

 

[barry houdini]

Try

=SMALL(IF(Region="North",IF(StartDate>DATE(2010,12,31),ROW(Region))),n)

cnfirmed with CTRL+SHIFT+ENTER

 

[Dryver14]

If you wanted to change selection each time this might work for you but will require a column for True False

Excel Workbook
	A	B	C	D
1	8		fred	21/04/2011
2
3
4
5
6
7	tony	22/04/2011	False
8	fred	21/04/2011	true
9	bob	23/04/2011	False
10	angel	22/04/2011	False
Sheet1

 

[CSpeelm1]

Thanks for the replies! Barry, your solution worked perfectly! I appreciate the help.