Excel Worksheet Functions - Page 1003

Thread / Thread Starter	Last Post	Replies	Views
I have never been able to get a SumProduct formula to work..Help! BAC	by T. Valko	5	557
Date Function AJ	by Ron Rosenfeld	5	339
hyperlink, macro, stored procedure? JICDB	by Pete_UK	5	882
Exponential equations Dianamath161	by Dave Peterson	5	532
Comparing two columns of dates PaladinWhite	by T. Valko	5	675
Count formulas between excel files D	by D	5	523
Nested formula using WORKDAY function davisk	by Ron Rosenfeld	5	1,991
auto add data with addition of new worksheets Darcy	by Billy Liddel	5	505
I want to use a different cell if my date field is NULL/BLANK Ralph D''Andrea	by Trevor Shuttleworth	5	885
SUMIF function #VALUE! error links GB	by Dave Peterson	5	951
Count items by day Amber	by Amber	5	510
Max function with conditions JICDB	by JICDB	5	735
Data Validation - Calculated Error Title JASelep	by JE McGimpsey	5	491
datedif function ah[_2_]	by Ron Rosenfeld	5	778
Schedule Brandon	by Brandon	5	469
format a column with a function spreadsheet monkey	by Peo Sjoblom	5	370
Parseing to produce text only Mick Barry	by T. Valko	5	378
Vlookup using dates in the lookup range hmteacher	by Max	5	624
Viewing same cells at the same time in two sheets Clark	by Peo Sjoblom	5	383
Autonumbering hmk311	by Gord Dibben	5	551
Counting in an array PAL	by Myrna Larson	5	555
How can I display a batting average as .333 rather than 0.333? ernie d	by Gary[_2_]	5	1,207
IF() with #VALUE avgrin	by excelent	5	408
Difference (weekdays) between two dates ant1983	by Myrna Larson	5	2,291
Dates and arrays PAL	by T. Valko	5	394
SUM if the conditions are met Mortir	by Bernard Liengme	5	393
Combinations Balaji	by Jim Cone	5	597
Hide Cell Information LowRider	by T. Valko	5	362
Deleting multiple blank rows Halston76	by mr tom	5	555
Unwanted dash Remo Shiva	by Sasa Stankovic	5	558
IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE SRINIVAS	by SRINIVAS	5	402
Excel Function Linda	by Linda	5	462
Custom Data Validation : Lock if MyCell = ""? RayportingMonkey	by RayportingMonkey	5	2,595
How do I display the most recent "modified" date in Excel sheets? Curious Cat	by Curious Cat	5	1,809
Check for duplicates? Vass[_2_]	by Pete_UK	5	420
workday with month functions Monique	by Monique	5	762
Dates formula orquidea	by orquidea	5	535
Conditional formula Fwak	by Pete_UK	5	339
change a list of 2 digit years to 4 digit years? Fredgus	by Pete_UK	5	1,508
Simple Formula Help? Siper1	by Rick Rothstein \(MVP - VB\)	5	340
IF(ISBLANK) with other criteria CJ	by papou[_2_]	5	593
Date robzrob	by robzrob	5	433
Urgent! I am in dire trouble - boss says it can be done - How? Cathi	by Pete_UK	5	492
#Value! Keeps appearing RFTKaiser	by Pete_UK	5	709
Protecting sheet that has macro ub	by JP[_3_]	5	443
How to make this macro stop? Jo[_2_]	by Dave Peterson	5	477
Repeat keystrokes to delete character in column Graeme at Raptup	by Graeme at Raptup	5	987
evaluate cell value with sheet name [email protected]	by [email protected]	5	592
Macro REQ: Automatically copy a template sheet and rename MCSmarties	by Trevor Shuttleworth	5	2,166
Count the number of changes to a cell RMan	by T. Valko	5	4,896
Novice IF and COUNT question (I think) Robin	by Pete_UK	5	378
Parse File Location Mike	by Balan	5	715
HELP - Conditional Formatting Dates & Blank Cells Diane1477	by Diane1477	5	860
COUNIFS Larry Byrne	by Larry Byrne[_2_]	5	503
A question about INDIRECT() Shuang	by JE McGimpsey	5	642
How do I convert decimal to feet and inches Erik	by David Biddulph[_2_]	5	2,884
need formula politesse	by Srikanth[_3_]	5	472
Number Order zoomzoom632	by Pete_UK	5	406
Find max value in one column and return the value of corrosponding cell in different column [email protected]	by Sandy Mann	5	2,074
Hello hjburk	by hjburk	5	345
Sum column of vlookup mjones	by Max	5	559
Conditional formatting to ignore zeros Jock	by Jock	5	4,936
What does ^ do in a formula? Mickford	by JE McGimpsey	5	402
Formula giving wrong result Jock	by vezerid	5	801
Help, Excel Files Being Wiped Out: Data Lost or Corrupted Mister Softie	by Rich Kooyer[_2_]	5	1,138
How do I set up a formula to calculate a bonus? Dabeave	by JLatham	5	1,486
Include Subtotal in SumIf Bonobo	by Antonio	5	837
E-mail one sheet Lella	by ab3d4u[_14_]	5	366
LOOKUP return the value from the previous row Steve	by T. Valko	5	2,626
VLOOK UP Kashif	by arno[_2_]	5	552
Vlookup based on date specified bmo	by Pete_UK	5	614
Breaking down an excel formula [email protected]	by Sandy Mann	5	1,503
what is the formula for rounding time up to 1/4 hr? Rosemary	by Teethless mama	5	366
Find Smallest and Largest. dlbeiler	by Don Guillett	5	988
Combined ROUNDUP Frustrated in AL	by Stefi	5	429