Excel Worksheet Functions - Page 998

Thread / Thread Starter	Last Post	Replies	Views
"Formula is too long" gobonniego	by Dave Peterson	1	622
sumproduct for latest date Sue	by Biff	9	777
Function to look up largest value whose record meets criteria? Alison	by Alison	5	1,007
Counting Help JerryS	by Duke Carey	2	423
calculating dates Kira	by William Horton	1	471
How can I calculate the week number from a date, eg 21/06/05 = 26 cel504	by cel504	2	584
Copy page format into an entire workbook mdeanda	by lschuh	2	997
Macro Question carl	by Bob Phillips	1	400
my code too long? Zach	by Zach	2	539
Convert rows into 1 cell or 1 string Yagnesh	by Yagnesh	5	585
how do I display $1,243,597 as $1,244 and $(324,567) as $(325)? clnickson	by Bernie Deitrick	6	385
breaking up a phone number maximus73	by Lomax	2	582
Scrolling within a section of an excel worksheet jesstravmad	by clnickson	1	903
sumproduct from multiple sheets Matt	by RagDyer	3	852
retrieve cell formatting with IF(HLOOKUP) formula useR	by useR	2	1,135
Looking up values in a table LesLdh	by jwh	17	1,101
International number separator bibi	by bibi	0	642
VBA, Excel - Find Range, Sort Danny	by Danny	3	1,452
add a formula to Excel arbert	by Gary's Student	1	437
a function giving the interest rate for inv x for period y & bal z cal777	by Bernie Deitrick	1	501
Filter not working in a protected file jijy	by Ron de Bruin	1	679
Due Dates Reminders newstrom	by newstrom	0	562
Impossibility? jsc3489	by jsc3489	7	428
How do I get rid of the #/DIV/0! message Marshall Scmidt	by Harlan Grove	3	513
I am trying to use the "Camera" function within Excel JIMk	by JIMk	0	628
Counting Letters Blink	by Bob Phillips	2	481
EXCEL UNPROTECT SHEET WILL NOT DISPLAY....HELP! JAN	by JAN	0	971
New WorkBook ACase	by Ron de Bruin	1	429
Count returns for a period - year Saintsman	by Roger Govier	1	527
counting and matching jsc3489	by jsc3489	2	363
Adjusting Vlookup Values addie	by Roger Govier	1	383
advanced if????? taran	by taran	5	508
get a count of numbers whose value falls within a given range LyleB_Austin	by bj	5	1,189
How do I change the "comment" default location ? RRR	by Debra Dalgleish	1	714
Counting what's left in a list WBTKbeezy	by WBTKbeezy	2	392
Automatic update of list in Excel Swampy	by Swampy	0	670
Which function to use? taxmom	by Roger Govier	6	386
Analysis sirgresley	by bj	1	354
How do I calculate a future date in Excel? macheath48	by Bernie Deitrick	2	965
nested Indirect to other WS LyleF	by LyleF	4	614
can you select rows in excel with a certain background color? stelee	by Ron de Bruin	1	1,133
Averaging Values in Auto Filter Mr. Jan Park	by Domenic	1	1,113
Automatically update links when server names change J Hotch	by tony h	1	919
help me write function? Zach	by Zach	5	455
Excel should let me track my paychecks and salary history. kscherry2000	by kscherry2000	0	784
VLookup Help xcelion	by xcelion	0	393
DATA FILTER ARROWS DISPLAY WHILE INACTIVE lassie	by lassie	0	567
View gridlines despite changing cell color JLI	by JLI	0	459
Rolling Calendar MrBen via OfficeKB.com	by MrBen via OfficeKB.com	0	898
How do I change the plus to a negative in a column of numbers? JKB	by Arvi Laanemets	2	1,691
Sumif function? claudlarue	by claudlarue	2	708
text argument in vlook up which has a "" carlosgdlf	by Ron Coderre	6	494
In excel: when in print preview, 1 button to 'maximise margins' Sa Gested	by Sa Gested	0	687
Accidentally converted date mm/dd/yy to a 5 digit number Eve	by Lady Layla	6	892
formula to count cells not blanK pmarques	by Bryan Hessey	4	1,145
How to : Comparing Two Ranges lockwood7	by lockwood7	3	460
Formula stays displayed in cell AMY Z.	by AMY Z.	4	515
Combining cell information Ann-Charlotte	by Gary's Student	1	392
Empty Excel File -- Data Lost? Danny Cazier	by Dave Peterson	1	908
info in cel needs to propt other cels to automatically enter text Bill W	by Bill W	2	601
How to add numbers in a column dependant on their colour 24 Jan 05	by bj	2	760
Cumulative Time Usage in a Worksheet Charles1732	by Bob Phillips	1	460
Is there an easy way to count when adjacent cells contain same data? mrarcade	by Bob Phillips	1	949
Formula to display Sheet name JaneC	by Krishnakumar	5	415
Dates/ Ages Brian	by Bob Phillips	7	614
create multiple worksheet Ramkaji, Nepal	by Bob Phillips	2	380
Formula to add up units Steved	by Steved	3	419
how to import Ms word Table to Ms Excel for Various Calculations reneabesmer	by Karthik	1	574
Getting Min Value kk	by kk	3	352
multiplycation of money cell and time cell engr625	by Biff	1	559
Mortgage functions Cynthia A via OfficeKB.com	by Cynthia A via OfficeKB.com	0	382
Count designated cells VB	by Biff	1	733
how can I search a field for a particular word brantty	by Max	8	1,001
MAX/MIN with SUMPRODUCT [email protected]	by Max	7	1,206
how to move worksheet thru keyboad jongmee park	by David McRitchie	1	375