how to display in one cell how many entries in another cell RRS feed

  • Question

  • i have one cell which contains certificate date and in another cell cert no, every time i update the expiry date in the same cell K  and my certificate number is updated in cells S to AB , every time i update certificate date in a1 and corresponding cert# in which ever blank cell in same row from column S to AB ...  i have tracking of cert# from n to w column but i don't have tracking of certification date , ineed to track how many times i done certification in one year..  since iam updating the same cell for certificate date how can i track it from cert#

    Sunday, January 20, 2019 6:08 PM