Results 1 to 3 of 3

Find the mode for a specific month/year?

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Isle of Man
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    82

    Find the mode for a specific month/year?

    In Sheet1, I have a list of dates in column A with varying words in column B.

    On Sheet2, I want to be able to find the most often occuring word from column B of Sheet1, but only for the month of February 2016.

    Is this possible? I can't wrap my head around it. I've attached an example file to work with, so in this particular example - it would return the value 'Bananas' as this is the most often occuring word for February 2016.

    Many thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. find time left in month.days unit between two dates(in YEAR.MONTH.DAY)
    By xcfeng95 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2014, 12:55 PM
  2. [SOLVED] Find the Month and Year
    By trosasco in forum Excel General
    Replies: 4
    Last Post: 02-04-2014, 11:06 AM
  3. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  4. [SOLVED] Find First, Max, Min, Last value of a month of an year
    By TK2013 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-26-2013, 07:19 PM
  5. Replies: 2
    Last Post: 12-01-2012, 03:06 PM
  6. Replies: 3
    Last Post: 01-14-2012, 02:33 PM
  7. Find month and year
    By mikke in forum Excel General
    Replies: 4
    Last Post: 11-24-2009, 12:19 PM
  8. [SOLVED] How do I find a mode while disregarding a specific cell value?
    By glasskit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2005, 04:06 PM

Tags for this Thread

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