1) Please post sample workbooks, not images. Images compel us to create your scenario from scratch.
2) Let's see if this is worth the effort
Note: This is NOT the most elegant formula I've ever constructed :\
With your killed and injured value pairs beginning in D3:E3
and
this list in S1:T5
This ARRAY FORMULA, completed by holding down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER) begins the concatenation of up to 10 values (5 consecutive rows)
Copy I2 and paste into I3 and down as far as you need.
For your first few data pairs these are the results:
For a set with 5 rows of pairs:
These are the results: 1001100110
Is that something you can work with?
Bookmarks