Difficulty 4 of 5 · about 5 min
Filter pending expense claims and sort them smallest first
The expense claims are in A1:C9 (claimant, amount in INR, status). In F2, write one formula that returns only the rows whose status is Pending, showing claimant and amount, sorted by amount from smallest to largest. The result will spill across F2:G5, so leave those cells empty. Nothing may spill into column H.
Loading grid…