Working on a project and I need to identify the most frequent values in a column range that has blanks without the blanks being counted. Example if range C3:c412 has texts such as N4339A, N44321, N44329 and multiple blanks that will eventually be filled, how to I found the most frequent value without the blanks causing an error. I cannot use VBA. Thanks!