Thank you Luke, I'll check it out. I think I've already tried out something like that but I better do it again.
Right now I'm working on filling arrays in VBA so this feature has to wait a couple of days.
@SIRJB7 Thank you for your response. However, this is my first post, though I've been...
Hi all,
I have a hitlist where I've used small(range,n) to create a hitlist of the 10 largest drop in revenue on our customers. The story could have ended right there, only now someone asked if I could make the hitlist a bit more dynamic and combine it with autofilter and show the hitlist for...