Conditionally Find the Smallest Value | Google Sheets
Learn how to find the smallest value in a dataset depending on other values.
filter
StaySorted – Keep Google Sheets Rows Automatically Sorted
Keep a table of data sorted automatically.
UNIQUE Function – Google Sheets
Remove duplicate lines from a table of data
SORT Function in Google Sheets
Sort a range and output the dynamic results.
FILTER Function in Google Sheets
Narrow down a range of data to only items that meet the criteria that you specify.