Log in  \/ 
x
or
x
x
Register  \/ 
x

or

normal If a column A has the value 1 somewhere, copy contents of Column B to Cell

More
1 year 1 month ago #1567 by Raj2018
Unable to understand what exactly you are looking for ,, better post some expected output, will help us to fix the issue.

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #1547 by Smits
Can anyone help me out with a specific formula in Excel?

Let just say I have a table with 2 colums the first contains text and the second contains numbers like below.
I want to copy the contents from the first column to be copied together to 1 cell based on the fact if the second column has a 1.

So I want to fill another Cell with the concatenated text Pants, Shirts
Pants1
Shirts1
Shoes0

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun