Hi everyone, I'm trying to create a sheet that will read submissions from Sheet1 and check them on Sheet2 against date and Student ID and display the text in column C of Sheet1 depending if criteria is met.
Also if multiple submissions on same date that they would both be included in the cell if possible.
Each student will have an individual ID and the numbers could be into the hundreds so I would rather not do it manually.
Any help welcome and if you need any more info let me know. Thanks!
Attached is a PowerQuery solution.
M Code:
Please Login or Register to view this content.
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.
Hi Ali, Thanks so much for taking the time to reply. Would it be possible to do as a formula as I hope to use this on google sheets in future as the data is coming from google forms?
Try the array formula(CTRL+SHIFT+ENTER after typing)
Formula:
Please Login or Register to view this content.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Thanks for wasting my time!Originally Posted by Gavin101
This sort of thing needs stating UP FRONT. I have amended your thread title and moved this to the Other Platforms section.
Last edited by AliGW; 08-02-2021 at 12:50 PM.
Or in google sheets, if you eliminate first the time from your Sheet1 Date (Column 1)
Formula:Please Login or Register to view this content.
That's worked perfectly Diana, thank you so so much for your help!
Ali,
It was never my intention to waste your time and I'm sorry you felt that way but there is no need to be rude. I use excel but preferred to use a formula instead of a pivot table in case i start using google sheets in future.
And that is a moderator who talked like that, jeez. Stuff like that makes me not want to ask questions.
It is often frustrating to those of us who are helping to not get a full picture in the beginning especially when the OP makes a statement and I quote from the first post--
with no specific exclusions until after help has been offered. Some of us sometimes have off days and we are no different from any one else on this forum. Be assured that all moderators here are here to help and try and teach those who are looking for assistance. Try to be understanding that maybe there are other things going on that this issue may have tipped the scales and not be critical of one posting when there are many other postings (thousands in fact) by Ali that have been extremely helpful to forum members.Any help welcome
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Gavin - it was not my intention to be rude, however I had spent a considerable time preparing a solution to your issue with no knowledge of the limitations you subsequently imposed, which rendered what I had done for you completely redundant. Had I known this needed to work with Google Sheets, I would not have offered help as I don’t know that platform, and had I known it needed to be a formula, I would not have spent time showing you a PQ query when I could have been assisting elsewhere. Please try to include ALL detail in your opening post in future. Thanks.
I just feel bad for people when they are asking for help and are blasted for it. Before I start on a long journey of trying to develop a solution for someone, I talk with them before, in order to make sure I understand what they are needing, I don't just go spend hours working on something, for this very reason. I love this forum, people on here are so helpful, and have saved me and my corkers countless hours. Something I can't repay. I would hate to be the on the receiving end of something like this. Thanks to all of those who spend their time helping us out! I really appreciate it, and I know so many others do! I always thank the people helping me out and add a positive reputation to it.
I'm sure you feel bad, but you've had your say - you've negative repped me, reported me and complained here.
I had a moment of irritation. That's it. And you've blasted me for it - fair enough. But let's not get things out of perspective.
Wow this really escalated since my last message!
As a new-ish/inexperienced member of this forum, I expected the solution to be a formula or array formula as Powerquery isn't something I'm familiar with. I'll be sure to be more specific in future.
Ali clearly does a lot for this community and her solution was fine but I just kindly asked if it was possible to do as a formula. I would imagine it can be frustrating at times as a mod and as Alan mentioned my post may have caught Ali on an off day.
dw_22801, you're right about asking questions before starting a solution as newer members may unknowingly leave out some info in their original posts. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks