?

Log in

No account? Create an account

Previous Entry | Next Entry

Today, we learn to count.

My big thrill last year with Microsoft Excel was the v-lookup--a slightly complicated formula that scans one spreadsheet and 'ports information back to a master spreadsheet (so, you could have a list of times on page one, a TV schedule on page 2, and import what show runs at what time to your page one list.) Vlookups save SO much time when I'm importing information from one list of 14,000 product codes into another list of 5434 product codes. Wow.

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.

Comments

( 3 comments — Leave a comment )
khime
May. 26th, 2005 01:26 pm (UTC)
I always want COUNTIF to do more than it actually does, somehow. SUMIF is even more fun; very useful for taking your checkbook statement and generating a list of what you spent where.
spottylogic
May. 26th, 2005 01:46 pm (UTC)
It also sounds just a bit like a lesser-known god of root vegetables. I'll have to work on understanding alot of these "if" statements, they're tricky for my little dog-brain!
khime
May. 26th, 2005 03:54 pm (UTC)
I guess my mouse-brain grasps them more intuitively... at least until I get an OUT OF CHEESE error.
( 3 comments — Leave a comment )

Latest Month

August 2011
S M T W T F S
 123456
78910111213
14151617181920
21222324252627
28293031   

Page Summary

Powered by LiveJournal.com
Designed by Taylor Savvy