Thank you in advance for any enlightenment you can please offer!
1) Cells D1:D5 contain: A-8, ZZ-5, BBB-3, A-2, ZZ-7
2) Cells A1:A3 contain: A, BBB, ZZ
Note: Column A simply contains the prefixes of the items listed in column D
3) I need a formula in cells B1:B3 that will count the number of items in column D that have the prefix listed in column A.
4) With this example, the formula would generate the following values in cells B1:B3: 2, 1, 2
Thanks again, Sven