Im having serious difficulty doing this please help, if you know.
I couldnt figure out make the cells look proper so I just attached a picture of the spreadsheet.
help.jpg
This is my formula. This is close to what I want but not quite
=F2&"Dog,"&G2&" Cat, "& H2&" Chicken," &I2& " Pig"
This shows- 1Dog, Cat, 1 Chicken, Pig
I want it like this however, if the Cell is blank than I dont want the words to show. I've tried several different formulas and understand it may not be possible in Excel as the program is not a human brain. So the first line I want it to show
1 Dog, 1 Chicken
I dont want to see the the Cat or Pig unless there is a number there. Also I want the number related to the cell to be even so the second line I would like it to be
1 Dog, 2 Cat, 1 Chicken
If I wasn't clear please let me know, but I dont know how I could explain it better. Only other thing I may be able to do is print screen if necessary. Thank you so much if you can help though.
Bookmarks