Takeda Pharmaceuticals interview question

What excel function would you use to return customer first names given the following data

Interview Answer

Anonymous

9 Apr 2014

Involved subsetting functions. Didn't need to write the formula, just say the names of the functions