combine array to text and counta?

[ankushmukherjee]

A	B	C	D	E	Result
			John	Daisy	00011
		Britney			00100
		Ronny			00100

Can we get the result in 0, 1 format by Combining Array to Text and CountA from A to E ? or if any other method?

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you mean?

21 12 06.xlsm
	A	B	C	D	E	F
1				John	Daisy	00011
2			Britney			00100
3			Ronny			00100
01

Cell Formulas
Range	Formula
F1:F3	F1	=CONCAT(IF(A1:E1="",0,1))