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
Super duper cool.
ReplyDeleteHi Ronald, I am trying to use this formula, but its not working, somehow following the same steps with my excel 2010, gives me an error.
ReplyDeleteHow does the indirect formula know where to get the data that it brings?
Hi Daniel! indirect function just convert a text given as parameter into a reference, I mean, if you write this =indirect("A1"), the function will bring the value which is in the reference A1.
DeleteTherefore, when I show =indirect(B3), Excel will derive =indirect("Australia") because B3 contains the string "Australia". But as "Australia" is a named range then Excel brings all the values which are inside "Australia" range.
Hello! I was experiencing quite the same problem which I partially solved using your method. However I would like to adjust it a little (if possible). My problem is that the first list (in A1) has just values YES or NO. When I select NO, in the B1 there should be a list of given dates. So far this works great, but when I select YES, I want to have an exact value in the B1 (specificaly 1.1.2013) instead of having another list with this single value. Is there any way of doing that? Thank you for any response!
ReplyDeleteHi! sorry for being late, maybe this could help you, on B1 you should use a data validation using lists, using this function:
Delete=IF(A1="YES",INDIRECT("UNIQUE_VALUE_LIST"),INDIRECT("MULTIPLE_VALUE_LIST"))
Yes, you need to have a named range "UNIQUE_VALUE_LIST" and "MULTIPLE_VALUE_LIST".
I got the error message too and said yes, continue. What happens is the second column will not show a list until you select a country in the first column. Once you select a country, it works like a charm!
ReplyDeleteHi! I didn't understand what you're trying to explain... I'll appreciate if you could give me more details. Thanks.
DeleteDude, that is sweet! Worked like a charm. Good job!
ReplyDeleteThanks a lot! : )
Delete