I want to filter out all rows except for ones where column D has a higher wordcount than column C. How can this be done?
I want to do this to make a large file more readable, as I’m only interested in rows that match the above criteria.
Found this:
=LEN(TRIM($C2))-LEN(SUBSTITUTE(TRIM($C2)," “,”"))+1
it will get a word-count (someone let me know if there’s a more concise function).
Say you put this wordcount into F2 for the count of cell C2, G2 for D2.
Then you can use =D2>C2, select this column and use the AutoFilter option under Data menu