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

-
Image
 Did you forgot your bit locker pin and recovery key. Try these methods, I hop it help you. 1. When you see this screen, Press "Esc" key in your keyboard for more recovery option. It will say preparing BitLocker recovery, You will see the screen bellow in few minute. Here we will click on "Skip the drive", You will see the screen bellow. Here you need to Turn off your PC, and then enter the BIOS of your PC. In order to enter BIOS, check for your PC brand and model and search on google, how to enter BIOS for your particular brand and model of your PC. Search for "Secure Boot" Enable it and check it, if it works for you. If it do not work, come back to same place and Disable "Secure Boot" and try again, see if it work for you. 2. If the above method do not work for you, try resetting your PC, You can choose any of the two option for resetting your PC, "Keep my files" or "Remove everything" whichever works for you. 3. If the abov...

How to do Custom Mathematical Operations in an Array in Excel

-

Using REDUCE function with LAMBDA, we can do the job. The REDUCE function in Excel 365 Dynamic Array is used to reduce a range or array of values to a single value using a specified operation. It is similar to the SUM function, but allows for more complex operations such as finding the maximum or minimum value.

Syntax: =REDUCE(array, operation)

Here, operation can be one of the following:

  • SUM: Returns the sum of the values in the array.
  • PRODUCT: Returns the product of the values in the array.
  • AVERAGE: Returns the average of the values in the array.
  • MAX: Returns the maximum value in the array.
  • MIN: Returns the minimum value in the array.

For example, we have a column with some numbers. If we want to get the sum of only even numbers in one cell and sum of odd numbers in another cell, we can do it by using the REDUCE function:

 

How to do Custom Mathematical Operations in an Array in Excel

Fig.1: For Even Numbers

How to do Custom Mathematical Operations in an Array in Excel

Fig. 2: For Odd Numbers

Note that the REDUCE function can only be used with the Excel 365 Dynamic Array version, as it returns an array of values rather than a single value.