Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Case: Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection. Requisites:   Dead phone USB Cable  You tried tons of tutorials to unbrick the phone and didn't work This image Willingness to even use Linux to fix it (it's not hard) Steps: Create a bootable USB using the image downloaded. Make sure your computer allows booting from USB. Boot the computer from the bootable USB. When booting, a list of options will be shown. Pick the first one: Boot Live system. Once the system is loaded, go to the right-upper corner to connect to Wi-Fi. Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of this tool (SP Flash) and save it in the desktop. Unzip the tool downloaded. Download the fastboot version of the stock ROM . Unzip the ROM, to have the folder and files. Click on 'MTK' icon that is in the desktop. In the command line opene

Feature on Excel 2007/2010 to Remove Duplicates

Maybe you faced this situation: you have a lot of rows in Excel with many columns and you that you are only looking for codes which are in the first column to build a useful report.

As you are very intelligent, you decide to copy the first column on another sheet to begin the construction of your desired report. However, you realize at that moment that you have indeed duplicated codes, one code you saw it on row 13 and the same on row 65 and so on.

Now, you have to look for a way to do it without wasting your time, therefore I will give a idea that have just came to mi mind:

1) Copy the column in a new sheet and apply an ascending order.

List with duplicates

2) Use the equal operator to determine if the number on the left is equal to its predecessor. At this point you will have a TRUE or FALSE in the right cell of each number.

Compare the cell with the cell above

3) Filter the TRUE cells and remove these rows, you will keep only FALSE cells and, as you can see, there will be no duplicate codes.
 
Delete all the cell with the TRUE value

But, as you are using Excel 2007/2010... why don't you use the remove duplicates button? haha. For this just select the cells you want to be with no duplicate values, go to the Data ribbon and click the "Remove duplicates" and wait until Excel do its job.

Comments

Popular posts from this blog

Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Inserting Rows o Columns in Excel Not Permitted

Turn Horizontal Visio Swimlanes into Vertical Ones