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...
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...
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...