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 Omit Some Data in Excel

-

The FILTER function in Excel is a dynamic array function that allows you to filter a range of data based on one or more criteria and return a filtered array that matches the criteria. The function can be used to filter both rows and columns.

Syntax: FILTER(array, include, [if_empty])

where:

·        include: The criteria or conditions to be used for filtering.

·        if_empty: [Optional] The value to return if the filtered array is empty.

Here are some examples of how to use the FILTER function:

1.  Filter rows based on one condition:

How to Omit Some Data in Excel

This formula filters the range A1:E5 based on the condition that values in column E are smaller than 50 and returns the filtered array.

2.  Filter rows based on multiple conditions:

How to Omit Some Data in Excel

This formula filters the range A1:E5 based on the conditions that values in column E are smaller than 50 and values in column B, C, D are greater than 50 and returns the filtered array.

Note that the FILTER function is only available in Excel for Microsoft 365 and Excel for the web, and requires dynamic array support.

 

Popular posts from this blog

Top international payment gateway transaction fee comparison (2024)

-
There are lots of top international Payment gateway over the internet to get paid online. You must be confused which payment gateway to choose for receiving money from different market places and transfer to your own local bank account. Which payment gateway charge low fee for receiving money and low charge for transferring to local bank account. Bellow is the comparison in between Payoneer, Skrill and PayPal. Payment gateway Name Account & Card maintenance - charge Transfer in between same wallet - charge Transfer from wallet to local bank account - charge Receive from market place to wallet - charge 1.       Payoneer Annual account fee = 29.95 USD (If you have received less than 2,000.00 USD (or equivalent) in payments per Year)   Annual card fee: First card = 29.95 USD   Additional cards in any currency = Free FREE EUR, USD, GBP, and m...
Read more

What is Python Syntax and how to use?

-
Python syntax refers to the set of rules and structure that defines how a Python program is written and interpreted. Understanding Python syntax is essential to writing code that the Python interpreter can execute. Below is an overview of Python syntax and how to use it: ### 1. **Basic Syntax**    - **Case Sensitivity**: Python is case-sensitive, so `Variable` and `variable` are considered different.    - **Indentation**: Indentation is used to define blocks of code. Python uses indentation (usually four spaces or a tab) to indicate a block of code, such as in loops, conditionals, and function definitions. For example:      ```python      if condition:          # Indented block          print("Condition is true")      ```    - **Comments**: Comments are lines that Python ignores, used for annotations. ...
Read more

How to Manage Boot Configuration of Windows using CMD

-
Image
In CMD (Command Prompt), the "bootcfg" command is used to manage the boot configuration data (BCD) for Windows operating systems. This command is used primarily to configure the boot.ini file for older versions of Windows, as newer versions use the BCD store. The syntax for the "bootcfg" command is: bootcfg [options] The " options " argument is optional and can be used to modify the behavior of the command. For example, the " /add " option can be used to add a new operating system entry to the boot configuration data. For example, if you want to reconfigure boot.ini file to remove any defects, you may use the following command: bootcfg /rebuild The command will scan all drives for any Windows installations, display the results, and step you through building the boot.ini file. Note that the " bootcfg " command is not available in newer versions of Windows, which use the BCD store instead of the boot.ini file. In these version...
Read more