Excel Magic Trick 1182

COUNTIFS and Wildcards to Count When There are 4 or More Characters

DESCRIPTION

See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz at YouTube:
(00:10) Problem setup and review of last video Excel magic Trick
(00:53) COUNTIFS Function to count numbers with 4 or more characters. Raise 10 to a power and link it to a cell with the criteria 4.
(02:00) COUNTIFS Function to count text with 4 or more characters. Use REPT function with wildcards ? and *.
(04:35) Wild Cards for text strings: A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Excel wild card characters ? and * for text only? Yes, this information was not in the F1 Help for COUNTIFS, but instead it was in the F1 Help for the MATCH function.




Be the first to comment

Leave a Reply