...

• Filter-select all by "*Faculty" in Title column ("E).
• Column "G", Email address. Code:
  • =CONCATENATE(D2,"@cornell.edu")
    • Reminder: Replace the 2 in D2 with the right number!
• Column "H", Full name. Code:
  • =CONCATENATE(B2," ",C2)
    • Reminder: Replace the 2 in D2 with the right number!

Determine changes of people between months

Copy spreadsheets of two months to compare into a directory.

Open spreadsheets and sort them the same. Such as Data => Sort:

1. Supervisor/ Chair
2. Last name
3. Firstname

Copy old data into new spreadsheet.

• Keep only columns A-E
• Paste into column "I".

Code for column "F". Grads:

• =MATCH(E2,M:M,0)

Staff:

• =MATCH(D2,L:L,0)

Code for column "H":

• =IF(F2=G2,"","!!")

Fill in column "G" sequentially, 2 through to the end.

Insert rows in either data set to get them to match.