ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Count repeated entries without typing the entry (large data base) (https://www.excelbanter.com/excel-programming/434207-count-repeated-entries-without-typing-entry-large-data-base.html)

Cait

Count repeated entries without typing the entry (large data base)
 
Hi,

I am working on a spreadsheet that calculates information for an online data
base of resources. There are multiple sheets each showing how many different
category tags each resource has and most resources show up multiple times on
each sheet because there are many tags in each category (i.e. on the "Grade
Level" page a reosurce could come up for 1st, 2nd, 3rd, etc grade). I am
trying to create another sheet that counts for me how many times each
resource comes up on each sheet. There are over 20,000 distinct resources
listed in the database so I can't write a formula that tells it to count a
specific value.
Is there anyway to do this? If so, please help!

Cait


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com