Ric F
Board Regular
- Joined
- Apr 15, 2011
- Messages
- 117
- Office Version
- 365
I have a table that had a provider name and Status with various rates per quarter. I am trying to get a table that will give me only the Active "A" providers on a different tab. Know I've done this in college years ago and cannot remember the way to do it. thanks for your help! Ric
| Provider Name | Status | 7/1/2014 | 10/1/2014 | 1/1/2015 | 4/1/2015 | 7/1/2015 | 10/1/2015 |
| ABC | A | 165 | 168.14 | 176.4 | 171.54 | 172.61 | 172.68 |
| BCD | A | 132.08 | 128.1 | 130.76 | 129.27 | 137.91 | 130.7 |
| CDE | A | 153.29 | 150.52 | 153.76 | 156.47 | 145.97 | 148.99 |
| DEF | I | 177.86 | 179.21 | 179.39 | 180.64 | 158.97 | 158.11 |
| EFG | A | 158.77 | 150.63 | 153.22 | 146.87 | 136.19 | 148.65 |
| FGH | A | 176.55 | 182.66 | 179.87 | 178.91 | 190.72 | 189.17 |
| GHI | I | 148.41 | 150.42 | 150.79 | 151.03 | 155.89 | 152.97 |
| HIJ | A | 144.46 | 142.81 | 143.54 | 143.72 | 152.68 | 155.75 |
| IJK | A | 133.88 | 129.2 | 133.47 | 129.98 | 147.08 | 150.36 |
| JKL | I | 160.39 | 161.96 | 163.93 | 163.69 | 181.4 | 180.29 |
| KLM | A | 126.78 | 127.21 | 125.73 | 123.22 | 136.04 | 137.96 |
| LMN | A | 159.67 | 158.63 | 159.16 | 154.36 | 156.07 | 154.03 |
