If I have a column of numbers from A1:A100 which is constantly being updated, what
formula would I need to put into cell A101 which could calculate the difference
between the highest and lowest numbers. Some cells might be blank, which I would
choose to ignore rather than be calculated as zero.

Thanks.
--