View Single Post
 
Old 02-17-2019, 05:19 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by ArviLaanemets View Post
I suspect you may want to filter on specific strings in Remark field. When this is case, you have to make the hidden column dynamic based on come general counting criteria you/user select(s) on worksheet.
You're correct Arvi, the formula counts all text strings under the REMARKS column except "DRP", "T/O", "DIED", "N/E" and "S/O".
Ooopps, it ais server error so I retyped my reply, how do I delete this?
Reply With Quote