Arrays (7)- "I've never come across consultants with the level of knowledge and proficiency that Access Analytic staff have. The things they can make... Stephen Smith more »
- The complex spreadsheet models we developed were used by the bank to test new areas of functionality in the banks' lending applications.... Susan D Evans more »
- Testing and documentation of key business spreadsheets using Spreadsheet Professional "The services Access... Darren Gordon more »
Knowledge
Client Success Stories
Famous Quotes
- "Life is either a daring adventure or nothing." Helen Keller
- "When you know what you want, and you want it badly enough, you'll find a way to get it." Jim Rohn
- "Get over it, get on with it, don't give up." Jeff Robson
Subscribe Newsletter
Knowledge
Featured White Papers |
|
Financial Modelling Best Practice Guidelines
Provides best practice guidelines that should be considered when building spreadsheets so as to minimise the risk of errors occurring, and improve reliability. usability, robustness and accuracy. Is This The Right Version? Version Control, like an insurance policy, is an expense (of time and effort) that hopefully is never required. But what's the best way to control all the versions that sometimes multiply out of control? | |
Featured Research Articles
Finding NumbersFinding numbers with a comma format Excel has a bug in its Find routine that you may have experienced. If you have formatted formula using the comma (,) number format which displays 1000 as 1,000 then you might struggle to find numbers of 1000 and above ... Calculate part of a formulaKeyboard shortcut Sometimes when creating a spreadsheet you need to see where errors are coming from. In longer formula this can be difficult ... Using Dates in Dynamic Headings& symbol and the TEXT function Excel stores dates as numbers and when you try to use a date in a heading with the & symbol Excel will display the number, not the date ... Multi-line VLOOKUPI have a data base that has five separate rows for each item. I can use VLOOKUP to find the first row's details, but how do I access the details in the other four lines? This is an ideal situation to use the INDEX / MATCH function combination. These two functions work well together and allow you to do flexible lookups ... Array formula to SUM rounded valuesI format many of my reports to zero decimal places. This means that in some cases the SUM function will show a different total than the displayed numbers indicated. If I format two numbers 5.5 and 7.5 with zero decimal places, they will display as 6 and 8 respectively. When summed that result is 13. Can I get the SUM function to SUM the displayed values, in this case 14? The solution is your problem is an array formula. Many of the limitations of Excel's functions can be overcome by using an array formula ... |
Share This:
