| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Median of column I if column A numbers match
I'm using the 2007 version of Excel. I have a worksheet with 13,000 lines of
data. Column A is titled ITEM and column I is titled PRICE. I need to find the Median number of column I when the numbers in column A are the same. I have 2000 unique ITEM numbers. When the ITEM number in several rows match, I need a formula to find the Median value of the PRICE. So if A2, A3, A4 ... A20, and A21 all have the same ITEM number, then I need the formula to find the Median number of I2, I3, I4 ... I20, and I21. I've messed around with IF functions and can't seem to get it to work. Thank you in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median with Quantity Column | Excel Worksheet Functions | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| how to match the two column with numbers in excel? | Excel Discussion (Misc queries) | |||
| Match Column B numbers to Column A numbers | Excel Worksheet Functions | |||
| column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
