I want to build intelligent excel

Solved/Closed
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
- Dec 21, 2015 at 10:24 AM
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
- Dec 21, 2015 at 10:56 AM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Dec 21, 2015 at 10:41 AM
Nullun,

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

Best regards,
Trowa
6
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2
Dec 21, 2015 at 10:47 AM
thanks !
0
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
25
Dec 21, 2015 at 10:40 AM
in the 3rd column:
=if(A2="X",A1,"")

drag this down the rest of the rows
5
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2
Dec 21, 2015 at 10:46 AM
works like a charm, thanks
0
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2
Dec 21, 2015 at 10:49 AM
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
2
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Dec 21, 2015 at 10:55 AM
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.
0
nullun
Posts
7
Registration date
Monday December 21, 2015
Status
Member
Last seen
January 3, 2016
2 > TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022

Dec 21, 2015 at 10:56 AM
thanks, thats, what i thought too - I am Estonian, myself. you are very helpful.
0