Links between two workbooks – dynamically using functions
I don’t believe I don’t have this here yet. This is one of my oldest tricks When we have to do links between two workbooks (One cell in Workbook1 to …
VLookup
I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to post it here, but we …
CONVERT function
Excel 2010 has a lot of new exciting things, one of them is the ‘Engineering’ category of functions, this was usually a plugin we have to add to get, but …