Ramneek Sharma - VB From Technical View
MCTS, MCPD, MCT, IBM SQA,Green Belt Six Sigma.
Thursday 13 November 2014
Count the values starting with specific character
Count the values starting with specific character
Example : A-Z
Apply the below formula to the spreadsheet and get the count of specific character starting with value entered in cell F1.
Enter "A" in cell F1 and you will get the count from column A
=COUNTIFS(A:A,F1 & "*")
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment