Excel Worksheet Functions - Page 1139

Thread / Thread Starter	Last Post	Replies	Views
Comparing Spreadsheets HankHarris	by Frank Kabel	1	826
Populate a field with just workdays Arlen	by [email protected]	3	569
Excel 2003 Recorder Andrew	by Frank Kabel	1	427
How to insert a complex formula in a cell with VBA mircea	by mircea	6	1,411
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer	by Peo Sjoblom	1	1,597
Help / Recommendation Pat J Maine	by Pat J Maine	3	550
Find/Replace carriage return & line feed characters in Excel. Mary Cullen	by Peo Sjoblom	1	2,825
Pivot Tables, can I use an external list to select data items? Brian Lofquist	by Brian Lofquist	0	1,157
If and Dates Clarification wal50	by wal50	4	519
Subtracting Negative Numbers Carole O	by Carole O	2	935
replacing just the sheet names within formulas Jeanne Criez	by Frank Kabel	1	768
using OR with IF function? Ron	by Frank Kabel	6	307
Link 2 sheets bruno borgata	by Frank Kabel	1	460
formula for decimal Jen	by Gord Dibben	2	816
IF #N/A RFJ	by JE McGimpsey	4	483
Adding NonBlank Cells Emily8	by [email protected]	3	544
look help jdengel	by jdengel	0	357
Comparing data in two columns and highlighting the data David Kinsley	by Bernie Deitrick	6	1,327
Lock formula?? L/P	by L/P	2	696
sum of a cell if 2 cells meet a condition Markitos	by Markitos	4	710
Leading Zeros in Numeric Values DBavirsha	by DBavirsha	6	1,143
Sum Product Help Needed Edgar Thoemmes	by JE McGimpsey	1	444
Notifications in Excel? cpme	by Don Guillett	4	453
Expired Date Formula Donna in Elkin, NC	by Donna in Elkin, NC	3	1,367
Function within a TEXT FORMULA SteveFil	by SteveFil	2	767
product sum per month per customer Pete Petersen	by Pete Petersen	2	2,033
Tab Arrangement wizard Sridhar Rao	by Frank Kabel	1	496
Conditional sum PO	by Peo Sjoblom	1	376
countif number of occurences per month per year. Pete Petersen	by Pete Petersen	2	1,408
CountIF or SUM Steve Kay	by JE McGimpsey	1	341
file-workbook MATLOCKTRANS	by Bernie Deitrick	1	318
Incorrect SUM Values in Excel Spreadsheets Julie Watson	by Jerry W. Lewis	2	701
data sort by highlighted or coloured cell aplex	by Frank Kabel	2	784
How do you print all worksheets in a file without opening the fil. timmtamm	by Ron de Bruin	1	867
SUMPRODUCT Gerrym	by Gerrym	1	530
sum of date ranges Tanya	by Biff	1	475
Multiple worksheets, multiple workbooks peter marsh	by cds	1	752
Is there a template that calculates inventory totals? rcyphert	by cds	1	1,057
Values w/conditional formatting Fred Timmons	by Bob Phillips	7	1,048
How can I create consecutivlely numbered tickets? wheresleo	by Dave Peterson	1	544
IIF IS NULL Problem scott	by JE McGimpsey	6	847
Calculate date Anthony	by Fred Smith	1	638
How to protect Option button in worksheet Julie	by Julie	2	1,415
HELP WITH FORMULAS HONEYPIE	by Juco	2	365
colum B=average of last 10 values in A gunther	by Lorence	3	380
X IN A CELL TO CALCULATE A FORMULA JUSTIN	by Aladin Akyurek	1	869
help with cell formula Juco	by Juco	3	348
Strikethrough on Excel. How? Jerry Baritone	by Ken Wright	1	1,018
exel Micha	by Peo Sjoblom	2	480
invoice numbering Mel	by Ron de Bruin	2	525
Searching a cell for a certain character. Matt	by Dave R.	3	1,193
Adding drop down menus to a spreadsheet angiejoe	by Debra Dalgleish	1	692
calcuate sales by date and segments Pete Petersen	by Pete Petersen	2	690
lookup, index, match, offset, etc. [email protected]	by [email protected]	2	1,033
Formatting dates in a formula KimberlyC	by Chip Pearson	1	653
calculating service dates Tanya	by Peo Sjoblom	2	1,105
Sm Product a Calendar Month Range? John	by Peo Sjoblom	3	739
Compare Question nick	by Dave R.	1	485
Formula to find information between 2 dates Porous Metals Limited	by George Nicholson	2	807
Using one number to refrence another pugsly8422	by Myrna Larson	4	402
Modifyiing a SumIF Formula to look for "OLA* carl	by Myrna Larson	4	640
how do I round up? Martushka	by Frank Kabel	1	502
Random Numbers Not Equal to Joe Blow	by Gord Dibben	3	905
How can I copy column sums to another spreadsheets as numbers auntpat	by Gord Dibben	3	774
Forms & Emails FrontPage: Forms?	by FrontPage: Forms?	0	356
Combining IF and multiple SUMIF statements, if A>0 & B is between Lee	by Aladin Akyurek	1	1,064
How do I pick a number from a list in Excel? pugsly8422	by pugsly8422	4	1,767
Repost -calculate % change for each phrase. Gwen	by Gwen	0	526
Tools/Compare and Merge Workbooks - Excel 2003 Pro Laura	by Peo Sjoblom	1	1,822
How do I get an excel worksheet to autoclear promisman	by Bernie Deitrick	1	385
If funtion wildcard unodemad	by Peo Sjoblom	2	413
SUMIF between 2 amounts, eg 51>x> -51 sam158963	by Harlan Grove	3	480
cell value as a worksheet reference Stepney_Clint	by Stepney_Clint	2	529
tools options greyed out Glen Brittle	by Glen Brittle	0	834
Two cell accumulator Bill	by Bernie Deitrick	1	423