Hi
I have tried searching for the answer to the following but not sure how others might phrase what I need.
I have a workbook with two sheets.
1st Sheet = Data
2nd Sheet = Data Tally
In the first sheet I have the columns A(ID No) B(Surname) C(Forename) D(Course) E(Days Taken)
If someone goes on a course the data above gets entered in. If they then attend another course a new record gets created underneath with the same ID No. In theory there could be 20 rows of courses for just one person.
What I need is to tally the amount of days taken.
i.e. if ID No= x then Count Days Taken.
This will then go into sheet 2 under the tallys.
Is this possible?
Thanks in advance
I have tried searching for the answer to the following but not sure how others might phrase what I need.
I have a workbook with two sheets.
1st Sheet = Data
2nd Sheet = Data Tally
In the first sheet I have the columns A(ID No) B(Surname) C(Forename) D(Course) E(Days Taken)
If someone goes on a course the data above gets entered in. If they then attend another course a new record gets created underneath with the same ID No. In theory there could be 20 rows of courses for just one person.
What I need is to tally the amount of days taken.
i.e. if ID No= x then Count Days Taken.
This will then go into sheet 2 under the tallys.
Is this possible?
Thanks in advance