Excel Worksheet Functions - Page 678

Thread / Thread Starter	Last Post	Replies	Views
Calculating networkdays & working hours Scopar	by Ron Rosenfeld	3	772
Average if....between range Saintsman	by Toppers	4	892
Complex SUMIF question SkyGuy50	by SkyGuy50	4	520
Return formula as text Paul Wittle	by Gary''s Student	1	735
Want to add value from a range and display result in a cell. michaeltiang	by Stu Gnu	3	473
Getting #NUM! result for SumProduct Sarah (OGI)	by Dave Peterson	10	848
How Do I Recover the Erased Data [email protected]	by bj	1	432
Extrapolation of non linear data andy duncan	by Pete_UK	8	1,484
Sorting Question Freshman	by Robert McCurdy	11	820
can I change the date format as dd-mm-yy bindu	by Aivis	7	493
Pivot Tables-Source Range continually increasing CrimsonPlague29	by Sean Timmons	2	427
how do i set up a horizontal spreadsheet? April	by Beege	2	374
Refresh and PivotTable with Analysis Services Marco Russo	by Marco Russo	2	938
IF function Juan Bta.	by David Biddulph[_2_]	6	357
Unique number bvr	by David Biddulph[_2_]	4	382
Calculating three working days before a date [email protected]	by John Bundy	4	609
Missing function in Excel Marie-Eve	by David Biddulph[_2_]	3	415
multiple data ranges for countif David G[_2_]	by Harlan Grove[_2_]	4	599
The 4th column D to be filler. Steved	by ryguy7272	21	1,158
Index Match Row Heading? Javier Diaz[_2_]	by Javier Diaz[_2_]	12	959
Match Values in Rows with Partial Values in Columns ryguy7272	by ryguy7272	3	1,050
Duration in Hours (or hh:mm:ss) MJW[_2_]	by Peo Sjoblom	5	437
Displaying a date range derived from WEEKNUM Jock	by Rick Rothstein \(MVP - VB\)	3	848
How do I create a drop down cell menu with different colour cells Alistair22	by Javier Diaz[_2_]	1	780
multiple worksheets in workbook mail merged into a word documents la	by ryguy7272	1	616
links Sashyy	by Javier Diaz[_2_]	3	349
Show Two Decimal Places After Concatenation ryguy7272	by ryguy7272	7	2,186
Having comments copied when using formulas Corkey	by Corkey	4	639
selecting the first date in a range of dates shoun2me	by T. Valko	7	770
working VAT in worksheet Tina Harrison	by Tina Harrison	0	786
can't get two variable tables to work clicktraining	by clicktraining	0	332
Count Names relo	by Peo Sjoblom	7	924
F2 Edit Key dr	by dr	0	311
How to use an if statement to show if ANY value in the cell? Katie	by Katie	0	423
Excel not copying formula reference to original workbook RS	by RS	9	1,131
GETPIVOTDATA in Excel 2007 Kirk P.	by Kirk P.	0	435
Data Validation issue help request Misop1	by Misop1	0	303
Data Validation issue help request Misop1	by Misop1	0	297
Data validation with a fixed amount of decimal places [email protected]	by [email protected]	0	557
F2 Edit Key dr	by dr	4	398
formula help Jamie	by Harlan Grove	13	742
Eliminate the #VALUE! response. inthestands	by inthestands	0	380
working VAT in worksheet Tina Harrison	by Sandy Mann	16	1,316
GETPIVOTDATA in Excel 2007 Kirk P.	by Nick Hodge[_2_]	6	582
Sumif Mirko	by Mirko	0	308
How to use an if statement to show if ANY value in the cell? Katie	by T. Valko	4	347
Formula with DateValue and doing Fill doesn't work, need help Theresa W	by Theresa W	0	291
VLOOK-pivot table expanding want to update vlook automatically CrimsonPlague29	by CrimsonPlague29	0	997
VLOOK-pivot table expanding want to update vlook automatically CrimsonPlague29	by CrimsonPlague29	0	715
Sumif Mirko	by Peo Sjoblom	4	450
Formula with DateValue and doing Fill doesn't work, need help Theresa W	by Theresa W[_2_]	4	1,006
help with sum if function bl_johnson_19[_2_]	by bl_johnson_19[_2_]	7	401
How do you determine a seasonal index in Excel? [email protected]	by [email protected]	0	527
IF Function question. Excel beginner	by Excel beginner	0	473
copying data from access to excel creates a bitmap file senior needs help	by senior needs help	0	446
copying data from access to excel creates a bitmap file senior needs help	by senior needs help	0	640
Function To Add across Multiple Sheets with a Twist Sean	by Harlan Grove	11	836
Limit on Logic Nash13	by Nash13	14	922
Extracting data from a long list Chandler	by Chandler	0	378
TRIM not trimming Kim	by Kim	0	396
How i add axis ( z ) in 2D XY chart ARNABCHAK	by Mike Middleton	3	1,598
How do you determine a seasonal index in Excel? [email protected]	by Mike Middleton	2	4,280
How do I make a cell round to another cell? Aaron	by Aaron	0	438
separate cell values with formulas - can this be improved? ilia	by Harlan Grove	23	1,580
conditional formatting of cells cell formatting	by Gord Dibben	6	784
Selective extraction of data from a table Balan	by Balan	11	912
Cant Seem to Nail this Lookup Javier Diaz[_2_]	by Max	13	1,015
Extract list of units based on error criteria to new list Sheila	by Sheila	0	599
Extract list of units based on error criteria to new list Sheila	by T. Valko	14	1,685
Exceed Row Limit Freshman	by Freshman	0	506
Auto Data Input Freshman	by Freshman	0	363
Formula Kris	by T. Valko	2	387
Auto Data Input Freshman	by Arvi Laanemets	1	369
Placing macros within the IF condition Sonia	by Bob Phillips	4	733
Can the Match function handle more than 7 variables? Zakynthos	by Zakynthos	3	565