| Similar Articles |
|---|
 |
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 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
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
June 22, 2004
Neil J. Rubenking |
Get the Last Nonblank Cell in An Excel Range Creating an array formula for this task. |
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
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
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
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
August 1, 2007
Neil Rubenking |
Excel Formulas That Read Your Mind Understanding #REF! error markers in Excel formulas. |
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
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 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
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
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
May 18, 2004
Neil J. Rubenking |
Another Way to Highlight Formulas Expert advice on highlighting cells containing formulas in Excel. |
PC Magazine
April 4, 2007 |
Making Excel Remember More Data Using excel to find linking values of data. |
PC Magazine
February 3, 2004
Neil J. Rubenking |
Highlight Cells Containing Formulas In designing and auditing spreadsheets, I'd like to distinguish visually between cells containing formulas and those containing values. |
PC Magazine
April 6, 2004
Helen Bradley |
Better Lists in Excel Excel 2003 offers some useful new tools for working with lists. |
JavaWorld
May 2, 2003
Jeff Friesen |
Datastructures and algorithms, Part 1 After presenting basic datastructure and algorithm concepts, this article focuses on the array datastructure and associated algorithms. The article concludes with the assertion that Java's arrays are objects. |
PC World
May 3, 2001 |
Top 5 Spreadsheet Add-Ins Avoid the pain and tedium of writing Excel formulas... |
