| Similar Articles |
|---|
 |
PC Magazine
April 26, 2005
Neil J. Rubenking |
Another Way to Get Last Nonblank Cell Tips for getting the most out of Microsoft Excel.   |
PC Magazine
May 4, 2004
Neil J. Rubenking |
Sorting Text in Excel Reordering words is more complicated than numbers. Here's a procedure that works. |
PC Magazine
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
PC Magazine
January 20, 2004
Neil J. Rubenking |
Better Averages Without Extremes A better way to calculate the average of a range of cells in a spreadsheet while omitting one or more of the highest or lowest values. |
PC Magazine
December 30, 2003
Neil J. Rubenking |
The Ultimate Sum Formula in Excel Here's how to set up a formula that will automatically adapt and sum all the cells above it, wherever it is placed. |
PC Magazine
March 16, 2004
Neil J. Rubenking |
Count Unique Names in Excel I have a list of some 900,000 names in an Excel worksheet. Most of the names have duplicates. How can I count the number of names without counting duplicate entries? |
PC Magazine
October 1, 2003 |
Excel's Array Formulas Array formulas are a powerful addition to your Excel toolbox. We show you how to start using them. |
PC Magazine
December 14, 2004
Neil J. Rubenking |
Advanced Ranking in Excel Q: I have columns of students, band instruments, and tryout scores... A: This seemingly knotty problem can be solved with a single formula... |
PC Magazine
August 17, 2004 |
Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"... |
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
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
December 30, 2003
Neil J. Rubenking |
Finding the First Thursday Excel's WEEKDAY and MOD functions help you determine which days fall on which dates each month. |
PC Magazine
March 16, 2005
Helen Bradley |
Conditional Formatting in Excel Make the information in your spreadsheets more accessible with formatting based on certain conditions. |
PC Magazine
September 2, 2003
Neil J. Rubenking |
Sort Thousands of Rows Individually You can run a sort operation on each row of an Excel worksheet using a handy function. |
CFO
September 1, 2012
Bill Jelen |
An Average Solution How to create a prediction of sales in Excel using a moving average and a trend line. |
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 World
October 11, 2002
John Walkenbach |
Who Knew Excel Could Do That? Ten Top Tips Make your spreadsheets work harder and give them a polished look with these nifty tricks. |
PC Magazine
December 1, 2009
Neil J. Rubenking |
Conditional Formatting in Excel Excel's conditional formatting can make spreadsheets a lot easier to interpret - -changing the text color in a cell. |
PC Magazine
May 4, 2005
Neil J. Rubenking |
Control Rounding in Excel I have an Excel spreadsheet for my small business that I use to figure employee payroll. What formula can I use so that Excel will always round across the columns so they add correctly? |
PC Magazine
April 20, 2005
Neil J. Rubenking |
Insert Alternate Blank Rows in Excel I have an Excel report that fills about 1,000 rows. I want to insert a blank row between each of these rows. Obviously, I know how to insert a row one at a time, but is there a quicker way to do this? |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
PC Magazine
September 4, 2007
Neil Rubenking |
How to Sort by Birthday in Excel How to sort through dates while avoiding leap years. |
PC Magazine
August 12, 2008
Neil J. Rubenking |
Checksum for a Spreadsheet Create a cell in Excel that does the equivalent of a "hash" or sum of the entire active workbook. |
PC Magazine
June 1, 2008
Neil J. Rubenking |
Easy Date and Time Entry in Excel Cut down data entry time in a flash with handy Excel tricks. |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
PC Magazine
February 16, 2005
Neil J. Rubenking |
Problem with Excel Time Comparison How to build a formula in Microsoft Excel that produces a different answer based on time. |
PC Magazine
September 21, 2004 |
Shuffle Numbers in Excel This is an easy way to generate a non-repeating list of random numbers. |
PC Magazine
September 4, 2007
Neil Rubenking |
Sort on More Than Three Columns The how and why to sort data with more than three columns in Excel. |
PC Magazine
May 17, 2006 |
High to Low Page Numbers in Word Putting formulas in footers of Microsoft Word documents to manage page numbers. |
The Motley Fool
January 21, 2011
Jim Royal |
Consumer Goods' Magic Formula This mechanical strategy could be magic. |
