Hello,
I have a problem and I don't know how to do it could someone please help me?
The problem is I want to combine IF and OFFSET formula in Data Validation together to make one formula. The following link is from Chandoo and it is what I want to combine Please Click here
I want to combine the formula in Problem 1 and Problem 2 together so that way I could have top 5 most used items by certain departments and also a full list when I click on it, could someone help me please?!?!
Thank you so much!
Kind Regards
Bookmarks