Today, I've learned to count.
Counting formulas do just that--give the total number of instances a given value occurs.
So I've got this task I've been DREADING--building a list of social studies books, without any duplications, for grades K/1/2/3/4/5. 1200 titles, altogether.
It's SO much faster. I've got two spreadsheets going at once--my list in process, and my list of potential books. The potential book list now tells me in what packages I've listed it, the total inventory in stock, and what I'd planned to do with the title (remove it, leave it as a potential, add it to the list). The list in process tells me how many duplications I have. This is like six times faster than last year, when I did all this crap with "Find within document"
Most people I work with are now learning the joys of counting.
It's so stupid--it's so obvious that MS Excel can do all of this, but unless someone specifically waves it in front of you, it's never apparent how absolutely necessary these things are.
I need to learn "IFCOUNT" next. With If/And/Or arguments. Oooh.