Hello Team,
I need your help with a formula to calculate how many empty column between of the letter “A” as in the row#2. The result that I am looking for should be the same as in row#1 as shown below.
Any help would be greatly appreciated.
BDT
<tbody>
</tbody>
I need your help with a formula to calculate how many empty column between of the letter “A” as in the row#2. The result that I am looking for should be the same as in row#1 as shown below.
Any help would be greatly appreciated.
BDT
A | B | C | D | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | |
ROW#1 | 1 | 2 | 1 | 7 | 2 | |||||||||||||||||||||
ROW#2 | A | A | A | A | A | A | A | A | A | A | A |
<tbody>
</tbody>