I would seek to have a formula or array statement that will give me the required figures in the attachment.
1) In the attachment, Column E should give me the figure on how many times the Grade Code of the employee have changed based on Column D (it is GC 8, 9, 11, 12 , 13, 14 = 6 for Mr. A and Grade Code 7, 8, 9 and 10 = 4 for Mr. B)
2) Lkewise, in Column G should give me the number of times the Job Title have been changed based on data in Column C.


____________________________
Attached:

You don't specify the database type used to store this information, but since this is posted in the VB.NET forum I am assuming that you have probably used SQLExpress. Whatever the database type the SELECT statement will be very similar to:-

SELECT     COUNT(*) AS Changes FROM         (SELECT  Grade                        FROM EmployeeChanges                        GROUP BY Grade) A

____________________________
multi-tasking - the ability to hang more than one app. at the same time.