Forgot bit locker pin, forgot bit locker recovery key, 5 Easy ways to fix

The AGGREGATE function in Excel allows you to perform a variety of aggregate calculations (e.g. SUM, AVERAGE, MAX, MIN, COUNT) on a range of cells, while ignoring any errors or hidden cells. This function is particularly useful when working with large data sets that may contain errors or blank cells.
The syntax for the AGGREGATE function is: AGGREGATE(function_num, options, array, [k])
Where:
For example, the following formula calculates the average of a range of cells (D1:D10), ignoring any hidden cells:
To find maximum value, follow the formula:
To find summation of the values, follow the formula:
Note that the function_num and options arguments can be combined to create a variety of aggregate functions with different behavior. For example, using function_num = 6 and options = 1 calculates the median of the range, while function_num = 9 and options = 1 calculates the mode of the range.