How can I make the first inputted month is TRUE?
Attached my expected outcome, thank you!!
How can I make the first inputted month is TRUE?
Attached my expected outcome, thank you!!
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.
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)
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.
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
IN B4 then copied down.
=SUMPRODUCT(--(MONTH($A$4:$A4)=MONTH($A4)))=1
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.
Thank you for your help !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks