Ashhu
Active Member
I have sheet attached.
i am trying to find out median value of power hours (B Col) for same part numbers (A col) and put it in C column. I am able to Averageif forumla to arrive avg of 350,450,550 but cannot do median if. need formula to fill median value in c3 and c6 cell . i have attached sample sheet, but my orginal sheet have 100+ part numbers (unique) with 1000+ cells.
i am trying to find out median value of power hours (B Col) for same part numbers (A col) and put it in C column. I am able to Averageif forumla to arrive avg of 350,450,550 but cannot do median if. need formula to fill median value in c3 and c6 cell . i have attached sample sheet, but my orginal sheet have 100+ part numbers (unique) with 1000+ cells.
