Excel Worksheet Functions - Page 545

Thread / Thread Starter	Last Post	Replies	Views
Using the MAX function with "constant increment" cell references John Dwyer	by Max	3	1,603
Standard Deviation including blank cells John D[_2_]	by ExcelBanter AI	8	9,593
Need dynamic name range in Excel for Outlook interface John E.	by Biff	3	545
filtering based on a value in a cell John E. Fox	by Debra Dalgleish	1	449
Combining SUMPRODUCT with IF - help! John Elford	by John Elford	1	1,549
Is there an AVERAGEIF function similar to COUNTIF - how do I do i. John Emhof	by John Emhof	3	626
Formula to extract pricing from a chart John F	by John F	2	748
Excel 2007, pivot table format issue John F	by John F	0	333
excel 97 stopped working john f	by Gord Dibben	1	703
CountIf Function - require range of criterea John F	by Biff	10	1,551
how can i merge 2 workbooks using a formula? John F	by John Fazio	6	1,052
IF Function Help due to 7 limit John F	by John F	11	1,259
If Function: Blank cell and 0 (zero) seem to have same "value" John F	by CarlosAntenna	1	621
Graphing Normal Distribution Functions John F.	by John F.	2	514
Access Rights & Reports John F.M.	by CLR	1	411
I can't insert a worksheet into my current spreadsheet file John Falkenstine	by Gord Dibben	3	1,915
how would you do A40-20 = aA20, the value 20 is in another cell John ferguson	by Niek Otten	1	381
Inverse sin John Fitzpatrick	by Myrna Larson	3	1,212
use of define name functions john folmar	by Ashish Mathur[_2_]	4	750
Opening Excel out of explorer or outlook attachment John Fuller	by John Fuller	0	573
Excel: How do you format numbers in a concatenate string? John G	by Glenn	8	1,343
Formula result not displayin in cell John G - HTW	by John G - HTW[_2_]	4	398
Finding Value Conditional John Galt	by Ron Rosenfeld	7	313
accounts payable aging report John Grinder	by Max	4	4,381
Need simple little macro - edit add 3 spaces John Grossman	by Bernie Deitrick	4	434
Find a word and then take certain action, else John Grossman	by Biff	1	495
Can't find logical_test for "if"statement John Grossman	by Peo Sjoblom	1	411
Splitting dd/mm/yyyy hh:mm John H	by John H	2	855
Date - greater than and less than John H.	by Bob Phillips	1	386
Is there a way to use a field link to rename a worksheet ? John H.	by Gord Dibben	6	567
view excel worksheet & freeze internet window synchronously John H. Herrlinger	by John H. Herrlinger	0	368
How do I stop cell borders dissappearing when pasting data? John Hallworth	by AlwaysFroosh!	2	922
Conditional Formatting in Excel 2007 JOHN HARRIS	by BoniM	1	855
Finding Time difference John Harris	by Dave Peterson	2	666
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 John Higgins	by Gord Dibben	2	1,160
Creating a formula for Hydraulics John Holman	by Sheeloo[_3_]	3	540
Create a macro that finds values then sorts John Hughes	by John Hughes	2	487
Archive John Hunt	by Hammer	4	652
I need help writing a formula. John III	by Gord Dibben	4	668
Comparing lists John in MN	by Bernie Deitrick	1	583
Return number OR sum based on two criteria John in MN	by John in MN	2	508
How do I write an 'if exist" statement John in Surrey	by Bob Phillips	1	631
populate data valadation list by criteria John in Surrey	by Roger Govier	1	556
populating a list box with weekly dates John in Surrey	by Biff	1	677
Mortage Calculations John in Surrey	by John in Surrey	2	361
Populate List Box John in Surrey	by John in Surrey	0	467
using =COUNTIF to count two text values John in Surrey	by Trevor Shuttleworth	1	747
Fill Cell to the right John in Surrey	by John in Surrey	3	311
Keep integrity of pasted links when data is later sorted John in Venice	by Dylan @ UAFC[_2_]	1	549
[Q] Auto filter possible on multi-value cell? John IV	by Nick Hodge	1	766
How to best monitor threads on this site John James	by Dave Peterson	13	1,065
Cannot hide columns in Excel John Johns	by CLR	1	972
Formula Syntax John Johns	by bpeltzer	1	495
Data Validation Function Help John Jost	by John Jost	3	791
Pivot Table - Custom Row Field John Jost	by Debra Dalgleish	1	1,455
Data Validation (Multiple Choice) John Jost	by John Jost	4	1,626
Setup Entire Workbook to print all tabs Duplex John Jr.	by Gary L Brown	1	1,146
Defining cells that macro will change John K	by John K	2	809
counting unique names - again John K	by ryguy7272	3	458
cusip (number and text) in same cell- How do use in excel? John K	by Biff	4	2,060
How can I get the password to unlock an add-in function John K	by John K	0	389
adding ref # John K	by John K	2	399
Summing vlookup cells John K	by Richard	3	596
Adding multiple vlookups John K	by Kevin Vaughn	3	942
summing numbers based on 2nd column John K	by John K	3	523
Changing relative to absolute for a column John K	by davesexcel	6	858
Formatting for and adding thousandths of a second John Kaurloto	by John Kaurloto	5	4,137
QUERY & HELP: so slow executing VBA code... :S John Keith	by John Keith	3	876
how do i turn on view side by side john kennett	by Rick Rothstein \(MVP - VB\)	1	1,411
Count based on color John Kirschner	by Ola	2	543
add color to a cell John Klos	by Pete_UK	1	319
formatting colors John Knoke	by John O. Knoke	3	627
coditional formatting John Knoke	by John Knoke	5	489
Formating Hours John Knoke	by JE McGimpsey	3	416
How can I pull Cell value from Detail worksheet into Summary sheet? John Kotuby[_2_]	by John Kotuby[_2_]	2	972