When working with a large data set, you would be more productive ... Any parameter in square brackets is optional. Here is an example of how the FIND function would look in action: The above ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...