I have to create a macro, which can count for me how many of different categories of services we have.
there are around 20 main categories and 2 subcategories. So eg i have to make the macro count how many of the category AM-AM, with the state *candidate* with the suffix s
The result should be exported to another sheet.
Please help me. I really tried everything
I am working in excel 2003
Macro which can countif on multiple criteria and export result