Archive for ISTEXT function
The picture above shows different values in column B and a formula in column C that tries to identifies the […]
The following formula in cell D3 counts cells with values stored as text. =SUMPRODUCT(ISTEXT(B3:B14)*1) In other words, cells containing nothing, errors, […]
How to use the ISTEXT function
The ISTEXT function returns TRUE if value is text. Formula in cell C3: =ISTEXT(B3) Excel Function Syntax ISTEXT(value) Arguments value […]
Filter unique distinct values, sorted and blanks removed
Table of Contents Filter unique distinct values, sorted and blanks removed Filter duplicate values, sorted and blanks removed EEK asks: […]
Return value if it exists more then n times
Students are allowed to sign up to maximum two courses. How do I filter students who have signed up for […]
Extract and sort text cells from a range containing both numerical and text values
Array formula in B16: =INDEX(tbl, MIN(IF(SMALL(IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), ROW(1:1))=IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), ROW(tbl)-MIN(ROW(tbl))+1)), MATCH(SMALL(IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), ROW(1:1)), INDEX(IF(ISTEXT(tbl), COUNTIF(tbl, "<"&tbl)), MIN(IF(SMALL(IF(ISTEXT(tbl), […]
Count unique distinct text values in a range
Array formula in D14: =SUM(IF(FREQUENCY(COUNTIF(tbl, "<"&IF(ISTEXT(tbl), tbl, "")), COUNTIF(tbl, "<"&IF(ISTEXT(tbl), tbl, "")))>0, 1, 0)) + CTRL + SHIFT + ENTER […]
Extract numbers and text from a range sorted from A to Z
This blog post describes how to filter text values and then numbers from a range. Array formula in B15: =INDEX(tbl, […]
Filter numbers or text in a column
Question: I want to extract all numeric values into a new column? Also all text values into another column? Answer: […]
Create a unique distinct list where a corresponding column has text cell values
Question: I want a unique list to be created from a column where an adjacent column has text cell value? […]
