I have a list of 3 digit phone codes in EST timezone in column A Sheet 2. I have in Column A Sheet 1 another list of 3 digit phone codes from people that have called in.
What I am trying to do is in Sheet 1 "B2" count the number of inbound calls (Column A Sheet 1) that exist in the EST timezone list (Column A Sheet 2).
I cannot seem to find a way to complete this using either formulas or macros.Answer1:
You'll want something like this:
A## with the location of the 3 digit code from sheet 2 that you want to count.
EDIT: Here is the code which solves your question. It counts the number of times any value within Sheet2!A:A is iterated in Sheet1!A:A