Does anyone know how to do this without writing VB or using Access?

9/11/2011 4:35:33 PM

Try a real data analysis package.

Nevertheless, it shouldn't be hard. How are you wanting to do the weighting?

9/11/2011 4:41:14 PM

NEVERMIND I FOUND AN EASY WAY TO DO IT. I feel dumb.

Just divide column B by 2 to get the average then match up column A with the cumulative to get the median.

[Edited on September 11, 2011 at 4:59 PM. Reason : s]

9/11/2011 4:49:03 PM