Thread: [Solved] COUNTIF - A vs. AA???
View Single Post
 
Old 12-28-2020, 11:02 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Looks like you always have a space after the A or AA or AAA, so =COUNTIF(G8:G18, "A *")
Attached Files
File Type: xlsx Copy of MsForums example_Purfleet.xlsx (9.2 KB, 8 views)
Reply With Quote