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	927
HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT deborah.hill	by Max	6	653
sumproduct function returns #value or #ref error Jennie	by Leo Heuser	4	994
Need a formula that counts orders Watercolor artist	by Watercolor artist	6	413
COUNT IF NOT EQUAL TO ZERO ellebelle	by Max	12	3,443
Formula question Craig Fletcher	by Craig Fletcher	2	452
using dget Leslie	by Leslie	0	592
need help with a simple xls equation !! CC-Khriz	by malik641	3	392
List Unique Occurences and Count PGiessler	by PGiessler	6	605
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
Hyperlink Douglas McDonald	by Douglas McDonald	0	280
Concatenating cells to produce a cell ref from another excel file ItsMeAgain	by JE McGimpsey	1	626
Unhide Pivot data tab coal_miner	by Debra Dalgleish	3	1,035
Excel 97 freezes up when using hyperlink to another excel rpt file JP	by JP	0	607
Extracting from a text string AmyTaylor	by BenjieLop	3	899
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	479
ROUNDUP IN 0.2 INCREMENTS igor058	by paul	3	892
Abbreviation for "Rear Derailleur" as "RD" Sammy in Taiwan	by Bob Phillips	4	477
Meeting two conditions before summing Andeb	by Bob Phillips	1	471
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error Muhammad Nasir	by Bob Phillips	9	612
combination of vlookup and match question Nelson	by Biff	3	770
Transpose formula SteveC	by Biff	3	443
Generate Payment Statement myty	by myty	5	437
Concatenate Multiple Instances in Array sunfish62	by Biff	1	684
"E" or "O" for the first, even or odd digit in a number jenn	by Ron Rosenfeld	2	1,276
someone must how to do this. :):) Wei	by Lewis Clark	3	384
help me out plz? yousuf555	by yousuf555	0	383
"E" for even numbers. "O" for odd numbers. jenn	by jenn	9	1,241
Problem with nested IF_OR statement DOOGIE	by RagDyer	7	941
Find Median of Positive numbers only in Range MichaelC	by Ron Rosenfeld	4	2,065
Counting cells with intervals Paulo AraÃºjo	by Ron Rosenfeld	4	513
Help with Excel Macro. Cesar_us	by JMB	3	347
How to dynamically reference a dynamic named range paris3	by JMB	4	1,314
Help only1joal	by only1joal	0	323
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,154
using time functions when hours are greater than 10000 heliheadache	by Bob Phillips	1	846
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	864
Worksheet data function srumsey	by srumsey	0	320
saving the format when emailing mlh	by Anne Troy	1	379
Conditional Formating carl	by carl	2	478
Display only surname Pat	by CLR	2	821
automate creation of sheets in excel Daniel	by JE McGimpsey	1	1,081
Extending a balance sheet BillyBoy	by BillyBoy	3	554
I need an Excell formula that will add x$'s every 30 days Mark_N_Jen	by JE McGimpsey	1	414
Scenarios JosefS	by Debra Dalgleish	2	410
copying subtotals in Pivot tables Tab	by Debra Dalgleish	3	497
Summary of Max Hourly entries Al	by Al	0	307
dget function Jordan	by Jordan	2	557
HELP: Cell Value as Filename? bajofuego	by Paul B	1	329
How can a formula in a cell automatically update when inserting a. stbookkeeper	by Peo Sjoblom	1	908
Cannot protect worksheet if it includes a list Elladene	by Elladene	0	638
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	716
Format text in one cell based on value in another cell Liz C	by Liz C	2	1,359
Excell linked to outlook contacts Tofolo	by JPW	1	547
is there anyway in an excel macro to reorder the sheet tabs from left to right? Daniel	by Anne Troy	2	981
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	562
Create a pick list to use to go to a text cell in Excel Pegita	by Debra Dalgleish	1	1,114
How can I make a cell mandatory and only accept a Y or N? Vicki	by Ron Rosenfeld	1	1,000
lists and validation andrewm	by Debra Dalgleish	3	415
Function to find row with most current date malik641	by Ron Rosenfeld	3	1,021
Creating a bar graph manually WLMPilot	by Biff	5	883
Ref from table - complete Steve	by Biff	3	390
Dynamic Formula? atran	by Domenic	6	367
highlighting required fields maryann	by Barb R.	2	936
if greater then 99 then 1 if greater then 199 then two N.R.	by Bob Phillips	2	714
Get aveages for last few days Sick Puppy	by Domenic	15	975
Help creating dynamic refrence cells Bill	by Bill	0	422
RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE Pauldecan	by Pauldecan	0	586
Control Toolbox John Data	by Bob Phillips	3	588
IF Function trhhs	by swatsp0p	2	337
How do I calculate APR for interest-only loans MK Manzer	by N Harkawat	4	2,054
Cell Calculations Lilbit	by Lilbit	4	466
Hyperlink-Programable replacement of Text with Its Actual Address Kathy	by Kathy	2	493
Moving formulas Chris White feeling dumb!	by Bob Phillips	3	357