DECILE YES
CLICLIC
Posted messages
23
Status
Member
-
michel_m Posted messages 18903 Registration date Status Contributor Last intervention -
michel_m Posted messages 18903 Registration date Status Contributor Last intervention -
Hello,
Is there a function called Decile If or a way that would allow me to obtain D1, D2, ... with a condition and without using macros, which I am completely useless at!!!
Thank you!
Is there a function called Decile If or a way that would allow me to obtain D1, D2, ... with a condition and without using macros, which I am completely useless at!!!
Thank you!
6 answers
Hello.
You click on Insert Function and you get the complete list of functions available in your version of Excel.
--
Retirement is great! Especially in the Antilles... :-)
☻ Raymond ♂
You click on Insert Function and you get the complete list of functions available in your version of Excel.
--
Retirement is great! Especially in the Antilles... :-)
☻ Raymond ♂
CLICLIC
Posted messages
23
Status
Member
Lucky you, I can't wait to retire too!!!
Hello
1. The DECILE function does not exist (at least with Excel 2003), you need to use the PERCENTILE function (value-range; percentile-number)
where percentile-number must be a multiple of 10 to obtain a decile
example
=PERCENTILE($A$1:$A$1000;10) to get D1
=PERCENTILE($A$1:$A$1000;90) to get D9
2. I don't see what you mean by "with condition"
Best regards
1. The DECILE function does not exist (at least with Excel 2003), you need to use the PERCENTILE function (value-range; percentile-number)
where percentile-number must be a multiple of 10 to obtain a decile
example
=PERCENTILE($A$1:$A$1000;10) to get D1
=PERCENTILE($A$1:$A$1000;90) to get D9
2. I don't see what you mean by "with condition"
Best regards
Good evening michel_m,
I am very interested in CCM81's proposal and I responded to him so he could understand my problem.
Raymond kindly tried to help me as well by leaving a comment about retirement (which is nice). One would have to be rude to ignore that!
Do you have a solution to my problem?
Interventions are supposed to be productive... in a friendly manner!!!
I am very interested in CCM81's proposal and I responded to him so he could understand my problem.
Raymond kindly tried to help me as well by leaving a comment about retirement (which is nice). One would have to be rude to ignore that!
Do you have a solution to my problem?
Interventions are supposed to be productive... in a friendly manner!!!
Hello,
When I talk about condition it's because I have a large list of people with different age brackets and I would like to know what the D1 or D5 is for each age bracket without having to sort them. But already, having the function will save me time.
Thank you.
When I talk about condition it's because I have a large list of people with different age brackets and I would like to know what the D1 or D5 is for each age bracket without having to sort them. But already, having the function will save me time.
Thank you.
Hello again,
The formula works well when we do: =PERCENTILE($A$1:$A$1000,0.1) to get D1
I'm using a conditional formula to calculate the minimum by creatively using the formula:
=MIN(J2:J1088) as {=MIN(IF($L$3:$L$1078=$L1,$AS$3:$AS$1078))} and it saves me a lot of time.
I was thinking about trying the same thing with PERCENTILE but it doesn't work.
If I find the solution, I will let you know. If you have any other leads like this (excluding macros), I'm interested!!!
Have a nice day.
The formula works well when we do: =PERCENTILE($A$1:$A$1000,0.1) to get D1
I'm using a conditional formula to calculate the minimum by creatively using the formula:
=MIN(J2:J1088) as {=MIN(IF($L$3:$L$1078=$L1,$AS$3:$AS$1078))} and it saves me a lot of time.
I was thinking about trying the same thing with PERCENTILE but it doesn't work.
If I find the solution, I will let you know. If you have any other leads like this (excluding macros), I'm interested!!!
Have a nice day.
1. I see that you corrected the mistake (it had been an eternity since I last used centile and since I haven’t tested ....)
2. An attempt with a macro (to be tested!!)
https://www.cjoint.com/?3Bbk1gT0stK
3. Don’t hold it against Michel, actually you replied in the comments at the beginning of your first post, so he didn’t see it, the custom on CCM is to respond at the end of the "list"
Have a good continuation.
2. An attempt with a macro (to be tested!!)
https://www.cjoint.com/?3Bbk1gT0stK
3. Don’t hold it against Michel, actually you replied in the comments at the beginning of your first post, so he didn’t see it, the custom on CCM is to respond at the end of the "list"
Have a good continuation.
Thank you ccm81.
Indeed, I am new to this forum and you are right to inform me.
Tonight, I will try to test your point 2 because today I have an emergency...
I am part of a "photo" forum and sometimes people come to pollute our exchanges. I thought Michel was one of those cases.
Thank you very much for your intervention and have a nice weekend.
Michel: sorry if I was a bit harsh. Have a nice weekend to you too.
Indeed, I am new to this forum and you are right to inform me.
Tonight, I will try to test your point 2 because today I have an emergency...
I am part of a "photo" forum and sometimes people come to pollute our exchanges. I thought Michel was one of those cases.
Thank you very much for your intervention and have a nice weekend.
Michel: sorry if I was a bit harsh. Have a nice weekend to you too.