Excel Worksheet Functions - Page 1015

Thread / Thread Starter	Last Post	Replies	Views
PMT function Ben	by JE McGimpsey	1	323
renaming copied worksheets deleting .xls] dhl	by Gordon	2	706
Something similar to sum() but ignoring error value arguments! agarwaldvk	by agarwaldvk	10	1,192
Sub SaveNClose() Steved	by Steved	2	453
how do i solve 'file not found' error when linking notebooks? bmorar	by Dave Peterson	1	734
Using sheet name in formula Brisbane Rob	by Dave Peterson	4	559
How do I view a JPEG file from data selected in Excel gilg	by gilg	0	587
autofill next sheet with next set of dates Penny	by Penny	0	521
Counting months Aaron Howe	by Aaron Howe	5	591
how can i assign i set of numbers (1-16) without repeating them? Stew	by JE McGimpsey	2	888
How to create formula to convert? ynot	by JE McGimpsey	9	551
change data source for many queries at once? Sam Raymond	by Sam Raymond	0	740
Can I find and replace "white space" in a cell in Excel? biggyb75	by JE McGimpsey	7	2,681
What function(s) to use? Barguast	by Barguast	4	335
Enabling sub menu items via vba Dan Neely	by Dan Neely	0	609
Ingoring text in a formula Brad N	by JE McGimpsey	2	300
difficult calculation joolz46	by Roger Govier	2	394
Text To Columns Function carl	by RagDyeR	2	552
Nested Formula TheLeafs	by Don Guillett	1	479
How can I use the random function? petevang	by JE McGimpsey	1	380
Counting question ckiraly	by ckiraly	6	489
How to get number of rows which match criteria kiranmani	by Roger Govier	6	722
How do I copy formulas from one wkb to another w/out linkng them? tomcat	by tomcat	7	449
Using VLookup and typing in values to be "looked up" Graeme LN	by Anne Troy	2	415
Help with a Function rhani111	by Aladin Akyurek	6	317
How to combine text from multiple cells? sierra	by Dave Peterson	3	1,079
print area poser neilwebb	by Dave Peterson	2	591
What happened to "Tab Color" for worksheets? Falcon	by Dave Peterson	5	333
Select rows of data in a worksheet on one criteria in multiple co MrSkoot99	by bj	5	1,177
can excel convert number into words (like 10 to ten)? nivedrajesh	by Roger Govier	2	1,205
Need formula that reads value and then displays value from same row, different column flywhiz	by flywhiz	2	475
Problems with .Refresh BackgroundQuery:=False dmplacebo	by dmplacebo	0	1,594
Formula is missing Shakeel	by Ron de Bruin	1	920
How do I produce a centroid fit to excel data? David_dudgeon	by David_dudgeon	0	2,394
The formula Watch Window in Excel should allow more than one row Fabiano	by Fabiano	0	606
excel printing neilwebb	by Ron de Bruin	1	480
Adding text in formulas Andreas	by Andreas	2	574
List Query aries0070	by Max	6	366
Un - Concatenate? JudithJubilee	by Alex Delamain	2	528
Part Number Lookup Marshall2	by Bob Phillips	2	619
Can I set more than three criteria for conditional formatting? River	by Bob Phillips	2	617
histogram for time values	by Bob Phillips	3	1,376
How Do I reverse axis in a spreadsheet ChrisH	by Max	3	1,310
link from one workbook to another workbook using a dropdown? sunflower	by Biff	2	865
random number without repeating? nonoi via OfficeKB.com	by JE McGimpsey	2	1,161
USING INDEX AND RECIEVING #VALUE ERROR MESSAGE gordo	by Biff	1	543
how to overwrite a value without loosing the formula? Mark Dvorkin	by Mark Dvorkin	10	1,517
CMD Button Help!!!! OriginalStealth	by ScottO	1	357
printing problem neilwebb	by Anne Troy	1	394
FORMULAS ANNE	by JE McGimpsey	1	328
formulas in pivot table casepaul1	by casepaul1	4	628
Help with adding certain cells using an IF function Jrr6415sun	by Padgett	4	434
how can i design a 2 page a day diary / appointment book kevin	by [email protected]	2	719
Function to Count Number of Consecutive Rows with a Specific Criteria? Templee1	by Sandy Mann	2	1,116
How to calculate and then show up as a percent? Amuse	by Tom Ogilvy	1	762
header row nospam	by nospam	6	341
Find then If then Replace cisq1	by cisq1	2	723
VLOOKUP from another sheet, VBA	by KL	7	2,023
compare time in IF statement	by JE McGimpsey	4	1,708
Help with drop down menu Jrr6415sun	by Debra Dalgleish	4	907
Do I need a formula or Macro? Sharen	by Anne Troy	2	443
protection and inserting rows tee	by Kassie	1	507
How to add the 10 smallest numbers out of a range of 20 numbers. JPreeshl	by Martin P	3	833
sorting whole numbers wstruse	by JE McGimpsey	4	927
IF previous cell value is < 0,(neg)then add it to this cell value GS Mobile	by Bob Phillips	1	549
Help please simple drop and drag I can't make work Anthony	by Anthony	2	766
sum function for minutes and seconds in Excel Brian McM	by Anne Troy	4	1,356
Problem with an "if" relating to a range Anthony	by Anthony	7	471
total subtotal cells Mary	by Anthony	1	442
Compare data on 2 separate worksheets. Wayne	by Ashish Mathur	3	604
totaling figures in colum Bedros	by Bedros	3	508
calling a new function Excel gives me #NAME? Mark Dvorkin	by Mark Dvorkin	4	1,196
Find then If then Replace cisq1	by cisq1	0	1,086
Insert more than 1 Row Syntax blazzae	by blazzae	5	962
sort ascending tab is not active. Why? jeremy corke	by Dave Peterson	2	701