Perhaps =MAX(A1:A10)-MIN(A1:A10)?
It's already been pointed out that there is no maxdiff function built in to
Excel.

--
tj


"market researcher needs help!" wrote:

Does anyone know what maxdiff refers to or how I would do it?

Thanks!