You could do this rather easily with Pivot tables or by extracting the unique
values in each column and using Countif() formulas

To calc with pivot tables, start by making sure each column has a text label
as a header, then select one of the data cells and use Data-Pivot table...
Click on the Finish button and in the new sheet that appears drag the column
header for col A onto the Row Fields area, then drag the same column header
into the Data area


"Priscilla" wrote:

Hi,

I want to find out the most frequently occurring value for the below
example. Based on the example below I want to know Column A = Sales, Column
B = s682, which value is the most frequently occurred.

Column A: Column B: Column C:
Sales s682 4
Sales s681 1
Marketing s683 5
Sales s682 4
Finance s682 4
Sales s683 5
Sales s682 2

Thanks,