Hi,
I have to count the cells which have text values in a particular column. All the cells have formulas at place. For example:
Answer I should getA1akjsdbam3A2sjakdba A3asasx A4 A5 B1asdn,5B2loyhm B3ytefdhs B4szxz B5qsa B6 B7 B8 B9 B10 B11 C1asjk2C2wrds C3 C4 C5 D1skxhj6D2slaksmx D3saknmx D4asklasmx D5asxl;,sa D6\x\sww
I want to count max no. of filled vaues in column A for A,B,C,D variables (& not the blank ones) from Column C. Answers I need are in Column D. But the values in Column C have some sort of formulas , therefore counta isnt working fine.
Help plz?
I have to count the cells which have text values in a particular column. All the cells have formulas at place. For example:
Answer I should getA1akjsdbam3A2sjakdba A3asasx A4 A5 B1asdn,5B2loyhm B3ytefdhs B4szxz B5qsa B6 B7 B8 B9 B10 B11 C1asjk2C2wrds C3 C4 C5 D1skxhj6D2slaksmx D3saknmx D4asklasmx D5asxl;,sa D6\x\sww
I want to count max no. of filled vaues in column A for A,B,C,D variables (& not the blank ones) from Column C. Answers I need are in Column D. But the values in Column C have some sort of formulas , therefore counta isnt working fine.
Help plz?