Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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

More
1 month 1 day ago #1567 by Rajesh S.
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 month 1 week ago #1547 by Kevin
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.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo