I have the following formula which is picking up the largest date, between columns N and Z. However, if there is a date equivalent to the largest in that selection in AC (for example - ie both have 07/05/19) it is blank. If the date in AC is 08/05/19 then it ignores this, and returns the correct value. Can anyone help please?
Code:
=IFERROR(INDEX($N$1:$AB$1,LARGE(IF(MAX(N79:R79,Y79:AB79)=N79:AL79,COLUMN(N79:AB79)-COLUMN(N79)+1),1)),"")
