Excel Worksheet Functions - Page 1139

Thread / Thread Starter	Last Post	Replies	Views
Comparing Spreadsheets HankHarris	by Frank Kabel	1	847
Populate a field with just workdays Arlen	by [email protected]	3	574
Excel 2003 Recorder Andrew	by Frank Kabel	1	440
How to insert a complex formula in a cell with VBA mircea	by mircea	6	1,465
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,632
Help / Recommendation Pat J Maine	by Pat J Maine	3	556
Find/Replace carriage return & line feed characters in Excel. Mary Cullen	by Peo Sjoblom	1	2,846
Pivot Tables, can I use an external list to select data items? Brian Lofquist	by Brian Lofquist	0	1,178
If and Dates Clarification wal50	by wal50	4	526
Subtracting Negative Numbers Carole O	by Carole O	2	962
replacing just the sheet names within formulas Jeanne Criez	by Frank Kabel	1	784
using OR with IF function? Ron	by Frank Kabel	6	313
Link 2 sheets bruno borgata	by Frank Kabel	1	470
formula for decimal Jen	by Gord Dibben	2	829
IF #N/A RFJ	by JE McGimpsey	4	493
Adding NonBlank Cells Emily8	by [email protected]	3	557
look help jdengel	by jdengel	0	365
Comparing data in two columns and highlighting the data David Kinsley	by Bernie Deitrick	6	1,346
Lock formula?? L/P	by L/P	2	704
sum of a cell if 2 cells meet a condition Markitos	by Markitos	4	723
Leading Zeros in Numeric Values DBavirsha	by DBavirsha	6	1,166
Sum Product Help Needed Edgar Thoemmes	by JE McGimpsey	1	463
Notifications in Excel? cpme	by Don Guillett	4	472
Expired Date Formula Donna in Elkin, NC	by Donna in Elkin, NC	3	1,399
Function within a TEXT FORMULA SteveFil	by SteveFil	2	786
product sum per month per customer Pete Petersen	by Pete Petersen	2	2,047
Tab Arrangement wizard Sridhar Rao	by Frank Kabel	1	508
Conditional sum PO	by Peo Sjoblom	1	387
countif number of occurences per month per year. Pete Petersen	by Pete Petersen	2	1,429
CountIF or SUM Steve Kay	by JE McGimpsey	1	352
file-workbook MATLOCKTRANS	by Bernie Deitrick	1	325
Incorrect SUM Values in Excel Spreadsheets Julie Watson	by Jerry W. Lewis	2	715
data sort by highlighted or coloured cell aplex	by Frank Kabel	2	804
How do you print all worksheets in a file without opening the fil. timmtamm	by Ron de Bruin	1	884
SUMPRODUCT Gerrym	by Gerrym	1	540
sum of date ranges Tanya	by Biff	1	491
Multiple worksheets, multiple workbooks peter marsh	by cds	1	774
Is there a template that calculates inventory totals? rcyphert	by cds	1	1,075
Values w/conditional formatting Fred Timmons	by Bob Phillips	7	1,066
How can I create consecutivlely numbered tickets? wheresleo	by Dave Peterson	1	551
IIF IS NULL Problem scott	by JE McGimpsey	6	883
Calculate date Anthony	by Fred Smith	1	661
How to protect Option button in worksheet Julie	by Julie	2	1,433
HELP WITH FORMULAS HONEYPIE	by Juco	2	373
colum B=average of last 10 values in A gunther	by Lorence	3	389
X IN A CELL TO CALCULATE A FORMULA JUSTIN	by Aladin Akyurek	1	886
help with cell formula Juco	by Juco	3	357
Strikethrough on Excel. How? Jerry Baritone	by Ken Wright	1	1,041
exel Micha	by Peo Sjoblom	2	497
invoice numbering Mel	by Ron de Bruin	2	539
Searching a cell for a certain character. Matt	by Dave R.	3	1,210
Adding drop down menus to a spreadsheet angiejoe	by Debra Dalgleish	1	714
calcuate sales by date and segments Pete Petersen	by Pete Petersen	2	706
lookup, index, match, offset, etc. [email protected]	by [email protected]	2	1,050
Formatting dates in a formula KimberlyC	by Chip Pearson	1	672
calculating service dates Tanya	by Peo Sjoblom	2	1,134
Sm Product a Calendar Month Range? John	by Peo Sjoblom	3	755
Compare Question nick	by Dave R.	1	500
Formula to find information between 2 dates Porous Metals Limited	by George Nicholson	2	824
Using one number to refrence another pugsly8422	by Myrna Larson	4	412
Modifyiing a SumIF Formula to look for "OLA* carl	by Myrna Larson	4	656
how do I round up? Martushka	by Frank Kabel	1	511
Random Numbers Not Equal to Joe Blow	by Gord Dibben	3	912
How can I copy column sums to another spreadsheets as numbers auntpat	by Gord Dibben	3	784
Forms & Emails FrontPage: Forms?	by FrontPage: Forms?	0	361
Combining IF and multiple SUMIF statements, if A>0 & B is between Lee	by Aladin Akyurek	1	1,083
How do I pick a number from a list in Excel? pugsly8422	by pugsly8422	4	1,816
Repost -calculate % change for each phrase. Gwen	by Gwen	0	537
Tools/Compare and Merge Workbooks - Excel 2003 Pro Laura	by Peo Sjoblom	1	1,841
How do I get an excel worksheet to autoclear promisman	by Bernie Deitrick	1	390
If funtion wildcard unodemad	by Peo Sjoblom	2	420
SUMIF between 2 amounts, eg 51>x> -51 sam158963	by Harlan Grove	3	488
cell value as a worksheet reference Stepney_Clint	by Stepney_Clint	2	541
tools options greyed out Glen Brittle	by Glen Brittle	0	853
Two cell accumulator Bill	by Bernie Deitrick	1	429