Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

max with condition

I have a spreadsheet which has an ID (in this case of a musical piece) in column C of tab "Lijst".

Now I want to know when this is last performed by our choir and put that in a separate column. The list of music performed is in tabs 2016, 2015, etc. where the ID is in column E en the performance date in column B.

I tried to put in: {=MAX(IF(C2='2016'.$E$2:$E$150,'2016'.$B$2:$B$150))}

That seems to work, but when I pull down this formula all cells report Err:508

How can I make this work? Or is there an easier option to accomplish this?