Hi there,

did my investigation, but not success so far. Here's the scenario:

Both Col-A & Col-B can be filled in or not. If Col-B is filled, Col-A is as well.

Within Col-C, I need to retrieve the MAX date from Col-A, for that related "string" (and not for the empty cell). To do so, I need obviously to exclude (ie: using isnumber) the empty fields...

Col-A Col-B Col-C
empty empty
1.2.2014 string1 1.8.2016
empty empty
1.9.2015 string2 1.8.2018
1.8.2018 string2 1.8.2018
empty empty
1.8.2016 string1 1.8.2016

I tried, sumproduct in conjunction with max, but can only retrieve the row reference, not the value itself... otherwise, it returns #values...

Any ideas from your expert views?

Thanks in advance!