Results 1 to 9 of 9

Extract data by month and year

Threaded View

  1. 05-03-2023, 12:28 PM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Extract data by month and year

    One way (of many):

    =COUNTIFS($C:$C,TEXT(P9,"mmm-yy"),$F:$F,">0")

    see file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to extract Data based on Month & Year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-17-2020, 09:17 AM
  2. [SOLVED] formula to extract month and year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-25-2019, 01:24 PM
  3. Extract month number and year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-28-2019, 12:28 PM
  4. Extract month and year from a cell
    By Wojtek-AU in forum Excel - New Users/Basics
    Replies: 24
    Last Post: 08-15-2016, 02:56 AM
  5. [SOLVED] Extract Year, Month, Day from date
    By stoicy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-28-2016, 11:48 PM
  6. Extract Year, Month, Day from date
    By stoicy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2016, 01:41 PM
  7. Extract data based on month/year to a simple table.
    By maax555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2014, 09:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1