Excel Worksheet Functions - Page 998

Thread / Thread Starter	Last Post	Replies	Views
"Formula is too long" gobonniego	by Dave Peterson	1	678
sumproduct for latest date Sue	by Biff	9	805
Function to look up largest value whose record meets criteria? Alison	by Alison	5	1,030
Counting Help JerryS	by Duke Carey	2	468
calculating dates Kira	by William Horton	1	511
How can I calculate the week number from a date, eg 21/06/05 = 26 cel504	by cel504	2	626
Copy page format into an entire workbook mdeanda	by lschuh	2	1,023
Macro Question carl	by Bob Phillips	1	414
my code too long? Zach	by Zach	2	561
Convert rows into 1 cell or 1 string Yagnesh	by Yagnesh	5	606
how do I display $1,243,597 as $1,244 and $(324,567) as $(325)? clnickson	by Bernie Deitrick	6	408
breaking up a phone number maximus73	by Lomax	2	606
Scrolling within a section of an excel worksheet jesstravmad	by clnickson	1	921
sumproduct from multiple sheets Matt	by RagDyer	3	914
retrieve cell formatting with IF(HLOOKUP) formula useR	by useR	2	1,245
Looking up values in a table LesLdh	by jwh	17	1,130
International number separator bibi	by bibi	0	664
VBA, Excel - Find Range, Sort Danny	by Danny	3	1,483
add a formula to Excel arbert	by Gary's Student	1	451
a function giving the interest rate for inv x for period y & bal z cal777	by Bernie Deitrick	1	525
Filter not working in a protected file jijy	by Ron de Bruin	1	706
Due Dates Reminders newstrom	by newstrom	0	582
Impossibility? jsc3489	by jsc3489	7	445
How do I get rid of the #/DIV/0! message Marshall Scmidt	by Harlan Grove	3	533
I am trying to use the "Camera" function within Excel JIMk	by JIMk	0	644
Counting Letters Blink	by Bob Phillips	2	526
EXCEL UNPROTECT SHEET WILL NOT DISPLAY....HELP! JAN	by JAN	0	995
New WorkBook ACase	by Ron de Bruin	1	445
Count returns for a period - year Saintsman	by Roger Govier	1	552
counting and matching jsc3489	by jsc3489	2	382
Adjusting Vlookup Values addie	by Roger Govier	1	404
advanced if????? taran	by taran	5	529
get a count of numbers whose value falls within a given range LyleB_Austin	by bj	5	1,242
How do I change the "comment" default location ? RRR	by Debra Dalgleish	1	765
Counting what's left in a list WBTKbeezy	by WBTKbeezy	2	406
Automatic update of list in Excel Swampy	by Swampy	0	687
Which function to use? taxmom	by Roger Govier	6	395
Analysis sirgresley	by bj	1	383
How do I calculate a future date in Excel? macheath48	by Bernie Deitrick	2	998
nested Indirect to other WS LyleF	by LyleF	4	661
can you select rows in excel with a certain background color? stelee	by Ron de Bruin	1	1,156
Averaging Values in Auto Filter Mr. Jan Park	by Domenic	1	1,167
Automatically update links when server names change J Hotch	by tony h	1	1,012
help me write function? Zach	by Zach	5	488
Excel should let me track my paychecks and salary history. kscherry2000	by kscherry2000	0	840
VLookup Help xcelion	by xcelion	0	415
DATA FILTER ARROWS DISPLAY WHILE INACTIVE lassie	by lassie	0	597
View gridlines despite changing cell color JLI	by JLI	0	475
Rolling Calendar MrBen via OfficeKB.com	by MrBen via OfficeKB.com	0	936
How do I change the plus to a negative in a column of numbers? JKB	by Arvi Laanemets	2	1,738
Sumif function? claudlarue	by claudlarue	2	731
text argument in vlook up which has a "" carlosgdlf	by Ron Coderre	6	536
In excel: when in print preview, 1 button to 'maximise margins' Sa Gested	by Sa Gested	0	728
Accidentally converted date mm/dd/yy to a 5 digit number Eve	by Lady Layla	6	928
formula to count cells not blanK pmarques	by Bryan Hessey	4	1,181
How to : Comparing Two Ranges lockwood7	by lockwood7	3	496
Formula stays displayed in cell AMY Z.	by AMY Z.	4	544
Combining cell information Ann-Charlotte	by Gary's Student	1	414
Empty Excel File -- Data Lost? Danny Cazier	by Dave Peterson	1	952
info in cel needs to propt other cels to automatically enter text Bill W	by Bill W	2	612
How to add numbers in a column dependant on their colour 24 Jan 05	by bj	2	790
Cumulative Time Usage in a Worksheet Charles1732	by Bob Phillips	1	473
Is there an easy way to count when adjacent cells contain same data? mrarcade	by Bob Phillips	1	995
Formula to display Sheet name JaneC	by Krishnakumar	5	433
Dates/ Ages Brian	by Bob Phillips	7	639
create multiple worksheet Ramkaji, Nepal	by Bob Phillips	2	403
Formula to add up units Steved	by Steved	3	435
how to import Ms word Table to Ms Excel for Various Calculations reneabesmer	by Karthik	1	628
Getting Min Value kk	by kk	3	372
multiplycation of money cell and time cell engr625	by Biff	1	584
Mortgage functions Cynthia A via OfficeKB.com	by Cynthia A via OfficeKB.com	0	389
Count designated cells VB	by Biff	1	764
how can I search a field for a particular word brantty	by Max	8	1,023
MAX/MIN with SUMPRODUCT [email protected]	by Max	7	1,266
how to move worksheet thru keyboad jongmee park	by David McRitchie	1	386