I have a spreadsheet with 60 columns and 1500 rows of data. For each row I need to idenitify the column with the maximum value (I used the MAX function and it worked fine). My problem is, I need to identify the column that contains the maximum value. For example: MAX(g2:bv2) max value is 5.7 belonging to column L2. Each column has a distinct column heading. Any suggestions?