Skip lists are used for efficient statistical computations of running medians (also known as moving medians). Skip lists are also used in distributed applications (where the nodes represent physical computers, and pointers represent network connections) and for implementing highly scalable concurrent priority queues with less lock contention,  or even without locking,    as well as lockless concurrent dictionaries.  There are also several US patents for using skip lists to implement (lockless) priority queues and concurrent dictionaries. 
At present I have 2,000 lines with formula in them.
on average we’ll say about 1,000 lines show up on SHEET2 & SHEET3 as being populated and the remaining 1,000 lines are blank with formula only.
When I created the dynamic range and used it in a pivot table it shows all the different results plus 1 extra that is blank and throwing my total way off – example below (in reality I’ve hundreds of rows with small quanities).
Is there any way to tell it to only count cells that contain text??
any help is appreciated.
Thanks for a thoughtful article. I personally find that typography is an art form, and that both serif and sans serif fonts can be poorly set or well set.
A font like Helvetica in the hands of a good typographer can, not only be eminently legible, but can be quite beautiful. By the same token serif fonts may also be beautifully set. One of my favorite serif fonts is Zapf Elliptical, which in good hands, can also be a delight to the eye.
With the advent of computer-based printing, everyone fancies themselves an expert. Unfortunately just selecting fonts and their sizes is not typography. Letterspacing (kerning) and leading can change the whole look and feel of a block of text.
A new magazine called CODEX (especially for typomaniacs) may be found at http:// and some very interesting work on typography can be found at http:// .