Question: I’m using conditional formatting to find duplicate values in a column, and it’s working in that it highlights both values if they’re duplicated. How do I ignore the first instance and highlight only the second? Answer: By using
Question: I’ve used a VLOOKUP formula, but it’s not working and is returning an error. How do I fix it? Answer: By checking the type of error that’s been returned. Process (Excel 2003, 2007, 2010): The two most
In a recent BBC debate intended to gather opinion from leading technologist’s about the future of technology there appeared to be a number of common themes. Primarily the internet will be an easily accessible and relatively low cost network of
ALCHEMEX is the leading developer, enabler and support-provider of affordable Excel-based Business Intelligence (BI) software for small to medium enterprises. Alchemex reporting software provides an integrated, automated, and Excel-based BI solution, presenting preformatted drillable Excel reports, executable at the click
Question: I’ve selected all blank cells in a column, I would now like to enter a formula in all of the cells at the same time. Is this possible? Answer: Yes, with a keyboard shortcut. Process (Excel 2003,
Why is BI currently so topical for business owners and executives in mid-size organisations? Can Excel be considered a part of the picture in defining the perfect BI solution? The BI industry is heavily laden with technical concepts such as Meta Data,
Typically the barriers to adoption of BI are cost and complexity. Small businesses face tighter budgets, less sophistication and fewer people. An integrated BI solution makes deployment rapid without any IT hurdles, allowing for an immediate return on investment. Because
All companies face constant pressure to increase profitability, improve cash flow, reduce costs, and reduce risk in order to improve financial performance. The ability to make good decisions and proactively solve issues is crucial to success at every level of
My users are not always sure what they are selecting when asked for a Parameter. Can I supply a description to the Parameter as guideline? Yes, you can add a short description to the Parameter field. When the field gets
I’ve added several Expressions to my container and could Lookup the values in the Report Manager. When I added a Pass through Variable though, I can no longer Lookup the values? Can I add a Lookup to a Pass Through