Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
Here is a quick excel formula tip to start your week. Use ROWS() and COLUMNS() formulas next time you need sequential numbers. What does ROWS() excel formula do? ROWS excel formula takes a range as an argument and tells you how many rows are there in that range. For. eg. ROWS(A1:A10) gives 10. How can you […]
Only 2 more days to get prizes worth $425, Hurry
The PHD 5k Giveaway which includes exciting prizes like Excel dashboard bundle, Power Utility Pack Licenses, Amazon gift card and Excel 2007 Formulas book is going to end by tomorrow midnight (that is 15th August people). To participate, all you got to do is, either send a tweet with your favorite formula tip or complete […]
Hide Grid Lines [Quick Tip]
I like to hide grid lines on my spreadsheets and charts whenever possible. I think removing gridlines makes the charts and worksheets more presentable. In case you are wondering how to remove (or hide) gridlines from your worksheet or chart, follow these simple instructions.
Member of month, Excel links and Cooked HDD
Starting this month I will announce one member of our little community as member of month. It is to honor the contribution they made.
Jeff Weir is our member of month for July, 2009. He not only commented more than 40 times in the last month, but he even wrote a marvelous guest post on the chart busters series. I have learned several valuable excel and charting tips from him in the past few weeks. I am sure some of have too. Thank you Jeff.
Also in the post we have some excel links worth checking.
Waterfall Charts using Excel
Learn how to create waterfall charts in Excel in this tutorial. Our guest author, Aaron, explains how to create cool looking waterfall charts with connectors. Waterfall charts are great, especially for visually showing the contribution of parts to a whole.
What would you do if a co-worker makes ugly chart? [weekend poll]
We talk alot about making better charts and perils of bad charts here.
I want to know what you usually do when a co-worker or boss makes an ugly chart?
- You tell them the chart sucks
- You gently point out the mistakes of their chart and tell them some nicer and cooler ways to tackle it
- You stay calm and send them an e-mail later (may be with a link to PHD chart pages or something like that)
- You don’t care (and may be continue doodling)
- Any other
Vote your option using comments.
Count the number of unique values in a range [Quick Tip]
Here is an excel formula quick tip that can come handy when you need to count the number of unique values in a range of cells. Assuming we have a list of values in the range:B5:B15 and we want to know how many unique values are there,
you can use the almighty SUMPRODUCT formula like this: SUMPRODUCT(1/COUNTIF(B5:B15,B5:B15)).
Read the rest of this post to understand how the formula works. You can also find resources to work with duplicate values in excel.