Administration and Executive AssistantTier 720 minintermediate

TAKE: Most Recent vs First

Average the most recent entries in a growing log, using TAKE's negative-count form.

What you will learn

• Use TAKE with a negative count to take rows from the end of an array instead of the start
• Explain the difference between TAKE(array,5) and TAKE(array,-5)
• Recognise which end of a log the most recent entries actually sit at

Excel skills

TAKE · Array Formulas

The task

A log runs from oldest reading (day 1) to most recent (day 12). Work out the average of the 5 most recent readings, in Summary!B3.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free