I am trying to work through a formula that will pull back column heading values based upon the total of each particular column heading for a given row.
In my attachment, "Shoulder" gets pulled back as the most common injury type based upon the data in Column A.
What I then need is for the cell below where "Shoulder" populates (B12) to pull back the most common injury type from the data in C2:G8. So in the instance of shoulder, it should say "Strain" below "Shoulder". I also need it to pull back the second most common injury type, in the cell below that, which would be "Sprain" (these points are outlined in the example data). I also need this to be able to adjust based upon what is pulled back as the most common injury, as the "Shoulder" cell can change value depending on the team that is being looked at within the report.
Bookmarks