Tagged: Need help
April 20, 2018 at 8:00 pm #9604
I attached a sort of table and I’d like to calculate percentile 80 to “qtd/cons” for each category in “Col1” as a calculated column.April 20, 2018 at 8:25 pm #9606
And this one attached is the expected resulsApril 21, 2018 at 4:28 pm #9609
Marco Russo and Alberto Ferrari given an example of a percentile calculation using Excel 2013 which you can read about here.April 21, 2018 at 6:29 pm #9610
Ive seen this post before. Yeap!
The question there works for only um category. I have a column not with one category but multiple caregories.
When I implement that calculation that works fine for all values. When I place my column of categories this summarizing process does not works for that methodApril 21, 2018 at 8:24 pm #9611April 21, 2018 at 8:33 pm #9612
Tom, I think this might be a good Cue… Uhuuul
Im going to try. ThksApril 21, 2018 at 8:37 pm #9613
Am thinking good thoughts for your success!April 22, 2018 at 12:34 am #9614
Thanks for all you support! I was seeking this answeer for at least 20 hours. Thank you!
If someone wants to see the final archive, see attached.April 22, 2018 at 1:54 am #9616
Many thanks for the kind words.
Glad to hear of your success!
You must be logged in to reply to this topic.