+ Reply to Thread
Results 1 to 2 of 2

Mode with exclusions or top 3 occur?

  1. #1
    Registered User
    Join Date
    08-22-2006
    Posts
    28

    Mode with exclusions or top 3 occur?

    What forumla would I use if I trying to determine the 3 or 4 numbers that occur the most in a range? Could I use Mode and have exclusions or something else? excel 2003 ver thanks

  2. #2
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302
    Suggestion. I'm not an expert at Pivot Tables, but I managed to get one to display the count for all numbers in a range, and it sorted it into order, too. Look at the documentation for Pivot Tables, to get a partially automated answer.
    FrankBoston is the pen name for Andrew Garland, Lexington MA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1