BoldCodes is here to help (BoldCodes.com or Bold.Codes), even though I doubt it, I mean the fact that you cannot do your task in Excel formulas. especially after you understand 25% of these formulas.
But when you do, check out the library of VBA/Excel (aka macros, aka vbscripts) programming codes at BoldCodes.com or Bold.Codes
It wasted few days, hitting my head at the wall.My mistake …. I trusted that Google Sheets function called GoogleTranslate is working as it is expected. Which is not You …
On your daily work, in Excel, you have had the need to redo actions, simple same action to multiple areas perhaps Or apply similar format to more than 1 region, …
Edit 2021-07-12: I needed this formula to work in a worksheet having space in its name, so original one did not work, here is the new version: =HYPERLINK(“[“&MID(CELL(“filename”,A1),SEARCH(“[“,CELL(“filename”,A1))+1,SEARCH(“]”,CELL(“filename”,A1))-SEARCH(“[“,CELL(“filename”,A1))-1)&”]'”&MID(CELL(“filename”,A1),SEARCH(“]”,CELL(“filename”,A1))+1,500)&”‘!B”&COUNT(B:B)+6,”Go Last”) Again, …
CountIF function cannot search for text longer than 255 chars. This is mainly found here … https://support.office.com/en-us/article/COUNTIF-function-E0DE10C6-F885-4E71-ABB4-1F464816DF34
If you are like me, then you must have needed to use CHOOSE functionThis is basically like “SELECT CASE” statement, but more limited So, in few words, you can derive …
