Explanation:
The #REF! error signals an invalid cell reference, which typically happens when cells targeted by formulas are deleted from the spreadsheet layout.
Explanation:
The LARGE function returns the k-th largest value in a dataset range. Sorting the range {10, 50, 30, 40} in descending order gives {50, 40, 30, 10}, where the 2nd largest value is 40.
No comments yet. Be the first to start the discussion!