Forum Discussion
creating a top of the charts board
hey guys, I produce a leaderboard each month for our top salespeople. its been run the same way for years. but I wanted to give it an overhaul but coming up against my poor excel know-how. I want to ...
I changed the sequence of your columns, just because it made more sense to me to show the change in connection with the most recent month's results. The idea behind the formula, though, could still work in the layout you originally had.
This is no doubt also a great example of where the new LET function would be useful. I didn't use it because I have no experience yet, but for my own learning I will go and try it. It would make the formula less lengthy, since it would no longer be necessary to repeat the "MATCH" function so many times.