Question

how to make binarray in excel ​

Answer 1

To create a frequency distribution using FREQUENCY:

Enter numbers that represent the bins you want to group values into.

Make a selection the same size as the range that contains bins, or one greater if want to include the extra item.

Enter the FREQUENCY function as an array formula using Control+Shift+Enter.

Answer 2

use 1 and 0 only

eg. 10001,000111,etc