Question description:
This user has given permission to use the problem statement for this
blog.
if a value in the same row is found in another column copy it to another column
Solved by S. A. in 27 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
16/04/2018 - 01:51
Hi!
Excelchat Expert
16/04/2018 - 01:51
How are you? By any chance, are you able to provide a sample data set we could work with?
Excelchat Expert
16/04/2018 - 01:51
Thanks
User
16/04/2018 - 01:52
Hi , i am copying the data now
Excelchat Expert
16/04/2018 - 01:53
Alright, please take your time
Excelchat Expert
16/04/2018 - 01:53
thanks
User
16/04/2018 - 01:53
Thanks
User
16/04/2018 - 01:53
Peer Coach 1
Excelchat Expert
16/04/2018 - 01:54
Okay, can you please help me define the following in terms of cell/range references
User
16/04/2018 - 01:54
peer coach column is randamozied
User
16/04/2018 - 01:55
Marci is coaching linda on the same row
Excelchat Expert
16/04/2018 - 01:55
which row is this by the way?
Excelchat Expert
16/04/2018 - 01:55
okay, the highlighted row - row 1
User
16/04/2018 - 01:56
i need a formula that checks column c and when it finds linda it copy marci to E14
User
16/04/2018 - 01:56
i hope that helps
Excelchat Expert
16/04/2018 - 01:56
so check column c for value = Linda Moradzadeh
Excelchat Expert
16/04/2018 - 01:57
if condition is true, then E2 = Marci Piasecki
Excelchat Expert
16/04/2018 - 01:57
is this correct?
User
16/04/2018 - 01:57
yes
User
16/04/2018 - 01:57
not E2
Excelchat Expert
16/04/2018 - 01:58
E14
Excelchat Expert
16/04/2018 - 01:58
sorry to miss that
User
16/04/2018 - 01:58
the cell in E that is next to marci
User
16/04/2018 - 01:58
and do the same for all peer coaches
User
16/04/2018 - 01:59
is that clear
Excelchat Expert
16/04/2018 - 01:59
i'll try building a formula, and please let me know if i got it correctly
Excelchat Expert
16/04/2018 - 01:59
will let you know if I'm done
User
16/04/2018 - 01:59
i need to fill column E
Excelchat Expert
16/04/2018 - 02:01
so for example, just for final clarification - can you tell me what is the expected value for E2?
Excelchat Expert
16/04/2018 - 02:01
and E3
User
16/04/2018 - 02:01
on sec
Excelchat Expert
16/04/2018 - 02:01
okay
User
16/04/2018 - 02:02
ok , let me think :) one sec please
Excelchat Expert
16/04/2018 - 02:02
sure :) no worries
User
16/04/2018 - 02:04
This is it
User
16/04/2018 - 02:04
you got it
Excelchat Expert
16/04/2018 - 02:05
got it
User
16/04/2018 - 02:05
ok , thanks
User
16/04/2018 - 02:05
and so on
Excelchat Expert
16/04/2018 - 02:06
can you see the values in column E?
User
16/04/2018 - 02:06
i am checking
User
16/04/2018 - 02:06
now yes i do
Excelchat Expert
16/04/2018 - 02:07
I hope I got your specifications right
Excelchat Expert
16/04/2018 - 02:07
Otherwise please let me know
User
16/04/2018 - 02:07
ok , i am checkinh
User
16/04/2018 - 02:07
Thanks
User
16/04/2018 - 02:09
it seems working great
User
16/04/2018 - 02:09
i please have another question
Excelchat Expert
16/04/2018 - 02:09
Glad to hear that
Excelchat Expert
16/04/2018 - 02:09
go ahead
Excelchat Expert
16/04/2018 - 02:09
as long as it is of the same nature to your original problem :)
User
16/04/2018 - 02:09
how can i alsoi get the emails of the students in columns e top automatically be attched to the column
Excelchat Expert
16/04/2018 - 02:10
do you have the record of student-email address?
Excelchat Expert
16/04/2018 - 02:11
is it okay if I reposition the unsorted email address in column B?
User
16/04/2018 - 02:11
can i attach the emails of each student before the formula in in E kicks in
User
16/04/2018 - 02:11
yes it just needs to be on the same row as the user
Excelchat Expert
16/04/2018 - 02:12
Please see column G
User
16/04/2018 - 02:12
ok
User
16/04/2018 - 02:13
perfect , i think this is it
User
16/04/2018 - 02:13
That is awesome
Excelchat Expert
16/04/2018 - 02:13
Nice!
User
16/04/2018 - 02:13
Great job !!!
Excelchat Expert
16/04/2018 - 02:14
is it okay to mark this problem as ANSWERED?
User
16/04/2018 - 02:14
I truly appreciate that help
Excelchat Expert
16/04/2018 - 02:14
thank you :) i'm happy to help
Excelchat Expert
16/04/2018 - 02:14
If you don't need anything else, you may hover over the Time Remaining part of the window
User
16/04/2018 - 02:14
That will facilitate a lot of things
Excelchat Expert
16/04/2018 - 02:14
and select End Session :)
User
16/04/2018 - 02:14
sure .Thank you so much again
Excelchat Expert
16/04/2018 - 02:15
Glad to know that
Excelchat Expert
16/04/2018 - 02:15
you're welcome
Excelchat Expert
16/04/2018 - 02:15
Your kind feedback is very much appreciated
User
16/04/2018 - 02:15
can i put that in a macro
User
16/04/2018 - 02:15
sure
User
16/04/2018 - 02:15
will do
User
16/04/2018 - 02:15
u guys are amazing
Excelchat Expert
16/04/2018 - 02:15
Oh I'm sorry macros are out of our service scope
Excelchat Expert
16/04/2018 - 02:16
Thanks a lot! You're amazing too :)
User
16/04/2018 - 02:16
how about a formula that randamozes a column into A b c d groups
User
16/04/2018 - 02:16
instead of 1 2 3 4
User
16/04/2018 - 02:17
i am sorry for my many requests
User
16/04/2018 - 02:17
Thanksssssssssssssssssss
Excelchat Expert
16/04/2018 - 02:17
I am sorry but this conversation is monitored and we are only allowed to cover one problem type per session
Excelchat Expert
16/04/2018 - 02:17
If you like, you can try posting that problem here and I'll be glad to take it on for another session with you :)
User
16/04/2018 - 02:18
sure thanks again
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
