geomano
09-29-2017, 12:21 AM
Hello, I am struggling to create a formula, which will count the most frequent values from column A, based on the values from column B. For instance, I would like to check the top 3 (most frequent ones) text values in column A, but only for the ones which have value equal to 1 in column B, same would go for the values in col A, but with 2, 3 in col B etc. I'd appreciate some suggestions. Many thanks.