| Similar Articles |
|---|
 |
PC Magazine
September 7, 2004
Neil J. Rubenking |
Asterisk Foils VLOOKUP Here's why Excel's first-column search function trips over a little star and what to do.   |
PC Magazine
November 11, 2003
Neil J. Rubenking |
Fixing an Excel Formula I have created several Excel 2000 worksheets that use the VLOOKUP formula to get information from one central worksheet. Now I need to add columns to the root worksheet. |
PC Magazine
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
PC Magazine
October 14, 2003
Neil J. Rubenking |
Absolute and Relative References in Excel Avoid error messages in your formulas by using the $ character to indicate cell references that should never change. |
PC Magazine
September 4, 2007
Helen Bradley |
Making Choices in Excel Vlookups can easily return data from even very large tables. |
PC Magazine
July 1, 2003
Neil J. Rubenking |
Filtering with Excel's PivotTable Is there a way to count the number of occurrences of each name in an Excel column? |
PC Magazine
February 14, 2007 |
Numbers With Superscripts in Excel You can format each digit of a number with a different color within an Excel cell, but for the purpose of calculations, the formatting doesn't make any difference. |
PC Magazine
May 16, 2007 |
How Excel Formulas Can Reference Comments How to carry non-cell data from one Excel worksheet to another. |
PC Magazine
September 16, 2003
Helen Bradley |
15 Great Excel Tips Microsoft Excel is jam-packed with functions that perform a range of handy calculations and tests. We take a look at 15 Excel functions you may not know about and show you some clever ways to put them to work on your data. |
PC Magazine
May 31, 2006 |
Pick Lottery Numbers With Excel Using the LARGE() function in Excel. |
