Thanks
Thank you, I have applied it to the sheet and have changed the cell it is working off however I do not think it is fully working please see attached.
There are cells returning a Zero instead of 1 or 2 etc
also as this formula essentially creates a new units column is it possible to have it return the sum as well as the individual numbers of the other cells or a zero if it has been summed? please see below.
i.e.
12345 - units 2 - count 0
12345 - units 5 - count 7
58244 - units 1 - count 1
48125 - units 9 - count 0
48125 - units 9 - count 18
|