Prev: Index / Match / value in a range?
Next: SUMIF with NAME RANGE
From: Adnerb on 28 Mar 2010 18:12
I have a text spreadsheet of 5,000 names and addresses. Column B needs to
restricted to only 16 characters in that column. How do I send the records
to the bottom of the page (or delete them) that have data that exceeds 16
characters in Column B?
From: tompl on 28 Mar 2010 18:20
You could insert a new column. In that column, in row 2 put the formula
=len(B2) and copy it down the column. Then sort the table on then new column
ascending.

Tom
 | 
Pages: 1
Prev: Index / Match / value in a range?
Next: SUMIF with NAME RANGE