# Formula to pull the range of specific strings from another worksheet...

##### New Member
Hello,

I have read a ton of the posts in this forum and everyone seems so helpful so I am hoping I can get the same results

I have a spreadsheet that holds percentile data for each day of the month (which each month is layed out in its own worksheet). On the main worksheet i run a percentile formula to pull the data from the date worksheet for each specific text string to pull the 95th and 98th percentile of the day. My issue is that the data I am pulling is never the same as one day the text will have the 287 results while the next day it will only pull 80. The problem here is I am pulling data multiple areas and need to sort through the data each day and recalculate my formulas.

With all of that said, is it possible to have a formula that can determine the amount of rows used by a specific string (column A) and then formulate percentile data based on what it shows in columns H and N? I need to show the 95th percentile and 98th percentile for H and the same for N, so I would prefer those be in separate rows. I know I didn't do the best job explaining so if there are any questions please let me know.

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Using excel 2007. Thanks!

 Example - Main Sheet ServerName Date Data H Data H Data N Data N A 6/1/2012 95th percentile (from sheet 2) 98th Percentile(from sheet 2) 95th percentile (from sheet 2) 98th Percentile(from sheet 2) B 6/1/2012 95th percentile (from sheet 2) 98th Percentile(from sheet 2) 95th percentile (from sheet 2) 98th Percentile(from sheet 2) C 6/1/2012 95th percentile (from sheet 2) 98th Percentile(from sheet 2) 95th percentile (from sheet 2) 98th Percentile(from sheet 2) Example - Sheet 2 ServerName Date Data needed (Column H) Data needed (Column N) A 6/1/2012 5:00pm 34.89 8 B 6/1/2012 6:00pm 45.6 10.7 A 6/1/2012 7:00pm 45.9 10.65 C 6/1/2012 8:00pm 50.43 11.48 A 6/1/2012 1:00am 23.96 8.4 C 6/1/2012 2:45PM 44.09 21 C 6/1/2012 4:45PM 16.22 11.22

<tbody>
</tbody>

Replies
2
Views
402
Replies
2
Views
317
Replies
0
Views
105
Replies
3
Views
625
Replies
3
Views
52

### Forum statistics

1,203,489
Messages
6,055,723
Members
444,814
Latest member
AutomateDifficulty

### 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