I have a 2 column spreadsheet of over 150k entries. Column A is a set of #s, Column B is a set of (mostly) names. I want to make sure no one entered an address, etc. into Column B so I'd like to search column B for any numbers. Is this possible?
If you want just a quick check to make sure there are no numbers in the entire column then you can do something like this:
In C2:
=COUNTIF(B,REGEX("\d"))
A count of 0 means no numbers in the column. Anything else means there are numbers.
If it turns out you have multiple numbers then you can find out where they are with this:
In C2, filled down:
=COUNTMATCHES(B,REGEX("\d"))
Then you can filter or sort on column C to isolate the entries with numbers.
SG
If you want just a quick check to make sure there are no numbers in the entire column then you can do something like this:
In C2:
=COUNTIF(B,REGEX("\d"))
A count of 0 means no numbers in the column. Anything else means there are numbers.
If it turns out you have multiple numbers then you can find out where they are with this:
In C2, filled down:
=COUNTMATCHES(B,REGEX("\d"))
Then you can filter or sort on column C to isolate the entries with numbers.
SG
You can expose the cells containing numerals with this set of 10 Conditional Highlighting rules applied to each of the cells in column B:
Regards,
Barry
PS: Apologies for placing 'Column B' in a three column table. Made the table before a second reading of your question revealed the actual pattern of your table.
B. Numerals 5- 9 and 0 are handled by 6 ore copies of the simple rule, one for each numeral.
Note that the rules are set to examine the TEXT of the cell, and will flag each cell in the column that contains any numeral in its text.
Can you search for *any number* within a column in Apple Numbers
