STEP-BY-STEP 3 min
How to find the second largest value for storage boxes in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row storage boxes example with the exact formula and an expected result.
How Pink Editorial
A HOW.PINK COLLECTION
Spreadsheets & data starter path
A checked sequence of small worked examples. Choose a method and verify it before adapting the pattern.
1,000 guides · One step at a time
STEP-BY-STEP 3 min
How to find the second largest value for project estimates in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row project estimates example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second largest value for language practice in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row language practice example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second largest value for event supplies in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row event supplies example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second largest value for music practice in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row music practice example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second largest value for book collection in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row book collection example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second largest value for packing checklist in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row packing checklist example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second largest value for desk accessories in a spreadsheet
Find the runner-up without reordering the table. Follow a five-row desk accessories example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for grocery spending in a spreadsheet
Find the second value in ascending order. Follow a five-row grocery spending example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for reading sessions in a spreadsheet
Find the second value in ascending order. Follow a five-row reading sessions example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for garden observations in a spreadsheet
Find the second value in ascending order. Follow a five-row garden observations example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for craft supplies in a spreadsheet
Find the second value in ascending order. Follow a five-row craft supplies example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for home inventory in a spreadsheet
Find the second value in ascending order. Follow a five-row home inventory example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for study sessions in a spreadsheet
Find the second value in ascending order. Follow a five-row study sessions example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for photo folders in a spreadsheet
Find the second value in ascending order. Follow a five-row photo folders example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for walking logs in a spreadsheet
Find the second value in ascending order. Follow a five-row walking logs example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for recipe portions in a spreadsheet
Find the second value in ascending order. Follow a five-row recipe portions example with the exact formula and an expected result.
How Pink Editorial
STEP-BY-STEP 3 min
How to find the second smallest value for volunteer hours in a spreadsheet
Find the second value in ascending order. Follow a five-row volunteer hours example with the exact formula and an expected result.
How Pink Editorial