Hi,
I've tried many ways but i realized it cant be count if the formula to get the grade is aggregated. Please do help.
Is there anyway i want to list number of A's, B's, C's, D's and E's?
Oct 31, 2019 7:07 PM
Please attach your packaged workbook (.twbx).
Thanks for Replied. I've attached the twbx file
Oct 31, 2019 10:48 PM
Is this the expected output?
If yes, you can check out what I did in the attached workbook.
Note: I have deleted all the sheets and the source which were not needed so that it was easy to work with.
Thanks Hari. It is what I'm looking for. It is awesome.
Nov 27, 2019 7:21 PM
You are welcome!
Hi Hari,
But i realized the calculation is incorrect. For example, it should be only 1 A but it shows 3, i believe is because you calculate the company and PIC individually.
Dec 2, 2019 9:38 PM
I do not know your business requirement. So, please modify the formulas as required to get the desired results.