Excel Worksheet Functions - Page 1026

Thread / Thread Starter	Last Post	Replies	Views
How do I use the wildcard character and the NOT function? KDA	by Bernie Deitrick	1	977
HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT deborah.hill	by Max	6	679
sumproduct function returns #value or #ref error Jennie	by Leo Heuser	4	1,020
Need a formula that counts orders Watercolor artist	by Watercolor artist	6	444
COUNT IF NOT EQUAL TO ZERO ellebelle	by Max	12	3,636
Formula question Craig Fletcher	by Craig Fletcher	2	496
using dget Leslie	by Leslie	0	613
need help with a simple xls equation !! CC-Khriz	by malik641	3	417
List Unique Occurences and Count PGiessler	by PGiessler	6	630
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,931
Hyperlink Douglas McDonald	by Douglas McDonald	0	293
Concatenating cells to produce a cell ref from another excel file ItsMeAgain	by JE McGimpsey	1	644
Unhide Pivot data tab coal_miner	by Debra Dalgleish	3	1,059
Excel 97 freezes up when using hyperlink to another excel rpt file JP	by JP	0	628
Extracting from a text string AmyTaylor	by BenjieLop	3	933
text in formula explaining formula not to print Leon Klopper	by JE McGimpsey	1	566
How do i check if something non numeric is in a range & return'Y' Becs	by Becs	3	491
ROUNDUP IN 0.2 INCREMENTS igor058	by paul	3	916
Abbreviation for "Rear Derailleur" as "RD" Sammy in Taiwan	by Bob Phillips	4	490
Meeting two conditions before summing Andeb	by Bob Phillips	1	482
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error Muhammad Nasir	by Bob Phillips	9	625
combination of vlookup and match question Nelson	by Biff	3	802
Transpose formula SteveC	by Biff	3	463
Generate Payment Statement myty	by myty	5	460
Concatenate Multiple Instances in Array sunfish62	by Biff	1	709
"E" or "O" for the first, even or odd digit in a number jenn	by Ron Rosenfeld	2	1,352
someone must how to do this. :):) Wei	by Lewis Clark	3	390
help me out plz? yousuf555	by yousuf555	0	392
"E" for even numbers. "O" for odd numbers. jenn	by jenn	9	1,299
Problem with nested IF_OR statement DOOGIE	by RagDyer	7	996
Find Median of Positive numbers only in Range MichaelC	by Ron Rosenfeld	4	2,114
Counting cells with intervals Paulo AraÃºjo	by Ron Rosenfeld	4	525
Help with Excel Macro. Cesar_us	by JMB	3	354
How to dynamically reference a dynamic named range paris3	by JMB	4	1,364
Help only1joal	by only1joal	0	334
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,291
using time functions when hours are greater than 10000 heliheadache	by Bob Phillips	1	892
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	912
Worksheet data function srumsey	by srumsey	0	328
saving the format when emailing mlh	by Anne Troy	1	393
Conditional Formating carl	by carl	2	502
Display only surname Pat	by CLR	2	916
automate creation of sheets in excel Daniel	by JE McGimpsey	1	1,118
Extending a balance sheet BillyBoy	by BillyBoy	3	572
I need an Excell formula that will add x$'s every 30 days Mark_N_Jen	by JE McGimpsey	1	427
Scenarios JosefS	by Debra Dalgleish	2	423
copying subtotals in Pivot tables Tab	by Debra Dalgleish	3	532
Summary of Max Hourly entries Al	by Al	0	317
dget function Jordan	by Jordan	2	587
HELP: Cell Value as Filename? bajofuego	by Paul B	1	336
How can a formula in a cell automatically update when inserting a. stbookkeeper	by Peo Sjoblom	1	932
Cannot protect worksheet if it includes a list Elladene	by Elladene	0	662
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? Daniel	by Chip Pearson	1	729
Format text in one cell based on value in another cell Liz C	by Liz C	2	1,410
Excell linked to outlook contacts Tofolo	by JPW	1	567
is there anyway in an excel macro to reorder the sheet tabs from left to right? Daniel	by Anne Troy	2	1,003
how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel? Daniel	by Alex	1	596
Create a pick list to use to go to a text cell in Excel Pegita	by Debra Dalgleish	1	1,172
How can I make a cell mandatory and only accept a Y or N? Vicki	by Ron Rosenfeld	1	1,031
lists and validation andrewm	by Debra Dalgleish	3	429
Function to find row with most current date malik641	by Ron Rosenfeld	3	1,044
Creating a bar graph manually WLMPilot	by Biff	5	907
Ref from table - complete Steve	by Biff	3	429
Dynamic Formula? atran	by Domenic	6	420
highlighting required fields maryann	by Barb R.	2	960
if greater then 99 then 1 if greater then 199 then two N.R.	by Bob Phillips	2	754
Get aveages for last few days Sick Puppy	by Domenic	15	992
Help creating dynamic refrence cells Bill	by Bill	0	438
RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE Pauldecan	by Pauldecan	0	627
Control Toolbox John Data	by Bob Phillips	3	599
IF Function trhhs	by swatsp0p	2	344
How do I calculate APR for interest-only loans MK Manzer	by N Harkawat	4	2,088
Cell Calculations Lilbit	by Lilbit	4	479
Hyperlink-Programable replacement of Text with Its Actual Address Kathy	by Kathy	2	524
Moving formulas Chris White feeling dumb!	by Bob Phillips	3	368