How can I get 1,1,0 if I have string, string, blank

[guybrown]

If I have text strings in A1 and B1 and C1 is blank, how can I get an array of 1,1,0?

eg. cat, dog, [blank]
{=--(cat, dog, [blank])} ???

 

[Peter_SSs]

Where do you want the 1,1,0 array? Are you looking for a formula or vba? Give us a bit more detail about what you have and what you are trying to achieve.

 

[jeffreybrown]

Please post a link to all cross posts.

http://www.excelforum.com/excel-gen...f-i-have-string-string-blank.html#post2557047

 

[guybrown]

Cross Posts:
http://www.excelforum.com/excel-gen...f-i-have-string-string-blank.html#post2557040

 

[guybrown]

Where do you want the 1,1,0 array? Are you looking for a formula or vba? Give us a bit more detail about what you have and what you are trying to achieve.

Peter

It's related to a previous post http://www.mrexcel.com/forum/showthread.php?t=561916
I think this previous post was too complicated/unclear for anyone to respond so I'm trying to work it out myself.

Maybe I could use --istext(range) to get 1,1,0

then use --istext(drinks required) to get<TABLE style="WIDTH: 273pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=364><COLGROUP><COL style="WIDTH: 273pt; mso-width-source: userset; mso-width-alt: 13312" width=364><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 273pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=20 width=364>1,1,0;0,1,1;0,1,0;1,0,1;1,0,1</TD></TR></TBODY></TABLE>

multiply them to get
<TABLE style="WIDTH: 273pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=364><COLGROUP><COL style="WIDTH: 273pt; mso-width-source: userset; mso-width-alt: 13312" width=364><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 273pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=20 width=364>1,1,0;0,1,0;0,1,0;1,0,0;1,0,0</TD></TR></TBODY></TABLE>

combine rows to get
<TABLE style="WIDTH: 273pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=364><COLGROUP><COL style="WIDTH: 273pt; mso-width-source: userset; mso-width-alt: 13312" width=364><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 273pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=20 width=364>2;1;1;1;1</TD></TR></TBODY></TABLE>

x by 1 to get
<TABLE style="WIDTH: 273pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=364><COLGROUP><COL style="WIDTH: 273pt; mso-width-source: userset; mso-width-alt: 13312" width=364><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 273pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl65 height=20 width=364>1;1;1;1;1</TD></TR></TBODY></TABLE>

then concatenate drink strings where there is a 1 ie all 5 drinks on day 1.

 

[Scott Huish]

Please make all clarifications and additions in the original thread:

http://www.mrexcel.com/forum/showthread.php?t=561916