Excel Worksheet Functions - Page 85

Thread / Thread Starter	Last Post	Replies	Views
create a ASCII semi-colon or comma delimited file Beverly Blake	by JLatham	2	1,835
how do i paste after filtering in excel? richie	by Dave Peterson	5	1,835
Formulas displayed in cell rather than calculated values? Don M.	by Don M.	5	1,835
How do I get the MSNStockQuote function in Excel? arrvin	by Bill Sharpe[_2_]	1	1,834
Desperately trying to build a paid time off accrual worksheet... cgautreau	by rh33a	9	1,834
AUTOMATIC SPELL CHECK RENEE	by Missy	5	1,834
Ambiguous name detected: worksheet_change FlesburgT	by [email protected]	2	1,834
Shortcut Key for Text Changing Color in MS- Excel Hema	by Ron de Bruin	5	1,834
Average with criteria for adjacent cells ? John Yaris	by GS[_2_]	1	1,834
how do I use vlookup for multiple occurrences of the same value bj	by bj	0	1,834
keep the title fixed while scrolling SteveL	by SteveL	1	1,834
How to convert date to financial year format 2006-07 Yog Raj	by David Biddulph[_2_]	4	1,833
Help tonight?!! select rows based on cell value in a column Lighthouse1	by Teethless mama	1	1,833
Create Generic Formula for Entire Column Andrea from MN	by Jacob Skaria	1	1,833
Maximum Number of Blank Cells between Non Blank Cells in a Range Mal	by Bernd P	5	1,833
Freeze Panes sjm cpa	by Gord Dibben	8	1,833
Data Validation List - Can I have multiple ranges displayed? Jim	by Jim	4	1,832
How do I compare two cells and display the lesser of the two cell. cshives	by toppers	2	1,832
Why does forumula show in cell instead of formula result? Ashley	by Dave Peterson[_2_]	2	1,832
Converting Hours:Minutes to Decimal Michael[_2_]	by Rick Rothstein \(MVP - VB\)	2	1,831
[XL07] Conditionally format fill color for entire row Trevor Stone	by Derf	11	1,831
Paste is is copying in formula, but display is wrong. Matt	by Matt	2	1,831
barcode macro Joe OE	by Thomas Lutz	1	1,831
LINEST bug with cubic polynomials in Excel 2003 byundt	by Jerry W. Lewis	3	1,831
Clear contents of cells if a condition is met bevchapman	by Gord Dibben	2	1,830
Using Excel to calculate future dates with various intervals MH	by Shane Devenshire[_2_]	6	1,830
Split data from one cell to two separate cells Michele	by Graham Haughs	2	1,830
Nested 'IF', 'LOOKUP', 'AND' or 'INDEX', 'MATCH' JT	by JT	2	1,830
Relative Link remembers absolute path?? booker@mgt[_2_]	by Bill Snow	2	1,830
2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook MichelleS	by Roger Govier	15	1,830
Cell text based on 4 condition test Bob Wall	by Bob Wall	3	1,829
logical test, array, text and numbers Dan M.	by [email protected]	1	1,829
HYPERLINK Worksheet Function David Messenger	by Pete_UK	3	1,829
How to create a Exchange Currency Rate into Excel Blue Fish[_2_]	by Don Guillett	3	1,829
swap values between two cells killdare	by carlo	3	1,828
how do I use COUNTIF stmnt if I want to find cells that are red kisboros	by T. Valko	9	1,828
CTRL+select Excel 2007 ripley	by Roger Govier[_3_]	5	1,828
frequency a number repeats in a column Ken	by T. Valko	5	1,828
WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0) GEORGE ZEIGLER, SAN DIEGO	by GEORGE ZEIGLER, SAN DIEGO[_2_]	7	1,828
locking formulas in Excel 2007 so users can't change but can vieworiginal formula? Verna	by T. Valko	1	1,828
IRR, with cash flows in non-adjacent cells Nick Ng	by JoeU2004	6	1,828
How to clear all checkboxes on a form? Arlen	by Arlen	2	1,828
Hiding rows based on date Steve	by Steve	2	1,828
Replace SUMIF with SUMPRODUCT torooo	by Ragdyer	14	1,827
Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick, tota Kathryn Pundt	by Peo Sjoblom	10	1,827
Subtotals in very large datasets heather	by Shane Devenshire[_2_]	5	1,827
Convert text strings to a code or number MaxNY23	by Kevin Vaughn	15	1,827
Find Replace loses text properties/formatting no1jimmyman	by DeFautT	1	1,827
Exception report in excel jj	by jj	5	1,827
pull data from sheet two, then fill in the data to sheet one (part Jim	by Max	3	1,827
Skip Rows in Fill Series and Filter to Two different sheets Benjamin	by Ashish Mathur[_2_]	3	1,826
Removing Duplicate Names in Single Cell JoannieMaj	by GS[_6_]	10	1,826
How do I find my worksheet tabs? Sherry	by PM	11	1,826
How to make Same formula over multiple rows but still holds row # BallySuperTech	by Don Guillett	1	1,826
Excel vs. calculator multiplication product discrepancy... Jray	by Jray	3	1,826
How do I turn off the solver results dialog box cripwell01	by Dana DeLouis	1	1,826
Gosub - Goto ? El Bee	by Niek Otten	5	1,826
Payment in Advance/Arrears Sandy Schmid	by [email protected]	2	1,826
Any Way To Specify XIRR Values and Dates Without Using Array? W	by joeu2004[_2_]	1	1,825
Vlookup combined with Hlookup Cornelius	by T. Valko	7	1,825
How can a timestamp in an Excel row be automatically updated if a. dt	by Duke Carey	1	1,825
A Lotto Numbers generator Steved	by Sam Wilson	3	1,825
I want to create an A5 size invoice and print 2 copies A4 sheet Libran19	by Libran19	2	1,825
Counting all cells with red font in Excel Zakynthos	by Zakynthos	2	1,825
Setting a cell equal to another worksheet cell fails (sometimes) Richard	by Richard	2	1,825
UNABLE TO RECORD A MACRO I.C.E.	by JLatham	1	1,825
Text in Blue colour, but print in black colour wuwu	by JulieD	1	1,824
Why are my formulas not adding up automatically Brittany	by PCLIVE	1	1,824
finding all cells that match a certain value OTS	by David Hilberg	10	1,824
Formula for Next Sheet and Every Other Cell JEverhart	by misteremanca	11	1,824
=SUMPRODUCT(--(TRIM(A1:A10)<"")), what does the "--" mean? Ray	by T. Valko	2	1,824
Pivot table field list missing Dianeg	by Dianeg	5	1,823
Use dynamic column reference without R1C1 Pontificateur	by T. Valko	3	1,823
Determining the number of specific days between two dates in Excel jon s	by Jon S	9	1,823
Indirect function €“ relative column copy/paste Gary T	by Glenn	1	1,823