Excel Worksheet Functions - Page 998

Thread / Thread Starter	Last Post	Replies	Views
"Formula is too long" gobonniego	by Dave Peterson	1	677
sumproduct for latest date Sue	by Biff	9	805
Function to look up largest value whose record meets criteria? Alison	by Alison	5	1,029
Counting Help JerryS	by Duke Carey	2	465
calculating dates Kira	by William Horton	1	509
How can I calculate the week number from a date, eg 21/06/05 = 26 cel504	by cel504	2	625
Copy page format into an entire workbook mdeanda	by lschuh	2	1,022
Macro Question carl	by Bob Phillips	1	411
my code too long? Zach	by Zach	2	560
Convert rows into 1 cell or 1 string Yagnesh	by Yagnesh	5	604
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	605
Scrolling within a section of an excel worksheet jesstravmad	by clnickson	1	920
sumproduct from multiple sheets Matt	by RagDyer	3	911
retrieve cell formatting with IF(HLOOKUP) formula useR	by useR	2	1,242
Looking up values in a table LesLdh	by jwh	17	1,129
International number separator bibi	by bibi	0	664
VBA, Excel - Find Range, Sort Danny	by Danny	3	1,481
add a formula to Excel arbert	by Gary's Student	1	450
a function giving the interest rate for inv x for period y & bal z cal777	by Bernie Deitrick	1	524
Filter not working in a protected file jijy	by Ron de Bruin	1	705
Due Dates Reminders newstrom	by newstrom	0	577
Impossibility? jsc3489	by jsc3489	7	444
How do I get rid of the #/DIV/0! message Marshall Scmidt	by Harlan Grove	3	532
I am trying to use the "Camera" function within Excel JIMk	by JIMk	0	642
Counting Letters Blink	by Bob Phillips	2	524
EXCEL UNPROTECT SHEET WILL NOT DISPLAY....HELP! JAN	by JAN	0	994
New WorkBook ACase	by Ron de Bruin	1	444
Count returns for a period - year Saintsman	by Roger Govier	1	549
counting and matching jsc3489	by jsc3489	2	381
Adjusting Vlookup Values addie	by Roger Govier	1	403
advanced if????? taran	by taran	5	528
get a count of numbers whose value falls within a given range LyleB_Austin	by bj	5	1,240
How do I change the "comment" default location ? RRR	by Debra Dalgleish	1	764
Counting what's left in a list WBTKbeezy	by WBTKbeezy	2	404
Automatic update of list in Excel Swampy	by Swampy	0	685
Which function to use? taxmom	by Roger Govier	6	394
Analysis sirgresley	by bj	1	383
How do I calculate a future date in Excel? macheath48	by Bernie Deitrick	2	995
nested Indirect to other WS LyleF	by LyleF	4	660
can you select rows in excel with a certain background color? stelee	by Ron de Bruin	1	1,154
Averaging Values in Auto Filter Mr. Jan Park	by Domenic	1	1,165
Automatically update links when server names change J Hotch	by tony h	1	1,010
help me write function? Zach	by Zach	5	486
Excel should let me track my paychecks and salary history. kscherry2000	by kscherry2000	0	840
VLookup Help xcelion	by xcelion	0	414
DATA FILTER ARROWS DISPLAY WHILE INACTIVE lassie	by lassie	0	597
View gridlines despite changing cell color JLI	by JLI	0	472
Rolling Calendar MrBen via OfficeKB.com	by MrBen via OfficeKB.com	0	935
How do I change the plus to a negative in a column of numbers? JKB	by Arvi Laanemets	2	1,737
Sumif function? claudlarue	by claudlarue	2	731
text argument in vlook up which has a "" carlosgdlf	by Ron Coderre	6	532
In excel: when in print preview, 1 button to 'maximise margins' Sa Gested	by Sa Gested	0	725
Accidentally converted date mm/dd/yy to a 5 digit number Eve	by Lady Layla	6	927
formula to count cells not blanK pmarques	by Bryan Hessey	4	1,180
How to : Comparing Two Ranges lockwood7	by lockwood7	3	493
Formula stays displayed in cell AMY Z.	by AMY Z.	4	544
Combining cell information Ann-Charlotte	by Gary's Student	1	413
Empty Excel File -- Data Lost? Danny Cazier	by Dave Peterson	1	951
info in cel needs to propt other cels to automatically enter text Bill W	by Bill W	2	611
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	994
Formula to display Sheet name JaneC	by Krishnakumar	5	432
Dates/ Ages Brian	by Bob Phillips	7	638
create multiple worksheet Ramkaji, Nepal	by Bob Phillips	2	401
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	370
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	763
how can I search a field for a particular word brantty	by Max	8	1,022
MAX/MIN with SUMPRODUCT [email protected]	by Max	7	1,266
how to move worksheet thru keyboad jongmee park	by David McRitchie	1	386