Hi, I have the following formulas that returns the most repeated text in a range that ignores blanks as well but I need to adjust it to only test the visible cells as the data is filtered, can someone help me?
I am not sure which is better but both seem to work, can you help me choose the best one and help me so it only looks at the filtered data (visible cells)?
=INDEX(B22:B10000,MODE(IF(B22:B10000<>"",MATCH(B22:B10000,B22:B10000,0))))
=LOOKUP(1,0/FREQUENCY(0,1/(1+COUNTIF(B22:B10000,B22:B10000))),B22:B10000)
I am not sure which is better but both seem to work, can you help me choose the best one and help me so it only looks at the filtered data (visible cells)?
=INDEX(B22:B10000,MODE(IF(B22:B10000<>"",MATCH(B22:B10000,B22:B10000,0))))
=LOOKUP(1,0/FREQUENCY(0,1/(1+COUNTIF(B22:B10000,B22:B10000))),B22:B10000)