Brombrough
New Member
- Joined
- Apr 10, 2017
- Messages
- 49
Hi,
Thanks in advance.
Found on "Mr Excel" the Following Formula to find a first blank cell in a Column
=MATCH(9.99999999999999E+307,Orders!$D:$D)
But I need Orders!$B:$B = "Outstanding" as well.
How do I find the first Row(No) where both are true?
ps would prefer a none array formula
Regards
Thanks in advance.
Found on "Mr Excel" the Following Formula to find a first blank cell in a Column
=MATCH(9.99999999999999E+307,Orders!$D:$D)
But I need Orders!$B:$B = "Outstanding" as well.
How do I find the first Row(No) where both are true?
ps would prefer a none array formula
Regards