Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Priscilla
 
Posts: n/a
Default Mode

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,

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 19 July 18th 05 06:09 PM
How do I display more than one mode in a cell? Tyler Maciolek Excel Worksheet Functions 1 June 17th 05 04:01 AM
Mode Function with Criteria DaveShoe Excel Worksheet Functions 1 April 6th 05 06:22 PM
Combo Box goes to edit mode even if design mode is in OFF position Chas Excel Discussion (Misc queries) 0 January 7th 05 07:21 PM
coverting answer from Radian mode to degree mode Xmastrzman Excel Worksheet Functions 1 November 10th 04 04:45 PM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"