What results would you expect? With those numbers I get 244 as the 50%ile and 455 as the 90%ile.
But if I change

COUNTIF(Work!$A$2:$A$2000,A33)/1.11

to

ROUND(COUNTIF(Work!$A$2:$A$2000,A33)/1.11,0)

then I get 482 as the 90%ile.

HTH,
Bernie
MS Excel MVP


"PAL" wrote in message
...
Near as I can tell its a stats problem. I have done it two ways, removed all
the data with the exception of the data generating these numbers or I kept it
all in. The 90th was working originally.

The numbers in the data set are
152,239,239,244,244,244,263,273,364,455,482,482

I can get the 50th and 90th percentile if I delete 3 of the numbers - 482,
244, 244. Obviously the dups are messing it up. If I remove 2 x 244 it
works. Obviously, I can't control the data so it seems like I have a
problem.

Not sure where to go from here.