Hello Everyone,
I can really use your assistance with the below dilemma. I have tried incorporating, ISBLANK, Exact, iferror formulas but have had no luck.
<tbody>
</tbody>
I need a formula that check all the columns with Name to see if the name John is consistent across while ignoring the errors as well as blanks. I would apply the same logic for the Savings column. If there is no formula, is there any way to see which text occurs the most often? For example, the name John is twice and that's what the output would be while the formula ignores the blanks and #N/A.
Thank you in advance.
I can really use your assistance with the below dilemma. I have tried incorporating, ISBLANK, Exact, iferror formulas but have had no luck.
Name | Savings | Name | Savings | Name | Savings | Name | Savings | Name | Savings |
John | $25 | $25 | #N/A | John | $25 | #N/A | #N/A | ||
<tbody>
</tbody>
I need a formula that check all the columns with Name to see if the name John is consistent across while ignoring the errors as well as blanks. I would apply the same logic for the Savings column. If there is no formula, is there any way to see which text occurs the most often? For example, the name John is twice and that's what the output would be while the formula ignores the blanks and #N/A.
Thank you in advance.