Charts

I read bunches of excel tips and hints from other websites and every now and again I post links and details of the best ones. Here's a few good ones I have picked up recently.

Counting number of unique entries in a specified range From ExcelTip
Counting number of unique entries in a specified range is simple by using the SUMPRODUCT and COUNT functions.
The range can be all in one column or row, or may span multiple (adjoining) columns/rows.
The formula would be written as: =SUMPRODUCT((1/COUNTIF(A1:C5,A1:C5&""))) where A1:C5 is replaced with the range you want to apply the count to.

Bookmark/Search this post with:

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

David Gainer writes an Excel blog for Microsoft. He often has guest posts written by insiders from Microsoft exposing cool excel secrets.

Two in particular I have noticed recently are these.

Scott Ruble, a lead program manager on the Excel team who focuses on the area of data visualization discusses how to create an intraday time series chart.

Periodically, users need to create a chart where the data occurs within a single day such as by the minute or hour. This is actually fairly easy to do but unfortunately isn’t very obvious. A typical scenario is you own a restaurant that takes phone orders and you want to reduce the wait time for customers placing an order. This is influenced by a number of factors but a big one is the number of people calling at the same time. As such, you would want to staff your phone lines with more people during the busy times. The key here is to determine when the busy times are and by how much.

Bookmark/Search this post with:

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
•