Hi again,

Im using the following formula
=MEDIAN(IF(($A$2:$A$34249=$A2)*($B$2:$B$34249=$B2),$C$2:$C$34249))
to enter the median of entries in column C (based on conditions in columns A and B) into column D. I have 32429 rows in my workbook so I had created a dummy workbook with 17 data rows and applied the same formula with the 32429 replaced by 17 everywhere. The formula worked fine in the dummy workbook but its not working in the main sheet; it is giving me the same value in all the rows of column D. Maybe its something really trivial but for the life of me I cant figure it out. Please help me out with this. Thanks a lot.

The dummy workbook -
Book2.xlsm