Results 1 to 9 of 9

count number of times a text appeared in a month in given range of dates and names

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    count number of times a text appeared in a month in given range of dates and names

    Hi,
    In sheet1 I have date in column 'A' & 'H' and names in column 'B' & 'I'

    In sheet2 I have month ( Jan to Dec) in column 'A' and in columns B to J are the Names.
    I am trying to count in sheet2 how many times that the name has appeared in particular month in sheet1 in the columns given.

    If any one can help please
    sample file is attached

    Kind regards
    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. [SOLVED] Count number of times the month has appeared
    By Rianne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2013, 10:35 PM
  2. Replies: 4
    Last Post: 02-24-2012, 08:12 AM
  3. Counting number of times a Text pattern appeared in a range
    By khalidawan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2008, 05:35 AM
  4. Replies: 2
    Last Post: 10-18-2005, 04:05 PM
  5. Replies: 1
    Last Post: 10-18-2005, 02:05 PM

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