I have a spreadsheet with around 45,000 line items. I have another sheet that has calculations on them to pull the numbers shown on the attachment. A regular median calculation in excel will bring up the value of 1. I believe this is happening because of the many values of 1 in column A. If I remove the duplicates I get a value of 10.5. Is there a way to manipulate a median formula so it will ignore all duplicate values?
Bookmarks