Pulling Most Recent Entry

Kacey

I've created multiple quizzes using forms for employee training. I have the sheets set up to automatically grade the answers and give me a total score. Each employee then has a main sheet which displays the quiz name and what score they received on each quiz.

I'm using this formula to pull the score from the quiz sheet onto their main sheet:

=VLOOKUP([Employee Name]1, {A1: Exterior Set Up Quiz Range 1}, 14, 0)

This works but I'm running into a problem when an employee takes a quiz more than once. I only want their most recent score to populate onto their main sheet.

I have tried an IDEX COLLECT formula but because each formula is unique I was cut off after 100 formulas. I have more quizzes than that so I'm stuck.

Any help is appreciated!

Michael Culley

One way around it is to make it so new form entries are put at the top of your sheet instead of the bottom. Would that solution work for you?

Michael Culley

One way around it is to make it so new form entries are put at the top of your sheet instead of the bottom. Would that solution work for you?

Michael Culley

You go to edit forms, then in your form settings you'll see the option to have new entries populate at the Top of your sheet.

Kacey

Thank you so much Michael!! That is exactly what I needed.