Thread: Mode
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Mode

Tools DataAnalysis Histogram follow the menus........

Vaya con Dios,
Chuck, CABGx3



"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,