Excel Worksheet Functions - Page 546

Thread / Thread Starter	Last Post	Replies	Views
Excel Formula add if someone types PTO have it =0 John Krsulic	by RagDyeR	11	1,056
Auto Fill days of the month (not including weekends) John Krsulic[_2_]	by Peo Sjoblom	6	1,868
Huge sum function formula John Krsulic[_2_]	by driller	3	312
Problem using Import External Data John Kyle	by John Kyle	0	351
Function for hours John L	by John L	7	290
MS Works Spreadsheet 2000 v5.0 VLOOKUP John L.	by garfield-n-odie	1	470
Random numbers john liem	by Harlan Grove	11	815
Subtotals multiple columns john liem	by john liem	0	1,014
Subtotals multiple columns john liem	by Gary L Brown	1	584
How to insert logo in Outlook from Excel john liem	by john liem	0	1,096
Compare Side by Side with 3 simulatanous sheets scrolling John Louis	by John Louis	0	635
Formulas not working John Lovin	by David McRitchie	4	709
Look Up Problem Monthly and Yearly Totals John Luc	by Max	6	532
Compare and group like numbers and info John L[_2_]	by John L[_2_]	5	442
Importing Data Wizard John L[_2_]	by John L[_2_]	6	464
Count a Match set of values between cells John M.[_2_]	by PCLIVE	4	573
result should equal a blank field John M.[_3_]	by xlm	2	409
Averaging data and rounding up John Mac	by JLatham	3	381
Averaging data with errors John Mac	by John Mac	4	823
Excel - convert data into text John Mac	by Bernard Liengme	7	676
Rounding averages John Mac	by [email protected]	6	665
Cumulative days roll-over John MacAllister	by John MacAllister[_2_]	7	545
Multicell Array Formula and List Question John Mansfield	by Max	11	1,297
IF to group months John McDonnell	by Ashish Mathur[_2_]	3	408
calculate APR on ARM John McHugh	by Mangesh Yadav	1	930
comparing columns of data john mcmichael	by David Billigmeier	1	450
compare data in the same column on separate worksheets john mcmichael	by Ashish Mathur	1	565
Can I place a formula/cell reference in the Header/footer Excel john mcmichael	by james	2	1,808
can i get excel to add variables john mcmichael	by Anne Troy	5	398
User Group Meeting Ideas John Michl	by John Michl	0	405
Rank without skipping for ties John Michl	by John Michl	0	1,578
Array to find relative position - is there a better way? John Michl	by John Michl	3	839
Sumproduct wildcard or "all" condition John Michl	by Biff	4	633
Array Function John Michl	by John Michl	6	467
YEAR function name not found John Michl	by John Michl	6	496
Combining Digits John Michl	by Bob Phillips	4	418
Find minimum value greater than a particular value John Michl	by Ron Coderre	3	1,731
if amount <0, put the all line in red John Michl	by John Michl	2	359
Determine if Cell Address is within a Range John Michl	by Ron Coderre	4	721
Compare lists for additions and subtractions John Michl	by John Michl	2	560
Conditional Formatting to Compare to Lists John Michl	by John Michl	3	570
Sumif where sum range is more than one column? John Mitchell	by Peo Sjoblom	1	1,144
Function/Formula Question John Morgan	by Rick Rothstein \(MVP - VB\)[_408_]	5	521
random numbers John Murf	by daddylonglegs	1	545
Find value grater than X but less than Y John Murf	by Bob Phillips	1	605
Linking Files John Muscatiello	by Dave Peterson	3	365
I'm trying to include a cell reference as part of an ext. link John M[_2_]	by Dave Peterson	4	543
Finding the LAST value in a column John O'Boyle	by Toppers	6	607
Conditional Formatting John O. Knoke	by Don Guillett	5	500
assigning macros to buttons or autoshapes John of the new year	by Dave Peterson	1	640
Page Setup not functioning John of Winkler	by Peo Sjoblom	1	352
fixing column width John P	by scoobz	1	496
To move automatically right or down at the push of tab or enter? John P. Adams	by Shane Devenshire[_2_]	2	697
excel change default column sort to current selection john palmer	by john palmer	2	1,475
display Calendar for Excel field entry? John Paul	by Ron de Bruin	2	3,342
Linked values turn to #REF! after clicking don't update John Perkins	by John Perkins	2	1,200
Count function John Peterson	by JE McGimpsey	2	335
Count function John Peterson[_2_]	by Steve	2	336
i want to assign a cell to save a worksheet John Petranek	by Shane Devenshire	2	356
Logical AND function John Pinback	by bj	5	636
Conditional Formatting John Pivot Table[_2_]	by FSt1	1	307
Changing Multiple Formulas John Pivot Table[_2_]	by [email protected]	6	816
Pivot table SUMS John Pivot Table[_2_]	by Shane Devenshire[_2_]	1	429
Pivot Tables & Vlookups John Pivot Table[_2_]	by Debra Dalgleish	2	994
Random Numbers John Pivot Table[_2_]	by Bernie Deitrick	2	499
Random Numbers and Me John Pivot Table[_2_]	by Mike H	3	470
Random Numbers and Me John Pivot Table[_2_]	by Lars-Åke Aspelin[_2_]	4	519
Parameters for Random Numbers John Pivot Table[_2_]	by John Pivot Table[_2_]	2	428
Excel - unHiding a column affects columns in other worksheets? John Powell	by JLatham	3	1,016
Bring back the old help format! John Przybylski	by Gord Dibben	2	676
How to average the last 10 numbers in a row? John P[_2_]	by John P[_2_]	7	1,078
Sorting Dates by Month and Day only John P[_2_]	by Mike H	6	1,406
How can I copy a cell from one page to all pages of a workbook? John Q	by Duke Carey	2	956
lock cells John R	by Dave	5	491
if, and, Vlookup functions - mutiple matchng John R	by John R	2	693