Excel Worksheet Functions - Page 616

Thread / Thread Starter	Last Post	Replies	Views
VLOOKUP gives duplicate results for "empty" searches Doc Farmer	by Pete_UK	4	993
Nested table subtotals Functioning Mortal	by bpeltzer	1	516
Excel: if in advance unknow# repeated in row get remark in a cell dilettante	by dilettante	0	395
QUERY data range to populate separate worksheet? Greg Purnell[_2_]	by Don Guillett	3	953
How do I sort two columns without changing the formatting? LisaD	by Susan	5	557
Conditionally lock a Cell Dave Shanky	by Barb Reinhardt	1	889
Networkdays with no start date and no end date stuck4once	by stuck4once	4	2,882
Matching formula results to datasets Ben Burns	by Ben Burns	3	391
Lookup Help.... (Please?) Andy	by BigPig	1	316
Print every other row lennis	by Gary''s Student	1	429
What does the "-{1,7}" do in conjunction with SUM David	by T. Valko	3	400
Text formula Eva	by Eva	6	346
Cross-Referencing Across Worksheets Chris Hall	by Chris Hall	0	485
How do I round a formula generated number texasdutch	by Susan	6	533
Comparing two different sets of data with common element tutaref	by Joel	1	1,468
How to enable macros and automatic calculation on Excel Viewer? David	by Gord Dibben	2	6,396
Excel Calculation Result Display Failure guy.yeon	by Gord Dibben	4	531
Questions About Iteration MDW	by Niek Otten	2	346
how many characters are there in a cell/ sarah	by Dave Peterson	1	454
Table of employees and shifts Jose Lopes	by Jose Lopes	0	314
VLOOKUP? Nyte	by Toni[_2_]	3	333
filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 Debbie	by Dave Peterson	1	773
more sorting I. Miller	by Pete_UK	4	487
how do you convert a number into a date JCM	by JCM	2	707
Total last 30 days Eric	by Eric	6	3,519
sum if based on PARTIAL content of another cell [email protected]	by JE McGimpsey	1	735
Excel calcalation Dawiz	by BoniM	1	375
Need Help with Macro [email protected]	by [email protected]	8	369
UDF question CSUS_CE_Student[_2_]	by T. Valko	1	362
Keyboard Arrows Bert	by SachinRudraksha	3	665
total using months outhouses	by BoniM	2	315
Timer Vijay	by Gary''s Student	1	798
Array subtitute Salman	by Salman	4	481
Unequal Product Sum Aitchy	by Max	3	378
Problem with a UDF im trying to write CSUS_CE_Student[_2_]	by Dave Peterson	3	350
formula a value in a formula Richard[_2_]	by merjet	1	300
sum based on PARTIAL content of another cell [email protected]	by [email protected]	4	549
working with employee tenure and grouping Casey Tremper	by JLatham	2	956
Count Unique Text Values Scott Halper	by Domenic	18	2,228
update linked pages jcdipietro	by jcdipietro	2	594
Refrencing cell formulas in a new worksheet MWay	by David Biddulph[_2_]	2	422
Match, Index, Indirect ? PCLIVE	by PCLIVE	1	988
Help with Excel formula in a Workbook Solograndma	by Solograndma	8	418
Delete a sheet and access charts Jim--Kent	by Gord Dibben	2	338
Find and replace Ron McCormick	by Ron McCormick	2	676
Data Validation In-Cell Dropdown has Suddenly Stopped being Displa Brett Fish	by Héctor Miguel	3	584
Too Many Variables Heliocracy	by Bob Phillips	6	500
Dynamic Sum Steve[_4_]	by T. Valko	10	665
Summing values from an undetermined number of sheet smaruzzi	by Peo Sjoblom	3	384
merge a wordfile of names & addresses to an excel separate cells John	by SongBear	1	457
single lookup value with multiple results aramancam	by Peo Sjoblom	1	473
Dynamic arguement? numberoverzero	by Barb Reinhardt	1	365
counting cells by text color alberto	by alberto	6	561
Feed Data from Multiple worksheets to a Summary Worksheet BT1113	by Max	2	1,313
Wildcard lookup MLK	by daddylonglegs	5	458
Need to Calculate only part of a formula in Excel 2003 Gabe	by daddylonglegs	2	667
Colorful Dropdown Lists creative schwabbie	by Max	2	1,158
Merging text cells from two worksheets with one shared column A Ford	by JLatham	3	1,317
Find date duplicates Col 2 or Col 3 then combine Col 1 text Vibeke	by Max	8	757
Vlookup Ed Davis	by Pete_UK	4	318
{ } functions Ray[_2_]	by JMB	2	342
sum multiple cells from a 2d array koneil	by JMB	3	2,241
pulling data automatically from one spreadsheet to another [email protected]	by [email protected]	2	1,245
IF and VLOOKUP - how efficient? anthonyg	by Aladin Akyurek	6	904
can alarm be coded into a cell "x" hours before date's reached ? amblebookworm	by Gary''s Student	1	410
How to number lines (rows) on both sides of spreadsheet crb.e4xplor	by JLatham	6	2,832
Checking a cell against a named range Memento	by Memento	8	2,182
Saving an excel file using a date Ed Davis	by Ed Davis	5	410
EXCEL 2007 DATEVALE FUNCTION John	by Roger Govier	3	707
Copying filtered data to another worksheet DavidS	by DavidS	4	869
How to delete the "Insert Function Dialog Box" (dialog box only)? TBI''d biker	by TBI''d biker	2	2,330
Present value and future value Ted Metro	by joeu2004	6	1,184
Time Countif help or convert to text SFD	by T. Valko	3	398
Updating Data in Validation Lists kivikatz	by Max	7	380
date series in PivotTables KFuda	by Debra Dalgleish	4	330