Hi
There are two sheets and I need to get a count of all the individual tests for each DRG category on the DRG sheet from the test sheet to create a pivot report.
This is just a demo there are lots of DRGs and the tests sheet runs upwards of 500,000 rows.
I have tried many things but now I am just blank and being under the pump I though I would ask the experts.
Hoping someone can help
thank you
Tony
There are two sheets and I need to get a count of all the individual tests for each DRG category on the DRG sheet from the test sheet to create a pivot report.
This is just a demo there are lots of DRGs and the tests sheet runs upwards of 500,000 rows.
I have tried many things but now I am just blank and being under the pump I though I would ask the experts.
Hoping someone can help
thank you
Tony
