G Guest Mar 17, 2004 #1 How do I use the ISTEXT formula for a range of cells? It seems to only work fo a single cell.
B Bob Phillips Mar 17, 2004 #2 Jyoti, You could count the instances, like =SUMPRODUCT(--(ISTEXT(A1:A100))) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Jyoti said: How do I use the ISTEXT formula for a range of cells? It seems to only Click to expand... work fo a single cell.
Jyoti, You could count the instances, like =SUMPRODUCT(--(ISTEXT(A1:A100))) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) Jyoti said: How do I use the ISTEXT formula for a range of cells? It seems to only Click to expand... work fo a single cell.
D darkangelstorm Mar 17, 2004 #3 You could use a Data Validation... Select the cells. Data > Validation Custom Formula then =ISTEXT() DA
You could use a Data Validation... Select the cells. Data > Validation Custom Formula then =ISTEXT() DA
