Excel f(x)s = Excel Functions
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 the flow of formulas to go to function1, function2, function3, or function4 based on an integer.More like a nested IF, it can actually replaces a…
If formula results in “”, then that cell will not be empty.When copy and paste as values, it will not be empty either.VersusWhen we use VBA (Macro command) Range.value = Range.value For that “” cell, it will make destination cell as empty. Sorting table will consider cells with “” as 0, while empty cells are…
Issue found several times in xls or xlsx, to get it fix https://www.mrexcel.com/forum/excel-questions/637277-excel-converting-numbers-dates.html
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
Worksheet and workbook specifications and limits For more limits of VBA inside Excel, check out http://BoldCodes.com/?DevID=26CFPFO4LB Feature Maximum limit Open workbooks Limited by available memory and system resources Worksheet size 1,048,576 rows by 16,384 columns Column width 255 characters Row height 409 points Page breaks 1,026 horizontal and vertical Total number of characters that a…
A question by a colleague on how to count number of unique items in a column made me realize, I don’t have that here.
So here it is …
We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format a cell in Excel, to show %, it automatically divide that number by 100 But we do not want that to happen this time. So here is the trick, in…
This is what happens when you spend too much time in Excel
Go have a break and get some life
Simplest way to get name of day as cell output from a date.
Because you can custom format a cell with date to show only that day name
This is not that.
Working a lot with Excel means seeing lots of errors and bugs inside Excel
Some of those are not likely bugs, but more like reaching the limit of the application.
