Thread: [Solved] Get a formula to count one per cell...
View Single Post
 
Old 09-01-2020, 01:56 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
Much eaiser if you supply a spreadsheet with dummy data.

I would use a helper column with somthing like =IF(LEFT(A1,4)="Post",1,0)
Attached Files
File Type: xlsx Get a formula to count one per cell..._Purfleet.xlsx (8.9 KB, 7 views)
Reply With Quote