0 of 62
Arrays·Scenario·Lesson 57 of 62Pro

Tidy an event sign-up list

A real-world job using what the Arrays section covered.

What you’ll do

People signed up for sessions at a one-day conference, and some signed up twice. You’ll find out who’s really coming and build the keynote guest list.

The steps

4 steps
  1. 1
    In F2, list every email once, with the duplicates removed.
  2. 2
    In I2, count how many different people signed up.
  3. 3
    In I3, count the Workshop sign-ups.
  4. 4
    In J2, list the names of everyone going to the Keynote, each once, in A to Z order.

Scenario locked

Unlock the other 44 lessons for $49.99

Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.

Unlock for $49.99