SelfTaughtE
New Member
- Joined
- Mar 19, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am trying to count the number of empty cells in a row, but I have merged cells (and no way around not using merged cells). The solution I can think of around having the merged cells count double is to count the blanks for every other column. I have tried COUNTBLANK and writing MOD codes for this with no luck.
Here's an example: Data example.xlsx . On Sheet 2, I am trying to use the formula for each time to correspond with the number of blanks for the same time row on Sheet 1, starting with column C and doing every other column.
Thank you!
Here's an example: Data example.xlsx . On Sheet 2, I am trying to use the formula for each time to correspond with the number of blanks for the same time row on Sheet 1, starting with column C and doing every other column.
Thank you!