Posts by Joseph

    I have two columns with stock codes in each. The codes repeat within each column several times. How do I count the number of times a certain code appears in the same row as another code in the other column? (For example, how often "AA" appears in the same row as "EE".) I wrote a VBA macro in less than a minute to do the job. But after a couple of hours I still could not write a formula using COUNTIF, AND, and IF to the same thing.