On sheet one, I have a list of URLs, with duplicates in column B. In column J, I have dates visited.
On sheet two, I have a list of all the URLs from sheet 1, with no duplicates.
On sheet two, I want to lookup the highest date that a URL from sheet one matching the url from sheet two in one column, and the earliest date in another.
URL|Most recent update|first checked
I realize that there is no minif or maxif functions (or if there are, I haven’t found them), but if someone could show me a way to implement something that would work in the same way as they might work, I would really appreciate it.
Oh yeah: Fully updated English language Windows 7 x64 Ultimate edition with Japanese locale, using LibreOffice v220.127.116.11 Calc with en_US locale.
Had no idea what tags I was supposed to use, so please forgive me if I used the wrong ones.