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.
Thanks everyone for your time.
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.
Thanks everyone for your time.
