Please help me, I have a column (M) with 300 single digit numbers, starting in the last cell (row 300) and going up,
I need a formula that only counts how many times the numbers 0 thru 9 show up above the number 0,1,2,...,9
and put the results in cells b2:k11 (Counting cells).
See attached example, starting cell M21 we find an 8, above it we see the # 6, the same happens in cell M7, then Cell H10 will be 2
and in cell G10 will be 1 because there is only 1 event with a 5 above the 8
Bookmarks