Friday, 12 April 2019
  1 Replies
  3.9K Visits
0
Votes
Undo
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


Pants 1
Shirts 1
Shoes 0
5 years ago
·
#1900
0
Votes
Undo
Unable to understand what exactly you are looking for ,, better post some expected output, will help us to fix the issue.
  • Page :
  • 1
There are no replies made for this post yet.