From the Not Just Numbers blog:
Popular posts from Glen Feechan's Not Just Numbers blog - The blog for those who know it's not just about the numbers. Typical content included is primarily Excel tips and other comment relevant to those responsible for finance in their business. Glen develops spreadsheets for clients all over the world via needaspreadsheet.com and helps accountancy practices to make better use of Excel through his Excellent Accountancy business.
Microsoft Office users will tend to use Excel to handle numbers and data, and Word to handle text - which, of course, is how it should be.
Just a short post today on a very useful use for theVLOOKUP function.
There are many times, particularly in accounting spreadsheets, where we are using codes e.g. Stock Codes, Nominal/Sales/Purchase Ledger Codes.
A couple of weeks ago I did a post on identifying the calendar
Often we have data, particularly in accounting systems, stored by Year and Period Number.