Excel Worksheet Functions - Page 506

Thread / Thread Starter	Last Post	Replies	Views
Sumif Mirko	by Peo Sjoblom	4	465
VLOOK-pivot table expanding want to update vlook automatically CrimsonPlague29	by CrimsonPlague29	0	1,020
VLOOK-pivot table expanding want to update vlook automatically CrimsonPlague29	by CrimsonPlague29	0	741
Formula with DateValue and doing Fill doesn't work, need help Theresa W	by Theresa W	0	316
How to use an if statement to show if ANY value in the cell? Katie	by T. Valko	4	360
Sumif Mirko	by Mirko	0	326
GETPIVOTDATA in Excel 2007 Kirk P.	by Nick Hodge[_2_]	6	609
working VAT in worksheet Tina Harrison	by Sandy Mann	16	1,345
Eliminate the #VALUE! response. inthestands	by inthestands	0	401
formula help Jamie	by Harlan Grove	13	765
F2 Edit Key dr	by dr	4	416
Data validation with a fixed amount of decimal places [email protected]	by [email protected]	0	588
Data Validation issue help request Misop1	by Misop1	0	324
Data Validation issue help request Misop1	by Misop1	0	322
GETPIVOTDATA in Excel 2007 Kirk P.	by Kirk P.	0	453
Excel not copying formula reference to original workbook RS	by RS	9	1,165
How to use an if statement to show if ANY value in the cell? Katie	by Katie	0	438
F2 Edit Key dr	by dr	0	332
Count Names relo	by Peo Sjoblom	7	1,015
can't get two variable tables to work clicktraining	by clicktraining	0	345
working VAT in worksheet Tina Harrison	by Tina Harrison	0	800
selecting the first date in a range of dates shoun2me	by T. Valko	7	788
Having comments copied when using formulas Corkey	by Corkey	4	665
Show Two Decimal Places After Concatenation ryguy7272	by ryguy7272	7	2,208
links Sashyy	by Javier Diaz[_2_]	3	368
multiple worksheets in workbook mail merged into a word documents la	by ryguy7272	1	646
How do I create a drop down cell menu with different colour cells Alistair22	by Javier Diaz[_2_]	1	799
Displaying a date range derived from WEEKNUM Jock	by Rick Rothstein \(MVP - VB\)	3	875
Duration in Hours (or hh:mm:ss) MJW[_2_]	by Peo Sjoblom	5	449
Match Values in Rows with Partial Values in Columns ryguy7272	by ryguy7272	3	1,079
Index Match Row Heading? Javier Diaz[_2_]	by Javier Diaz[_2_]	12	993
The 4th column D to be filler. Steved	by ryguy7272	21	1,193
multiple data ranges for countif David G[_2_]	by Harlan Grove[_2_]	4	616
Missing function in Excel Marie-Eve	by David Biddulph[_2_]	3	435
Calculating three working days before a date [email protected]	by John Bundy	4	630
Unique number bvr	by David Biddulph[_2_]	4	409
IF function Juan Bta.	by David Biddulph[_2_]	6	375
Refresh and PivotTable with Analysis Services Marco Russo	by Marco Russo	2	961
how do i set up a horizontal spreadsheet? April	by Beege	2	392
Pivot Tables-Source Range continually increasing CrimsonPlague29	by Sean Timmons	2	443
can I change the date format as dd-mm-yy bindu	by Aivis	7	517
Sorting Question Freshman	by Robert McCurdy	11	843
Extrapolation of non linear data andy duncan	by Pete_UK	8	1,513
How Do I Recover the Erased Data [email protected]	by bj	1	456
Getting #NUM! result for SumProduct Sarah (OGI)	by Dave Peterson	10	867
Want to add value from a range and display result in a cell. michaeltiang	by Stu Gnu	3	491
Return formula as text Paul Wittle	by Gary''s Student	1	763
Complex SUMIF question SkyGuy50	by SkyGuy50	4	548
Average if....between range Saintsman	by Toppers	4	905
Calculating networkdays & working hours Scopar	by Ron Rosenfeld	3	789
Reference cell in one TAB from another using two criteria Jeff	by Max	4	1,433
Date calculation and possible vlookup Sarah (OGI)	by Mike H	1	637
short way for using all sheets in one formula Al Stone	by Al Stone[_2_]	2	457
VB Macro for digit KCG	by Bob Phillips	1	434
Random numbers Jane@Rakiraki	by Harlan Grove[_2_]	2	401
How do i get the 65k of rows to go away?? [email protected]	by Harlan Grove[_2_]	8	768
Convert pesos to dollars???? Roberta	by Pete_UK	1	2,263
Functions Stopped Working JDFitz	by Max	5	891
saved data has compressed to the left and unreadable Billythegolfer	by Jim Cone	1	403
Help creating a formula Joe Gieder	by Harlan Grove	15	755
Help Creating A Formula Joe Gieder	by Bob Phillips	2	392
Excel consolidation PrettyGAPeachSteelerFan	by Pete_UK	1	438
City State Zip Texas Nuckols	by L. Howard Kittle	3	1,033
Correlating Color and dates on calendar speadsheet Cassdawn	by bj	2	592
If statement bl_johnson_19	by John Bundy	2	428
Copy Formula Problem Mike C	by Mike C	2	391
How can I turn off the [VSync] mode in my excel file? [VSync] off?	by Dave Peterson	5	3,843
Return Value from a Filtered List [email protected]	by T. Valko	4	1,758
Excel 2003 Adriane N.	by David Biddulph[_2_]	1	364
sorting and extracting data [email protected]	by [email protected]	1	436
Second rounding in TIME() function JeLe	by Aivis	4	930
Logical Formulas debinnyc	by debinnyc	3	450
how do I divide one number into another number using excel? Arch56	by JLatham	2	1,561
Custom format whole number to decimal TamIam	by CLR	7	1,712
Macro Auto-update of data labels [email protected]	by [email protected]	0	1,266