Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

Pivot Table is the simplest solution, so the best IMO. Just for fun a (very) complicated formula solution.

I tried to explain in the spreadsheet itself.

FindMax.ods

Regards

Hi

Pivot Table is the simplest solution, so the best IMO. Just for fun a (very) complicated formula solution.

I tried to explain in the spreadsheet itself.

FindMax.ods

[EDIT]

New version with formula for col F (I hope I have understood your request?) council recordPys.ods

Regards