I need a formula that counts instances of this data (AB-1, AB-10, etc.)....
Column A
AB-1 Formula should give 2
AB-10 Formula should give 1
AB-2 Formula should give 1
AB-20 Formula should give 1
AF-1 Formula should give 1
....within this source data
Column B
Product AB-1 was created in 2016
AB-1 is also blue
AB-10 is green
AB-2 is red
AB-20 black
AF-1 is yellow
Bookmarks