I know how to do this problem in newb-like long form. I would say "=COUNTIF(A:A,B1)" then "=COUNTIF(A:A,B2)", then sum my whole column to find that X number of values in column B matched values in Column A. But that requires a preparation column C to aggregate the information. I'd like to accomplish the same thing in a single cell with one formula.
Thanks for your help!
Bookmarks