I have a bit of an odd problem here. Should be really easy but cannot work out how to do it and now it is starting to bug me.
I have a table with column headings made up of the different employers situated in a building. The building names are the row headings. The body of the table contains the percentage share of the different employers of the building. I am now trying to add a column on the end titled "major employer". To populate this column I would need excel to look up the max value in the row and then to return the column heading for that value. I have the following formula but it does not work. I greatly suspect because it only works for "vertical" lookup as opposed the horizontal lookup I am trying to perform.
cells c15:l15 contain the percentage share of the employers.
14 is the number of the row containing the employers name.
I basically want it come back with the name of the employer with the highest percentage contained in cells c15:L15.
Employer1 Employer2 Employer3 Employer4 Building 1 0.26% 0.10% 1.87% 2.55%