Excel Worksheet Functions - Page 1015

Thread / Thread Starter	Last Post	Replies	Views
PMT function Ben	by JE McGimpsey	1	313
renaming copied worksheets deleting .xls] dhl	by Gordon	2	440
Something similar to sum() but ignoring error value arguments! agarwaldvk	by agarwaldvk	10	1,169
Sub SaveNClose() Steved	by Steved	2	439
how do i solve 'file not found' error when linking notebooks? bmorar	by Dave Peterson	1	716
Using sheet name in formula Brisbane Rob	by Dave Peterson	4	535
How do I view a JPEG file from data selected in Excel gilg	by gilg	0	563
autofill next sheet with next set of dates Penny	by Penny	0	498
Counting months Aaron Howe	by Aaron Howe	5	560
how can i assign i set of numbers (1-16) without repeating them? Stew	by JE McGimpsey	2	840
How to create formula to convert? ynot	by JE McGimpsey	9	533
change data source for many queries at once? Sam Raymond	by Sam Raymond	0	707
Can I find and replace "white space" in a cell in Excel? biggyb75	by JE McGimpsey	7	2,643
What function(s) to use? Barguast	by Barguast	4	321
Enabling sub menu items via vba Dan Neely	by Dan Neely	0	591
Ingoring text in a formula Brad N	by JE McGimpsey	2	286
difficult calculation joolz46	by Roger Govier	2	378
Text To Columns Function carl	by RagDyeR	2	538
Nested Formula TheLeafs	by Don Guillett	1	458
How can I use the random function? petevang	by JE McGimpsey	1	354
Counting question ckiraly	by ckiraly	6	470
How to get number of rows which match criteria kiranmani	by Roger Govier	6	708
How do I copy formulas from one wkb to another w/out linkng them? tomcat	by tomcat	7	432
Using VLookup and typing in values to be "looked up" Graeme LN	by Anne Troy	2	380
Help with a Function rhani111	by Aladin Akyurek	6	301
How to combine text from multiple cells? sierra	by Dave Peterson	3	1,052
print area poser neilwebb	by Dave Peterson	2	575
What happened to "Tab Color" for worksheets? Falcon	by Dave Peterson	5	319
Select rows of data in a worksheet on one criteria in multiple co MrSkoot99	by bj	5	1,149
can excel convert number into words (like 10 to ten)? nivedrajesh	by Roger Govier	2	1,166
Need formula that reads value and then displays value from same row, different column flywhiz	by flywhiz	2	458
Problems with .Refresh BackgroundQuery:=False dmplacebo	by dmplacebo	0	1,568
Formula is missing Shakeel	by Ron de Bruin	1	897
How do I produce a centroid fit to excel data? David_dudgeon	by David_dudgeon	0	2,272
The formula Watch Window in Excel should allow more than one row Fabiano	by Fabiano	0	576
excel printing neilwebb	by Ron de Bruin	1	455
Adding text in formulas Andreas	by Andreas	2	554
List Query aries0070	by Max	6	348
Un - Concatenate? JudithJubilee	by Alex Delamain	2	490
Part Number Lookup Marshall2	by Bob Phillips	2	599
Can I set more than three criteria for conditional formatting? River	by Bob Phillips	2	594
histogram for time values	by Bob Phillips	3	1,363
How Do I reverse axis in a spreadsheet ChrisH	by Max	3	1,297
link from one workbook to another workbook using a dropdown? sunflower	by Biff	2	839
random number without repeating? nonoi via OfficeKB.com	by JE McGimpsey	2	1,115
USING INDEX AND RECIEVING #VALUE ERROR MESSAGE gordo	by Biff	1	527
how to overwrite a value without loosing the formula? Mark Dvorkin	by Mark Dvorkin	10	1,498
CMD Button Help!!!! OriginalStealth	by ScottO	1	347
printing problem neilwebb	by Anne Troy	1	379
FORMULAS ANNE	by JE McGimpsey	1	310
formulas in pivot table casepaul1	by casepaul1	4	606
Help with adding certain cells using an IF function Jrr6415sun	by Padgett	4	415
how can i design a 2 page a day diary / appointment book kevin	by [email protected]	2	695
Function to Count Number of Consecutive Rows with a Specific Criteria? Templee1	by Sandy Mann	2	1,081
How to calculate and then show up as a percent? Amuse	by Tom Ogilvy	1	735
header row nospam	by nospam	6	326
Find then If then Replace cisq1	by cisq1	2	709
VLOOKUP from another sheet, VBA	by KL	7	1,986
compare time in IF statement	by JE McGimpsey	4	1,693
Help with drop down menu Jrr6415sun	by Debra Dalgleish	4	874
Do I need a formula or Macro? Sharen	by Anne Troy	2	424
protection and inserting rows tee	by Kassie	1	489
How to add the 10 smallest numbers out of a range of 20 numbers. JPreeshl	by Martin P	3	805
sorting whole numbers wstruse	by JE McGimpsey	4	898
IF previous cell value is < 0,(neg)then add it to this cell value GS Mobile	by Bob Phillips	1	547
Help please simple drop and drag I can't make work Anthony	by Anthony	2	712
sum function for minutes and seconds in Excel Brian McM	by Anne Troy	4	1,336
Problem with an "if" relating to a range Anthony	by Anthony	7	455
total subtotal cells Mary	by Anthony	1	430
Compare data on 2 separate worksheets. Wayne	by Ashish Mathur	3	591
totaling figures in colum Bedros	by Bedros	3	484
calling a new function Excel gives me #NAME? Mark Dvorkin	by Mark Dvorkin	4	1,165
Find then If then Replace cisq1	by cisq1	0	1,069
Insert more than 1 Row Syntax blazzae	by blazzae	5	931
sort ascending tab is not active. Why? jeremy corke	by Dave Peterson	2	669