LinkBack URL
About LinkBacks
Hi,
I'm having trouble to get Prefered results out of a matrix, based on the input/match of a specific date (Variable).
I hope that someone would like to help me...
Thanks in advance...
TestSTL.jpg
Hi,
I'm having trouble to get Prefered results out of a matrix, based on the input/match of a specific date (Variable).
I hope that someone would like to help me...
Thanks in advance...
TestSTL.jpg
What are your preferred results? In what way are the results in the attached file incorrect?
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.
In L4, enter:
and copy across / down.Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks for your replies... Olly & AliGW...
The prefered result (L4:N8) is what I would like to see in J4:J8, depending on what date is entered in J2.
So if I enter 10-10 (10 oct) in cell J2, the output should be:
J4 Empty
J5 1
J6 Empty
J7 Empty
J8 2
Okay - so my formula does what you want, I just put it in the wrong place.
So enter this in J4, and copy down:
Formula:Please Login or Register to view this content.
Yep @Olly, I just finished playing around with your formula and indeed it does exactly what I need. Thanks a lot... Problem solved... :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks