I am looking to find a formula for finding a value based on an array - with a % as the variable. I have outlined in the sheet attached.
You can see 4 columns labeled A, B, C, and D. Above each of them is an empty cell. I am looking to find what the value would be for each array at a certain percentile (cell I3). For instance, What would the value in cell A3 be if I was looking for the 25th percentile of the array in column A (A6:A24)?
Adam
Probably with the formula percentile.
See if the green cell in the attached file, gives the correct answer.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
In C3 copied to ..E3..G3..I3
Formula:
=PERCENTILE.INC(C6:C24,$K$3)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard, OP profile indicates 2007, dont think ???.inc is available?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks all, recently updated to 2010 - just changed on my profile. Thanks again!!
Ah,
I see the profile change. So thanks for the rep and glad it all works.
@Ford,
I hadn't spotted that, and to be honest didn't know (or couldn't remember at least) anyway.
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Adam Schaefer 
Register To Reply
Bookmarks