Hi, I have used match and this seems to work fine, but I just wondered if anyone has a better /different approach to the problem,
I want a true false to use as filter in a pivot t , so I want eg true = Year 1 and month 2,3,4 and Year 2 and month 3,4,
so ; dr = Date range ;
and then dropped into the filter, so if anyone wants to suggest a better approach I'd be interested.
Please Login or Register to view this content.
Richard
This produces the same result:
=BYROW(H4:H67,LAMBDA(dr,OR(AND(YEAR(dr)=B4,ISNUMBER(MATCH(TEXT(dr,"mmm"),C4:C6,0))),AND(YEAR(dr)=D4,ISNUMBER(MATCH(TEXT(dr,"mmm"),E4:E6,0))))))
This might be better placed in Charting & Pivots - shall I move the thread for you?
Last edited by AliGW; 06-23-2024 at 12:28 AM. Reason: Additional information added.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Or try this:
=LET(dr,TEXT(H4:H67,"yyyymmm"),a,TEXTJOIN(";",1,IF(C3:E3="Month",B4:D4&C4:E6,"")),ISNUMBER(SEARCH(dr,a)))
Hi,
Just to let you know regarding the duplicate, I've had a few delivery failure messages which I don't think are correct but I end up repeating things,
as to answers thank you both I will work through them.
Richard.
Thank you , that is a bit shorter,
Richard.
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.
Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
All you have to do to check your threads is go to your profile: https://www.excelforum.com/members/1473571.htmlOriginally Posted by Dicken
Click on the Latest Started Threads link. Don't rely on subscriptions to your threads.
Yes, you can move it, if it's ok to leave open for a bit longer, before i mark solved.
RD
Hmmm, I'm going to have to work on the conacat, you've done, I've tried it in isolation and can see how it works,
but it's going to take a while to really see what get's mapped to what ,
RD
If you type just this into an empty cell somewhere:
=TEXTJOIN(";",1,IF(C3:E3="Month",B4:D4&C4:E6,""))
you will see that it returns a list of text strings in one cell. These are then searched at the end of the formula.
I shall move the thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks