Tag: Function
-
New function in Excel 2016 to display in a cell, the formula contained in another cell
You must have come across a number of situations when you were trying to explain a formula that you have written in Excel and the result of the formula. This kind of situation basically demands both the formula expression and the formula result to be displayed simultaneously. For example, from…
-
VLOOKUP: Right to Left Lookup
We all now know that VLOOKUP has one major constraint that the column in the lookup table from where the lookup value is to be searched should be the first column in the lookup table. Here is a tricky way that you can use to overcome this constraint. The trick…
-
MS Excel Keyboard Shortcuts
Hi.. Here I have composed a comprehensive listing of keyboard shortcuts for Microsoft Office Excel 2010 in downloadable PDF format. Please do share the keyboard shortcuts if you know any that are missing in this list and help improve this listing. Do share your comments or suggestions, if any.. [office…