fbpx
Search
Close this search box.

All articles with 'and()' Tag

Search a Spreadsheet Full of Data using Conditional Formatting

Published on Mar 31, 2009 in Learn Excel
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.

Continue »

What are the formulas you wish Excel had ?

Published on Jan 13, 2009 in Featured, Learn Excel

Here is a list of formulas I wish MS Excel had. Alas, we need to build some work-arounds to solve them though.

Continue »