Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Minif and Maxif function in calc

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. Something like:

A|B|C

URL|Most recent update|first checked [url]|=maxif(S1.B2:B25001,a2,S1.J2:J25001)|=minif(S1.B2:B25001,a2,S1.J2:J25001)

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 v4.4.4.3 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.

Minif and Maxif function in calc

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. Something like:

A|B|C

URL|Most recent update|first checked [url]|=maxif(S1.B2:B25001,a2,S1.J2:J25001)|=minif(S1.B2:B25001,a2,S1.J2:J25001)

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 v4.4.4.3 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.