By Smits on Friday, 12 April 2019
Posted in Excel
Replies 1
Likes 0
Views 3.9K
Votes 0
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
Unable to understand what exactly you are looking for ,, better post some expected output, will help us to fix the issue.
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post