arrays if-statement google-sheets google-sheets-formula array-formulas

How can I get a list of cells that exceed a certain length?

I have a massive Google Sheet and I'm trying to get a list of cells that would exceed a certain number of characters.

I've tried various methods, but I can't seem to get what I'm looking for. Since this would be across multiple sheets, I would much rather use a portable formula than setting up a filter with conditional formatting. Any ideas? Thank you.

Solution

try in row 1:

=ARRAYFORMULA(IF(LEN(A:A)>50, A:A, ))

Remove first element from a $_POST array
Trouble reading numbers from file into array
Dynamically populate a subarray inside of an array declaration
Only print array row data if id is found in a whitelist array
Increment variable name in a loop
Transpose an associative 2d array
how to split each word in a string in a separate list
Array is always empty even when it is expected to have elements
Build a multi-line address string with conditional components
Access only the first row of a 2d array
Doubled elements in result array while scraping HTML content
Loop over an array of unknown depth
How to access keys and values of a multidimensional array
How to union ranges in google spreadsheets
Validate an array as "empty" if it has no elements or if all elements have no length
Generate an array of href strings from all <a> tags in an HTML document using Simple HTML DOM Parser
Extracting JSON response and putting them inside a customize JSON
Best way to filter an objects's properties for data
How to loop over json-encoded data?
Fill array with numbers adding up to a nominated total without exceeding item maximum
Generate an associative 2d array with incremented column values using a flat array as first level keys
Put Values in Multidimensional Array keys
What is the proper way to initialize a fixed length array?
Need help understanding pointer to a type of n elements in C (int (*p)[10])?
Create Pivot table and add additional columns from another dataframe
Algorithm to reverse an array/string only in terms of rotate operations
Group data from lines of a log file by one column and create subarrays from another column
When did iterating on the span of an array become faster than iterating on the array itself
Use values of a flat array as the keys in every row of a 2d array
Function to clear any value by assigning to it a default constructed value of same type