T Tech56 Member Oct 22, 2019 #1 Hi I have this formula: {=IFERROR(MAX(IF((Table2[Service]=$E7)*(Table2[Vehicle]=$G$4),Table2[Last Date])),"")} When there aren't any dates yet yields: 1/0/1900 Is there a way to have the result blank instead? Thank you
Hi I have this formula: {=IFERROR(MAX(IF((Table2[Service]=$E7)*(Table2[Vehicle]=$G$4),Table2[Last Date])),"")} When there aren't any dates yet yields: 1/0/1900 Is there a way to have the result blank instead? Thank you
Chihiro Excel Ninja Oct 22, 2019 #2 Try... {=IFERROR(MAX(IF((Table2[Service]=$E7)*(Table2[Vehicle]=$G$4)*(Table2[last Date]<>""),Table2[Last Date])),"")}
Try... {=IFERROR(MAX(IF((Table2[Service]=$E7)*(Table2[Vehicle]=$G$4)*(Table2[last Date]<>""),Table2[Last Date])),"")}
T Tech56 Member Oct 22, 2019 #3 Thanks but it still yields 1/0/1900. I would like it to be blank thank you. See the column in the sheet '2011 Ford F150' Attachments Vehicle Service 10.5 #1.xlsm 159.5 KB · Views: 8
Thanks but it still yields 1/0/1900. I would like it to be blank thank you. See the column in the sheet '2011 Ford F150'
GraH - Guido Well-Known Member Oct 22, 2019 #4 Perhaps change to = if Table2[last Date]= "" , "", your formula?
Chihiro Excel Ninja Oct 22, 2019 #5 Try below then. =IFERROR(LOOKUP(2,1/((Table2[Service]=[@Service])*(Table2[Vehicle]=$G$4)),Table2[Last Date]),"")
Try below then. =IFERROR(LOOKUP(2,1/((Table2[Service]=[@Service])*(Table2[Vehicle]=$G$4)),Table2[Last Date]),"")