good time of a day to all!
if anyone knows how to get the ranking function working correctly while ranking the filtered numbers? I hid/filtered the extra rows that are not relevant (but they still contain numbers) and was about to rank the filtered stuff but unfortunately the formula takes into account all rows and columns that sit into reference area...
pls someone advise
my understanding that if we work with filtered data we need to use some kind of relative connections or smth??
thanks a lot in advance!
Ivan
Bookmarks