Excel Worksheet Functions - Page 998

Thread / Thread Starter	Last Post	Replies	Views
"Formula is too long" gobonniego	by Dave Peterson	1	641
sumproduct for latest date Sue	by Biff	9	801
Function to look up largest value whose record meets criteria? Alison	by Alison	5	1,021
Counting Help JerryS	by Duke Carey	2	461
calculating dates Kira	by William Horton	1	495
How can I calculate the week number from a date, eg 21/06/05 = 26 cel504	by cel504	2	608
Copy page format into an entire workbook mdeanda	by lschuh	2	1,018
Macro Question carl	by Bob Phillips	1	408
my code too long? Zach	by Zach	2	555
Convert rows into 1 cell or 1 string Yagnesh	by Yagnesh	5	597
how do I display $1,243,597 as $1,244 and $(324,567) as $(325)? clnickson	by Bernie Deitrick	6	403
breaking up a phone number maximus73	by Lomax	2	600
Scrolling within a section of an excel worksheet jesstravmad	by clnickson	1	916
sumproduct from multiple sheets Matt	by RagDyer	3	905
retrieve cell formatting with IF(HLOOKUP) formula useR	by useR	2	1,235
Looking up values in a table LesLdh	by jwh	17	1,126
International number separator bibi	by bibi	0	658
VBA, Excel - Find Range, Sort Danny	by Danny	3	1,473
add a formula to Excel arbert	by Gary's Student	1	447
a function giving the interest rate for inv x for period y & bal z cal777	by Bernie Deitrick	1	516
Filter not working in a protected file jijy	by Ron de Bruin	1	697
Due Dates Reminders newstrom	by newstrom	0	574
Impossibility? jsc3489	by jsc3489	7	435
How do I get rid of the #/DIV/0! message Marshall Scmidt	by Harlan Grove	3	527
I am trying to use the "Camera" function within Excel JIMk	by JIMk	0	638
Counting Letters Blink	by Bob Phillips	2	520
EXCEL UNPROTECT SHEET WILL NOT DISPLAY....HELP! JAN	by JAN	0	991
New WorkBook ACase	by Ron de Bruin	1	441
Count returns for a period - year Saintsman	by Roger Govier	1	540
counting and matching jsc3489	by jsc3489	2	376
Adjusting Vlookup Values addie	by Roger Govier	1	398
advanced if????? taran	by taran	5	525
get a count of numbers whose value falls within a given range LyleB_Austin	by bj	5	1,219
How do I change the "comment" default location ? RRR	by Debra Dalgleish	1	740
Counting what's left in a list WBTKbeezy	by WBTKbeezy	2	401
Automatic update of list in Excel Swampy	by Swampy	0	682
Which function to use? taxmom	by Roger Govier	6	391
Analysis sirgresley	by bj	1	377
How do I calculate a future date in Excel? macheath48	by Bernie Deitrick	2	992
nested Indirect to other WS LyleF	by LyleF	4	637
can you select rows in excel with a certain background color? stelee	by Ron de Bruin	1	1,150
Averaging Values in Auto Filter Mr. Jan Park	by Domenic	1	1,138
Automatically update links when server names change J Hotch	by tony h	1	973
help me write function? Zach	by Zach	5	475
Excel should let me track my paychecks and salary history. kscherry2000	by kscherry2000	0	796
VLookup Help xcelion	by xcelion	0	410
DATA FILTER ARROWS DISPLAY WHILE INACTIVE lassie	by lassie	0	585
View gridlines despite changing cell color JLI	by JLI	0	468
Rolling Calendar MrBen via OfficeKB.com	by MrBen via OfficeKB.com	0	923
How do I change the plus to a negative in a column of numbers? JKB	by Arvi Laanemets	2	1,731
Sumif function? claudlarue	by claudlarue	2	728
text argument in vlook up which has a "" carlosgdlf	by Ron Coderre	6	513
In excel: when in print preview, 1 button to 'maximise margins' Sa Gested	by Sa Gested	0	717
Accidentally converted date mm/dd/yy to a 5 digit number Eve	by Lady Layla	6	922
formula to count cells not blanK pmarques	by Bryan Hessey	4	1,174
How to : Comparing Two Ranges lockwood7	by lockwood7	3	486
Formula stays displayed in cell AMY Z.	by AMY Z.	4	540
Combining cell information Ann-Charlotte	by Gary's Student	1	409
Empty Excel File -- Data Lost? Danny Cazier	by Dave Peterson	1	932
info in cel needs to propt other cels to automatically enter text Bill W	by Bill W	2	606
How to add numbers in a column dependant on their colour 24 Jan 05	by bj	2	784
Cumulative Time Usage in a Worksheet Charles1732	by Bob Phillips	1	469
Is there an easy way to count when adjacent cells contain same data? mrarcade	by Bob Phillips	1	987
Formula to display Sheet name JaneC	by Krishnakumar	5	428
Dates/ Ages Brian	by Bob Phillips	7	633
create multiple worksheet Ramkaji, Nepal	by Bob Phillips	2	397
Formula to add up units Steved	by Steved	3	432
how to import Ms word Table to Ms Excel for Various Calculations reneabesmer	by Karthik	1	610
Getting Min Value kk	by kk	3	367
multiplycation of money cell and time cell engr625	by Biff	1	582
Mortgage functions Cynthia A via OfficeKB.com	by Cynthia A via OfficeKB.com	0	385
Count designated cells VB	by Biff	1	754
how can I search a field for a particular word brantty	by Max	8	1,018
MAX/MIN with SUMPRODUCT [email protected]	by Max	7	1,245
how to move worksheet thru keyboad jongmee park	by David McRitchie	1	384