+ Reply to Thread
Results 1 to 9 of 9

How can I make the first inputted month is TRUE?

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    HK
    MS-Off Ver
    excel 2010
    Posts
    11

    How can I make the first inputted month is TRUE?

    How can I make the first inputted month is TRUE?

    Attached my expected outcome, thank you!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: How can I make the first inputted month is TRUE?

    Why would the first inputted month be TRUE?
    What rule would say it's TRUE?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: How can I make the first inputted month is TRUE?

    May be try in

    B4=IF(SUMPRODUCT(--(MONTH($A$4:A4)=MONTH(A4)))=1,TRUE,FALSE)

    copy down
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,408

    Re: How can I make the first inputted month is TRUE?

    In B4:

    =A4=MIN(IF(MONTH($A$4:$A$11)=MONTH(A4),$A$4:$A$11))

    ... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Once confirmed, drag copy down.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: How can I make the first inputted month is TRUE?

    FWIW: if, per your sample, your data is sorted by date you really don't need an array / sumproduct, i.e.:

    =TEXT(A4,"mmmyy")<>TEXT(A3,"mmmyy")
    copied down

    should suffice

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How can I make the first inputted month is TRUE?

    IN B4 then copied down.

    =SUMPRODUCT(--(MONTH($A$4:$A4)=MONTH($A4)))=1
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 10-22-2019 at 09:40 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  7. #7
    Registered User
    Join Date
    07-16-2019
    Location
    HK
    MS-Off Ver
    excel 2010
    Posts
    11

    Re: How can I make the first inputted month is TRUE?

    Thank you for your help !!

  8. #8
    Registered User
    Join Date
    07-16-2019
    Location
    HK
    MS-Off Ver
    excel 2010
    Posts
    11

    Re: How can I make the first inputted month is TRUE?

    Quote Originally Posted by kvsrinivasamurthy View Post
    IN B4 then copied down.

    =SUMPRODUCT(--(MONTH($A$4:$A4)=MONTH($A4)))=1
    Thank you for your help !! Would your simply explain the equation ?

  9. #9
    Registered User
    Join Date
    07-16-2019
    Location
    HK
    MS-Off Ver
    excel 2010
    Posts
    11

    Re: How can I make the first inputted month is TRUE?

    Quote Originally Posted by XLent View Post
    FWIW: if, per your sample, your data is sorted by date you really don't need an array / sumproduct, i.e.:

    =TEXT(A4,"mmmyy")<>TEXT(A3,"mmmyy")
    copied down

    should suffice
    Thank you for your help !!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] sum if true and certain month
    By mbsmeltzer in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-29-2019, 01:20 AM
  2. How to make an inputted video always start as playing fullscreened?
    By Taz97 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2018, 11:54 AM
  3. How to make a formula/function look at the most recently inputted cells
    By craigodo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2013, 04:46 PM
  4. week beginning on a monday depending on month inputted
    By mfairhurst1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-01-2013, 07:11 PM
  5. how to make checkbox true selecting then chaning 2nd box true when null
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2012, 01:13 PM
  6. how to make a IF statement true
    By ltjohnson in forum Excel General
    Replies: 10
    Last Post: 06-06-2012, 02:09 AM
  7. Replies: 5
    Last Post: 06-21-2011, 09:10 AM

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