Hi
I need help finding the percentage of items within a collection. 3 to 10 books can make up a collection, but we might not have all the books needed to complete the collection. So I need to figure out the percentage of books within a collection. Example: One collection needs 10 books to be complete. We have 7 books, so the collection is 70% completed.
We have 33,245 collections that contain anywhere from 3 to 10 and sometimes more books. Please HELP!!!
(I've been using count and countif, but it is taking way too long to go one by one.)
I need help finding the percentage of items within a collection. 3 to 10 books can make up a collection, but we might not have all the books needed to complete the collection. So I need to figure out the percentage of books within a collection. Example: One collection needs 10 books to be complete. We have 7 books, so the collection is 70% completed.
We have 33,245 collections that contain anywhere from 3 to 10 and sometimes more books. Please HELP!!!
(I've been using count and countif, but it is taking way too long to go one by one.)