I have an Excel 2010 table which consists of some Client details and the 12 months of the year as column headings. For each Client row there is a sales amount in ONE of the January to December columns.
I want to populate a new column (called Month) depending on which Jan to Dec column has the sales amount. So, if a sales figure of £5,600 is in the column headed 'April', then I want the Month column to be populated with the text item "April".
Is there a more efficient way of calculating this than using a large nested IF formula testing each cell in the Jan to Dec columns ?
I've attached a cut-down version of the sheet for clarity.
Thanks in anticipation