Carley
New Member
Hello Hoping that someone can assist,
I have a formula which I want to bring back the oldest outstanding record for the current month.
I have a worksheet named Outstanding which has three columns
Column A has date range showing
One for outstanding not refered (Column B)
One for refered to one team and still outstanding (Column c)
One for referred to other team and still outstanding (Column d)
On the front sheet I have the array formula as follows but is showing #N/A error
{=IF(IF(MIN(IF(Outstanding!B95:B124=0,"",Outstanding!A95:A124),IF(Outstanding!D95:D124=0,"",Outstanding!A95:A124),IF(Outstanding!C95:C124=0,"",Outstanding!A95:A124))=0,10000,MIN(IF(Outstanding!B95:B124=0,"",Outstanding!A95:A124),IF(Outstanding!D95:D124=0,"",Outstanding!A35:A124),IF(Outstanding!C95:C124=0,"",Outstanding!A35:A124)))=10000,"Complete",MIN(IF(Outstanding!B95:B124=0,"",Outstanding!A95:A124),IF(Outstanding!D95:D124=0,"",Outstanding!A95:A124),IF(Outstanding!C95:C124=0,"",Outstanding!A95:A124)))}
Please can someone assist as to where I have gone wrong?
I have a formula which I want to bring back the oldest outstanding record for the current month.
I have a worksheet named Outstanding which has three columns
Column A has date range showing
One for outstanding not refered (Column B)
One for refered to one team and still outstanding (Column c)
One for referred to other team and still outstanding (Column d)
On the front sheet I have the array formula as follows but is showing #N/A error
{=IF(IF(MIN(IF(Outstanding!B95:B124=0,"",Outstanding!A95:A124),IF(Outstanding!D95:D124=0,"",Outstanding!A95:A124),IF(Outstanding!C95:C124=0,"",Outstanding!A95:A124))=0,10000,MIN(IF(Outstanding!B95:B124=0,"",Outstanding!A95:A124),IF(Outstanding!D95:D124=0,"",Outstanding!A35:A124),IF(Outstanding!C95:C124=0,"",Outstanding!A35:A124)))=10000,"Complete",MIN(IF(Outstanding!B95:B124=0,"",Outstanding!A95:A124),IF(Outstanding!D95:D124=0,"",Outstanding!A95:A124),IF(Outstanding!C95:C124=0,"",Outstanding!A95:A124)))}
Please can someone assist as to where I have gone wrong?