How to Rank item value ignoring empty or blank cells?
Hello. need help on this. I'm trying to rank the item name based on value % (highest to lowest). When one item name has no value % it gives a #NO MATCH on that item row and on the succeeding rows/item. Please see screenshot (sample).
Thank you. 😊
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.