A 'no code' solution:
If the Status establishing algorithm is as you describe, then you can
use this formula (enter in the first row and fill down):

=CHOOSE(IF(SUMPRODUCT((($A$1:$A$9)=A1)*($C$1:$C$9= "Not Started"))
=3;1;SUMPRODUCT((($A$1:$A$9)=A1)*($C$1:$C$9="Compl eted"))+1);"Not
Started";"In Progress";"In Progress";"Certified")

This assumes that your data are in range A1:A9. Also - i'm using ';'
as list separator - in case you use comma ',' - then you need to
replace my ';' with ','.

This would mark all the individuals (even without sorting the list)
based on this logic:
- if all 3 modules for the last name are 'Not Started', then marked as
'Not Started'
- if all 3 modules for the last name are 'Completed', then marked as
'Certified'
- all the rest would be marked as 'In Progress'

Then, if you need to see every indivudual only once - you can filter
out the Unique values by using advanced filter.

A.



On 4 Dec, 16:31, CJOHNSO92
wrote:
Greetings,
I am trying to combine rows of data for e-learning students and then
determine certification status; here’s an extract as an example:

Smith * Module 1 * * * *Completed
Jones * Module 1 * * * *Completed
Doe * * Module 1 * * * *Not Started
Smith * Module 2 * * * *Completed
Jones * Module 2 * * * *Completed
Doe * * Module 2 * * * *Not Started
Smith * Module 3 * * * *Completed
Jones * Module 3 * * * *In Progress
Doe * * Module 3 * * * *Not Started

First I’d like to sort by Last Name. * Once sorted I need status – if all 3
modules completed, status='certified'. *If only 1 or 2 have been completed,
status='in progress', if none have been started, status='not started'.. *
Ultimate goal is:
Smith * Completed
Jones * In Progress
Doe * * *Not Started
File will be new each month (download from another system) and number of
rows will vary.
Many thanks for your help!