> I often have data series with missing values; charting them is no problem
> by inserting #N/A into those cells. When I use max() and min(), however,
> both return #N/A! I tried to write a macro using the rank function that
> would step over those cells, but this produces a type mismatch error at
> any instant when it hits on a cell containing #N/A.
> 
> 

	Use array formula like this:

{=min(if(isna(A1:A100);false();A1:A100)}

It must be entered with CtrlShiftEnter in stead of Enter

A1:A100 is your data series range ...

-- 
Michael Zemljanukha