| Similar Articles |
|---|
 |
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
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
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
August 17, 2004 |
Use a Formula as a Named Range in Excel Regarding the article "The Ultimate Sum Formula in Excel"... |
PC Magazine
November 25, 2003 |
Joining Columns that Include Dates Our Excel merge tip works with any two columns of data, but the formula changes a bit when you're working with dates. |
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 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. |
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
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
PC Magazine
June 22, 2004
Neil J. Rubenking |
Get the Last Nonblank Cell in An Excel Range Creating an array formula for this task. |
Macworld
March 2001
James Bradbury |
Track Your Progress with Excel Formulas and Graphs Are at Your Fingertips... |
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
May 18, 2005
Neil J. Rubenking |
Convert Blank Cells to Zeros in Excel In Excel, is there any way to select a range of cells and tell Excel to fill the blank cells with the value zero? |
PC Magazine
October 28, 2003
Neil J. Rubenking |
Averages Without Extremes In Excel "I have a column in Excel that contains account balances. I would like to find the average balance after throwing out the one or two highest and one or two lowest values." A solution. |
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 31, 2005
Helen Bradley |
Performing Lookups In Excel If you need to pull information out of spreadsheets in Excel, use the VLOOKUP function. |
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 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. |
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? |
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
September 4, 2007
Neil Rubenking |
How to Sort by Birthday in Excel How to sort through dates while avoiding leap years. |
PC Magazine
April 6, 2004
Neil J. Rubenking |
Fix Excel 2003's RAND Function In December, PC Magazine reader and Excel maven Earl Takasaki brought a curious Excel bug to our attention: The RAND function in Excel 2003 may return negative numbers. |
PC Magazine
September 21, 2004 |
A Subtle Bug in Excel Pivot Tables A reader discovers an unusual Excel 2003 flaw, and we have a demonstration. |
CFO
April 15, 2012
Bill Jelen |
A Global Shift (of Decimals) How to move the decimal point in an array of Excel data. |
PC Magazine
January 10, 2007 |
Copy Only Subtotals in Excel A way to copy just the results of a subtotal display to other cells in an Excel spreadsheet. |
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
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
PC Magazine
August 30, 2006 |
Problem Merging Zip Codes That Start with 0 Making Microsoft Office 2003 Small Business allow zip codes that begin with 0. |
PC Magazine
September 27, 2006 |
Force Unique Numbers in Excel Keep duplicate numbers from being inserted into a column in Microsoft Excel. |
PC Magazine
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
April 20, 2004
Neil J. Rubenking |
Another Way to Separate Address Elements Here's another approach to breaking addresses apart, but one that requires no formulas for use with Excel. |
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
August 3, 2004 |
Counting Unique Names in Excel, Reloaded How to count unique names in excel using pivot tables. |
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
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
July 12, 2006 |
Conditional Formatting for Plotted Points in Excel Faking conditional formatting for your plots. |
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
March 6, 2007 |
Analyze Multiple Worksheets in Excel Combine long lists of items from about a dozen different workbooks into one Excel worksheet, without duplicating entries. |
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
December 9, 2003
Brickley & Cutting |
Automate Long Fills In Excel It's easy to create a macro that takes the hassle out of filling large ranges in Excel. |
PC Magazine
July 2, 2008
Neil J. Rubenking |
Eight Handy Tools in Excel You Probably Don't Know About These simple features in Excel will smarten up your spreadsheets in no time. |
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
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
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
April 26, 2005
Neil J. Rubenking |
Another Way to Get Last Nonblank Cell Tips for getting the most out of Microsoft Excel. |
PC Magazine
November 29, 2006 |
Using Excel's List Feature Setting up data in Microsoft Excel that changes daily. |
The Motley Fool
June 16, 2010
Nathan Alderman |
Beat Back the Budget Beast! This handy spreadsheet can help you keep your money in line. |
PC Magazine
September 14, 2005
Neil J. Rubenking |
Excel's Calendar Control Object How to add Calendar Control 11.0 to your spreadsheet. |
PC Magazine
November 30, 2005
Edward Mendelson |
Office Problems, Solved! Some of the most notorious problems and the most useful tricks with Microsoft office. |
PC World
May 3, 2001 |
Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas... |
