Search a Spreadsheet Full of Data using Conditional Formatting
Many of us use spreadsheets to manage huge lists of data, like customer data bases, salesperson data bases etc. Today we will learn a little conditional formatting trick that you can use to search a worksheet full of data and highlight the matching cells.
Interview with John Walkenbach on Excel and Banjo Charts…
Our interview with John Walkenbach is here. Check it out and see what John has to say about Excel, spreadsheets and fun.
Using Array Formulas in Excel – Find if a list has duplicate items
In this installment of our spreadcheats series, we will learn how to use array formulas and findout if a list has any duplicate items. We will use Countif and array formulas to do this …
Excel Links of The Week – Malmo Edition
In this week’s excel links learn how to make bingo cards, make your random numbers unique and prepare your data for charting and much more…
Skip Blank doesnt skip blank cells ?!?
In our excel paste tricks post, I have mentioned a paste special feature called “skip blanks” that can apparently be used to skip blank cells when pasting data. I am writing about this again because, I have received an email from Bruce saying, This is erroneous. In actuality, the result that is pasted is the […]
Visualization Challenge – Budget vs. Actual Performance
Here is your chance to win a copy of The Visual Display of Quantitative Information by Edward Tufte, all you need to do is visualize budget vs. actual performance of the given data. Go!
Highlight Top 10 Values using Excel Conditional Formatting
In excel conditional formatting basics article, we have learned the basics of excel conditional formatting. In this article we will learn how to highlight top 5 or 10 values in a list using excel as shown aside. We will use LARGE excel formula and conditional formatting to do this.