Previous Topic Next Topic

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

Answer 1 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
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
Answer 2 / 3
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
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
Answer 3 / 3
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023
Dec 21, 2015 at 10:56 AM
thanks, thats, what i thought too - I am Estonian, myself. you are very helpful.
0