As you use Microsoft Excel more and more, you'll find that the VLOOKUP function is a very popular tool for dealing with large Excel directories or databases. It allows the user to quickly find ...

How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...

Comparing two columns in Excel doesn’t have to be a difficult task, and to get the job done, we suggest using VLOOKUP. You see, not always; the columns you want to compare are in the same workbook or ...

How to calculate a conditional running total using a PivotTable in Excel Your email has been sent An expression to return a simple running total in Excel is easy — a few references and you’re done. A ...

I enjoyed the article “Double-Teaming in Excel” ( JofA , Nov.05, page 83 ). VLOOKUP is so versatile; I have used it to reconcile outstanding checks each month. I download the checks that were paid for ...

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...