I want to build intelligent excel [Solved/Closed]

Report
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
-
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
-
Task is:

For example I have list of different fruits in cells in separate rows

Apple
Pear
Plum

I want the data to be copied to third cell, if second has x in it
example:

Apple
Pear
Plum

I put x next to Apple
Apple x
Pear
Plum


Then Apple will be copied to third column

as
Apple x Apple
Pear
Plum

Thank you for assisting me.

3 replies

Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
396
Nullun,

Try the foolowing formula in the 3rd column:
=IF(B2="x",A2,"")

Best regards,
Trowa
6
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4093 users have said thank you to us this month

nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2
thanks !
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
in the 3rd column:
=if(A2="X",A1,"")

drag this down the rest of the rows
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2
works like a charm, thanks
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2
by the way.. what is the thing, my excel wants ";" mark ----- he doesnt like commas -- when i copy-paste your offered formulas, excel pop-ups somekind of error message.. i have to change commas to semi-colons
TrowaD
Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
396
Don't know the exact criteria, but I believe it has something to do with language or region.
I'm using a Dutch version and my Excel also requires ";" as separator. But most people here require the "," as separator, so that is what I post.
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2 > TrowaD
Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020

thanks, thats, what i thought too - I am Estonian, myself. you are very helpful.