Administration and Executive AssistantTier 1212 minadvanced

Require Each Entry to Exceed the One Before It

Validate that every new reading is strictly greater than the reading above it.

What you will learn

• Write a custom data validation formula that compares a cell to the one above it
• Explain why a positive-number check alone cannot catch a reading that goes backwards
• Recognise a row-relative validation formula versus a fixed reference

Excel skills

Data Validation - Custom Formula · Data Validation

The task

Vehicle odometer readings can only ever go up. The first reading (45710 km) is already logged in row 2. Add a custom validation rule to the readings below it so each new entry has to be greater than the one directly above it.

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