mardi 11 septembre 2018

Outpout value in Excel if MAX is TRUE

I have a table where I log currency values per day. I then have a column where I sum all the values per month. I want to have a cell where I output the name of the month with the MAX value for the whole table. I'm pretty sure I can get what I need by using a Pivot Table but, sadly, I'm a complete moron when it comes to Pivot Tables, couldn't get one done correctly to safe my life!!

Please help!

Thanks a lot!!

Aucun commentaire:

Enregistrer un commentaire