# Calculating percentiles using individual cells instead of an array.

#### mcb123

##### New Member
So I need to calculate the 95th and 5th percentile for a specific set of cells. However, my data is 10s of thousands of rows long as it is temperatures from every day of the year over a period of 30-100 years. So I want to work out the 95th percentile for the temperature on January 1st of every year.

I know the formula for the percentile function requires an array but my data isn't in this format.

I know this formula is incorrect but in theory, I need something along the lines of:
=percentile(B2;B368;B773,0.95)

Thanks!!

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Domenic

##### MrExcel MVP
I'm not familiar with the Mac version of Excel, but hopefully this works for you...

VBA Code:
``=PERCENTILE((B2,B368,B773),0.95)``

#### mcb123

##### New Member
Yes that worked thank you so much!

#### Domenic

##### MrExcel MVP
That's great, glad I could help. Cheers!

Replies
0
Views
202
Replies
8
Views
86
Replies
2
Views
242
Replies
0
Views
123
Replies
38
Views
984

1,127,379
Messages
5,624,351
Members
416,022
Latest member
JonathanSass

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back