Hi,

I would like to seek your help. I have a set of data, say A1:A400 in column A.
I want to get the median but the duplicate numbers must be ignored. Is there a way to compute this?
I am using Excel 2007. Thank you very much in advance for your assistance.

Rianne