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!