+ Reply to Thread
Results 1 to 4 of 4

capture first Month

Hybrid View

  1. 12-15-2023, 02:07 AM #1
    jimsenthil
    jimsenthil is offline
    Registered User
    Join Date
    06-03-2019
    Location
    madurai
    MS-Off Ver
    2019
    Posts
    64

    capture first Month

    Formula to capture the first Month
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-15-2023, 02:27 AM #2
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,465

    Re: capture first Month

    Please try in D4 and copy down:
    Formula: copy to clipboard 
    =IFNA(INDEX(E$3:S$3,MATCH(TRUE,E4:S4>0,0)),"-")
    Attached Files Attached Files
    Last edited by HansDouwe; 12-15-2023 at 02:29 AM.
    Reply With QuoteRegister To Reply
  3. 12-15-2023, 02:45 AM #3
    jimsenthil
    jimsenthil is offline
    Registered User
    Join Date
    06-03-2019
    Location
    madurai
    MS-Off Ver
    2019
    Posts
    64

    Re: capture first Month

    thank you. solved
    Reply With QuoteRegister To Reply
  4. 12-15-2023, 02:49 AM #4
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,465

    Re: capture first Month

    You are Welcome!

    Thanks for the feedback and rep .

    Glad to have helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Formula that capture proportion in month
    By hpatel517 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-03-2023, 03:43 PM
  2. Formula / Table Needed: to adjust forecast start month + add month on month growth.
    By Joec15 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2023, 05:25 AM
  3. [SOLVED] Capture real time data/DDE capture
    By rajre in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2022, 05:14 AM
  4. [SOLVED] Return Month-on-Month growth using current month-prior month/prior month per country
    By losincog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2020, 05:37 AM
  5. [SOLVED] Capture date with only month and year, disregard day
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2015, 05:07 PM
  6. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  7. Capture date of every month
    By jamespang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2006, 05:02 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