MrsFraser07
New Member
- Joined
- Aug 16, 2017
- Messages
- 44
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi there,
I am stumped if this is possible. What I am trying to do is calculate a Percentile using only visable data after I've filtered several columns. For example, if I filtered column E to "Frobisher" how could I calculate the 50th Percentile of column F so it doesn't include anything that is "Midale"? I would also like to be able to filter on column H and have the Percentile calculate using only the visable filtered data. I can't upload a mini-sheet, because I'm at work and that's not allowed so hopefully my image makes sense. This is just a small sampling of the data I have, which is why I want to be able to get a Percentile using only filtered data. I want to be able to filter multiple things without having to change my array in the Percentile.Inc function.
I am stumped if this is possible. What I am trying to do is calculate a Percentile using only visable data after I've filtered several columns. For example, if I filtered column E to "Frobisher" how could I calculate the 50th Percentile of column F so it doesn't include anything that is "Midale"? I would also like to be able to filter on column H and have the Percentile calculate using only the visable filtered data. I can't upload a mini-sheet, because I'm at work and that's not allowed so hopefully my image makes sense. This is just a small sampling of the data I have, which is why I want to be able to get a Percentile using only filtered data. I want to be able to filter multiple things without having to change my array in the Percentile.Inc function.
| A | E | F | H |
| 101/04-05-005-04W2/0 | Frobisher | 70,000 | 9/7/2021 |
| 193/04-09-005-04W2/0 | Frobisher | 65,000 | 12/23/2010 |
| 103/16-36-001-05W2/0 | Midale | 22,500 | 2/5/2020 |
| 101/01-02-001-06W2/0 | Midale | 44,000 | 3/27/2017 |
| 101/03-14-001-06W2/0 | Midale | 77,000 | 10/17/2017 |
| 102/16-25-001-06W2/0 | Midale | 13,000 | 5/14/2017 |
