If column B2 has Husband, B3 has Wife, B4-B5 has Child then starts over, how can I index each family unit ie: column A2 through A4 = 1 and increases with additional families.
<tbody>
Index
Member
1
Husband
1
Wife
1
Child
1
Child
2
Husband
2
Wife
2
Child
3
Husband
3
Wife
4...