Excel Worksheet Functions - Page 158

Thread / Thread Starter	Last Post	Replies	Views
HELP: Cell Value as Filename? bajofuego	by Paul B	1	329
dget function Jordan	by Jordan	2	558
Summary of Max Hourly entries Al	by Al	0	307
copying subtotals in Pivot tables Tab	by Debra Dalgleish	3	498
Scenarios JosefS	by Debra Dalgleish	2	410
I need an Excell formula that will add x$'s every 30 days Mark_N_Jen	by JE McGimpsey	1	415
Extending a balance sheet BillyBoy	by BillyBoy	3	554
automate creation of sheets in excel Daniel	by JE McGimpsey	1	1,081
Display only surname Pat	by CLR	2	823
Conditional Formating carl	by carl	2	480
saving the format when emailing mlh	by Anne Troy	1	379
Worksheet data function srumsey	by srumsey	0	320
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? Daniel	by Daniel	1	867
using time functions when hours are greater than 10000 heliheadache	by Bob Phillips	1	864
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. Daniel	by Daniel	0	2,159
Help only1joal	by only1joal	0	323
How to dynamically reference a dynamic named range paris3	by JMB	4	1,314
Help with Excel Macro. Cesar_us	by JMB	3	347
Counting cells with intervals Paulo AraÃºjo	by Ron Rosenfeld	4	513
Find Median of Positive numbers only in Range MichaelC	by Ron Rosenfeld	4	2,079
Problem with nested IF_OR statement DOOGIE	by RagDyer	7	946
"E" for even numbers. "O" for odd numbers. jenn	by jenn	9	1,242
help me out plz? yousuf555	by yousuf555	0	383
someone must how to do this. :):) Wei	by Lewis Clark	3	384
"E" or "O" for the first, even or odd digit in a number jenn	by Ron Rosenfeld	2	1,280
Concatenate Multiple Instances in Array sunfish62	by Biff	1	684
Generate Payment Statement myty	by myty	5	437
Transpose formula SteveC	by Biff	3	443
combination of vlookup and match question Nelson	by Biff	3	770
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error Muhammad Nasir	by Bob Phillips	9	612
Meeting two conditions before summing Andeb	by Bob Phillips	1	471
Abbreviation for "Rear Derailleur" as "RD" Sammy in Taiwan	by Bob Phillips	4	477
ROUNDUP IN 0.2 INCREMENTS igor058	by paul	3	893
How do i check if something non numeric is in a range & return'Y' Becs	by Becs	3	480
text in formula explaining formula not to print Leon Klopper	by JE McGimpsey	1	566
Extracting from a text string AmyTaylor	by BenjieLop	3	910
Excel 97 freezes up when using hyperlink to another excel rpt file JP	by JP	0	607
Unhide Pivot data tab coal_miner	by Debra Dalgleish	3	1,035
Concatenating cells to produce a cell ref from another excel file ItsMeAgain	by JE McGimpsey	1	626
Hyperlink Douglas McDonald	by Douglas McDonald	0	280
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. Daniel	by sanskar_d	1	1,911
List Unique Occurences and Count PGiessler	by PGiessler	6	610
need help with a simple xls equation !! CC-Khriz	by malik641	3	392
using dget Leslie	by Leslie	0	592
Formula question Craig Fletcher	by Craig Fletcher	2	468
COUNT IF NOT EQUAL TO ZERO ellebelle	by Max	12	3,563
Need a formula that counts orders Watercolor artist	by Watercolor artist	6	427
sumproduct function returns #value or #ref error Jennie	by Leo Heuser	4	998
HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT deborah.hill	by Max	6	653
How do I use the wildcard character and the NOT function? KDA	by Bernie Deitrick	1	945
pleas help: sumproduct function returns #value or #ref error Jennie	by Bob Phillips	1	862
Finding Max values Al	by Max	1	473
Convert a number of minutes like 400 into hours and minutes bloke	by swatsp0p	3	1,241
What is this kind of average called? havocdragon	by Harlan Grove	3	1,092
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE	by	0	1,062
* Character Kevin	by Jim	1	497
How do I arrange worksheet tabs In alpha order Worksheet order	by Anne Troy	2	1,204
Having trouble totaling columns in excel 2003, always worked b4 rjmac	by Anne Troy	1	977
Cell Combining Question JeffC	by JeffC	3	373
Calling another workbook not working malik641	by malik641	2	637
Can I use multiple criteria in SUMIF funqtion? Levan Alibegashvili	by Bob Phillips	2	560
Is there a way to color the cells based on the numeric value? ajyourpal	by Ron de Bruin	1	601
Address from one worksheet to another Duncan	by Al	3	524
lookup Armando Martellini	by Armando Martellini	2	297
formula Armando Martellini	by Armando Martellini	2	299
Difficult look up formula Alex	by Alex	4	538
contents of 1 combo box depends on choice of another Basheed Bazi	by William DeLeo	2	476
Nested IF(AND is not working Todd F.	by Ron Rosenfeld	13	839
In Excel combine tables from multiple worksheets in to one sheet? Pau	by Anne Troy	1	1,608
How to Concatenate with a text & number \|\| cypher \|\|	by Damon Longworth	1	647
counting specific words jen	by Bill Kuunders	2	522
Conditional Formatting Conditional Formatting	by Damon Longworth	1	363
Letter/Number Split carlito_1985	by Laurent Longre	3	565
Matching Date From Two Groups wsteel	by Biff	3	547
Trouble with dates...... DavidMunday	by Biff	1	411