Variable class, reuse logic per class

Hi,

I am trying to read an export file and count some instances based on their department name.
I wish to make te same types of count (based on some logic) for each class (e.g. department), there are 20+ departments so I would not like to repeat the logic instead of copying the logic code for every class.

Here is an simplified version of the the code where i reuse the code on every class?

Please Login or Register  to view this content.

Can anyone help me in right direction?

TIA

AB

Thanks Rorya for the quick response, that got me in the right direction.
This solution results in a nested ElseIf formula 20 levels deep, so i would like to populate de class from a reference table (containing two columns, the search value and the class name)

Please Login or Register  to view this content.

Do you have any idea why I can't adress the 'D class' with the string that is found with the code show above? (it results in an Errer 13, Type do not match)