Excel selects the correct one based on which function_num you chose. Also, don’t worry about trying to remember all the options; Excel will provide drop-down lists with all the choices. Let’s work on ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear ...