Combine results of IF statement?
Hello,
I am trying to create a formula on my table to combine the names of the volunteers that are on the same shift each day. I am not sure if i use the IF statement or need to use a lookup?
Here is an example:
If "Date","Location","Start Time","Stop Time" are the same then give all volunteers names with the same criteria. Answer I am looking for outlined in RED.
Thanks for your help!
Nick
Last edited by vxhatch; 03-13-2018 at 03:55 AM. Reason: Added Dummy Book
If you can use helper columns, array enter (ctrl+shift+enter) this in J2, for example, then copy across for as many columns as needed, and down:
Formula:
Please Login or Register to view this content.
In this example, formula covers 4 columns.
Then paste this in G2 and copy down:
=TEXTJOIN(", ",1,J2,K2,L2,M2)
I suggest you watch a youtube link video first at :
PHP Code:https://www.youtube.com/watch?v=IiPc8STqJTU
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Maybe with the help of a UDF and a Helper column:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks