Hi,
I used the following formula to find the median for a range of numbers. I assume variable p in the below formula as 0.5.

=PERCENTILE(A1:A7,PERCENTRANK(PROB(A1:A7,B1:B7/SUM(B1:B7),,A1:A7),p,20))

The problem is for some range of data the above formula is not working properly. And for some other range of data this formula seems working fine. I took the formula from one of the posts in this forum and the link is,

http://www.excelbanter.com/showthread.php?t=135558

I have attached a sheet with some sample data. Please help me to resolve this issue.

Many Thanks in advance.