Forum Discussion
How to get top 3 employee name who are top scorer in Message Box using VBA
Hi Team..I want to get top 3 Emp Name along with top 3 bids who has top bids using VBA code. I have written a code to get top 3 bids I can get top 3 bids but not able to get Emp Name in same Msg...
This resource may give you a non-VBA method. https://exceljet.net/lessons/how-to-show-top-or-bottom-n-results
Hi..Thanks for the help but I am not looking for an Excel solution,looking for a VBA solution.
OK. Best wishes....I'm not a VBA person.....so one of the other folks around here is going to have to jump in.
In general, I've always been happier when I find a way to accomplish my goal using Excel's amazing array of functions. In some instances, I've been able, doing that, to replace elaborate VBA/macro solutions with Excel functions that operate faster and more accurately by orders of magnitude.
Which isn't to say that there aren't times when VBA is necessary. But so far, I've survived with minimal use of it, and that years ago.