D
Deplywrker
I need to count how many times certain phrases come up from multiple
worksheets. Let me explain the problem more in detail. I have a worksheet for
every day and each day has about 8-20 names/ numbers listed (ex. 00515 - name
1, 00515 - name2, 65487- name 3). Instead of me going through each day and
counting how many times each one comes up, I was wondering if there is a way
to have a formula on the last page to count how many times each phrase is
lested from 31 worksheets. I have the list of all phrases on the 1st
worksheet that has about 90 differ names. Conclusion: Is there a way to say
look for whats listed in A1 on this worksheet and search all 31 worksheet
tabs and tell me how many times it comes up? Thank You
worksheets. Let me explain the problem more in detail. I have a worksheet for
every day and each day has about 8-20 names/ numbers listed (ex. 00515 - name
1, 00515 - name2, 65487- name 3). Instead of me going through each day and
counting how many times each one comes up, I was wondering if there is a way
to have a formula on the last page to count how many times each phrase is
lested from 31 worksheets. I have the list of all phrases on the 1st
worksheet that has about 90 differ names. Conclusion: Is there a way to say
look for whats listed in A1 on this worksheet and search all 31 worksheet
tabs and tell me how many times it comes up? Thank You