HTX_Excel_Dude
New Member
- Joined
- Nov 11, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello Excel Wizards!
I'm looking for an excel formula that will count the maximum number of blanks (formula blanks of "") between any 2 values in a row. The row will contain many different values, and are dynamic. I have thousands of rows where the values will be in different columns.
Example:
So essentially I am looking for a formula that would return the number '3', because there are 3 blanks between 'Value3' and 'Value4', compared against 1 blank between 'Value2' and 'Value3', and also against 1 blank between 'Value4' and 'Value5'.
The blanks are not truly empty cells, but instead contain "" derived from a formula within that cell.
Thanks in advance!
I'm looking for an excel formula that will count the maximum number of blanks (formula blanks of "") between any 2 values in a row. The row will contain many different values, and are dynamic. I have thousands of rows where the values will be in different columns.
Example:
Value1 | Value2 | Value3 | Value4 | Value5 |
So essentially I am looking for a formula that would return the number '3', because there are 3 blanks between 'Value3' and 'Value4', compared against 1 blank between 'Value2' and 'Value3', and also against 1 blank between 'Value4' and 'Value5'.
The blanks are not truly empty cells, but instead contain "" derived from a formula within that cell.
Thanks in advance!