Question description:
This user has given permission to use the problem statement for this
blog.
I need to copy a value from one column to another when text in a another column says "win"
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/05/2018 - 02:05
Hi there!
User
03/05/2018 - 02:05
HELLO
Excelchat Expert
03/05/2018 - 02:05
Ah yes you're making an example in the google sheet - perfect :)
User
03/05/2018 - 02:06
SO, IF I enter "win" in cell E1 i want the value in F1 to replicate the D1....
User
03/05/2018 - 02:07
should be easy but I am struggling !
Excelchat Expert
03/05/2018 - 02:07
Gotcha. I can help!
Excelchat Expert
03/05/2018 - 02:07
And what would go into D1 if WIN is NOT entered in column E?
User
03/05/2018 - 02:08
nothing or a value of 0
Excelchat Expert
03/05/2018 - 02:08
Sorry I meant in F1
Excelchat Expert
03/05/2018 - 02:08
the formula goes in column F yes?
Excelchat Expert
03/05/2018 - 02:08
it can be blank OR a zero, whatever you want
User
03/05/2018 - 02:08
it can do? or in e1 - whatever is easiest
Excelchat Expert
03/05/2018 - 02:09
Check that out and let me know if that's what you're after!
User
03/05/2018 - 02:10
perfect.... whats the formula?
Excelchat Expert
03/05/2018 - 02:10
Here it is -
Excelchat Expert
03/05/2018 - 02:10
=if(E1="win",D1,0)
Excelchat Expert
03/05/2018 - 02:10
You can pull that down as well
Excelchat Expert
03/05/2018 - 02:10
for the subsequent rows
User
03/05/2018 - 02:11
thank you so much.... i will be using your help again in the future, where do we donate or sign up?
Excelchat Expert
03/05/2018 - 02:11
it is my pleasure!! That's awesome news. I believe you would just sign up on the Got It website.
Excelchat Expert
03/05/2018 - 02:11
I hope you have a great day and all the best!
User
03/05/2018 - 02:12
which country are you in, just out of interest?
User
03/05/2018 - 02:12
have a great day amigo.....
Excelchat Expert
03/05/2018 - 02:12
I wish I could tell you! They have strict rules about that unfortunately.
Excelchat Expert
03/05/2018 - 02:12
thx again ~
User
03/05/2018 - 02:12
ok, wherever you are - have a good one.
Excelchat Expert
03/05/2018 - 02:12
Thanks!
Excelchat Expert
03/05/2018 - 02:13
You can end the session if you so desire at the top right side of the screen. Or wait out the 12 mins :)
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.