Hi thanks for the quick reply! I have tried to adapt that formula but keep receiving error. Maybe it'll help if you can see the table i wish to able it to. I have posted the spreadsheet. The table i am referring to is the big two way table to the right. The red cell is where i wish for the value to be appear. I aim to check the biggest value in the last row of the table (row 112) and according to the biggest value, i would like the corresponding column title to be entered in the cell. thanks again!
Bookmarks