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	984
HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT deborah.hill	by Max	6	691
sumproduct function returns #value or #ref error Jennie	by Leo Heuser	4	1,028
Need a formula that counts orders Watercolor artist	by Watercolor artist	6	456
COUNT IF NOT EQUAL TO ZERO ellebelle	by Max	12	3,643
Formula question Craig Fletcher	by Craig Fletcher	2	498
using dget Leslie	by Leslie	0	620
need help with a simple xls equation !! CC-Khriz	by malik641	3	420
List Unique Occurences and Count PGiessler	by PGiessler	6	642
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	294
Concatenating cells to produce a cell ref from another excel file ItsMeAgain	by JE McGimpsey	1	655
Unhide Pivot data tab coal_miner	by Debra Dalgleish	3	1,064
Excel 97 freezes up when using hyperlink to another excel rpt file JP	by JP	0	629
Extracting from a text string AmyTaylor	by BenjieLop	3	941
text in formula explaining formula not to print Leon Klopper	by JE McGimpsey	1	567
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	922
Abbreviation for "Rear Derailleur" as "RD" Sammy in Taiwan	by Bob Phillips	4	490
Meeting two conditions before summing Andeb	by Bob Phillips	1	485
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error Muhammad Nasir	by Bob Phillips	9	626
combination of vlookup and match question Nelson	by Biff	3	802
Transpose formula SteveC	by Biff	3	466
Generate Payment Statement myty	by myty	5	465
Concatenate Multiple Instances in Array sunfish62	by Biff	1	711
"E" or "O" for the first, even or odd digit in a number jenn	by Ron Rosenfeld	2	1,363
someone must how to do this. :):) Wei	by Lewis Clark	3	392
help me out plz? yousuf555	by yousuf555	0	393
"E" for even numbers. "O" for odd numbers. jenn	by jenn	9	1,313
Problem with nested IF_OR statement DOOGIE	by RagDyer	7	1,001
Find Median of Positive numbers only in Range MichaelC	by Ron Rosenfeld	4	2,126
Counting cells with intervals Paulo AraÃºjo	by Ron Rosenfeld	4	537
Help with Excel Macro. Cesar_us	by JMB	3	362
How to dynamically reference a dynamic named range paris3	by JMB	4	1,375
Help only1joal	by only1joal	0	341
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,298
using time functions when hours are greater than 10000 heliheadache	by Bob Phillips	1	904
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	922
Worksheet data function srumsey	by srumsey	0	339
saving the format when emailing mlh	by Anne Troy	1	406
Conditional Formating carl	by carl	2	505
Display only surname Pat	by CLR	2	922
automate creation of sheets in excel Daniel	by JE McGimpsey	1	1,126
Extending a balance sheet BillyBoy	by BillyBoy	3	584
I need an Excell formula that will add x$'s every 30 days Mark_N_Jen	by JE McGimpsey	1	434
Scenarios JosefS	by Debra Dalgleish	2	426
copying subtotals in Pivot tables Tab	by Debra Dalgleish	3	534
Summary of Max Hourly entries Al	by Al	0	324
dget function Jordan	by Jordan	2	589
HELP: Cell Value as Filename? bajofuego	by Paul B	1	339
How can a formula in a cell automatically update when inserting a. stbookkeeper	by Peo Sjoblom	1	938
Cannot protect worksheet if it includes a list Elladene	by Elladene	0	672
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	737
Format text in one cell based on value in another cell Liz C	by Liz C	2	1,422
Excell linked to outlook contacts Tofolo	by JPW	1	569
is there anyway in an excel macro to reorder the sheet tabs from left to right? Daniel	by Anne Troy	2	1,010
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	599
Create a pick list to use to go to a text cell in Excel Pegita	by Debra Dalgleish	1	1,179
How can I make a cell mandatory and only accept a Y or N? Vicki	by Ron Rosenfeld	1	1,034
lists and validation andrewm	by Debra Dalgleish	3	440
Function to find row with most current date malik641	by Ron Rosenfeld	3	1,051
Creating a bar graph manually WLMPilot	by Biff	5	918
Ref from table - complete Steve	by Biff	3	439
Dynamic Formula? atran	by Domenic	6	421
highlighting required fields maryann	by Barb R.	2	970
if greater then 99 then 1 if greater then 199 then two N.R.	by Bob Phillips	2	767
Get aveages for last few days Sick Puppy	by Domenic	15	993
Help creating dynamic refrence cells Bill	by Bill	0	449
RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE Pauldecan	by Pauldecan	0	627
Control Toolbox John Data	by Bob Phillips	3	615
IF Function trhhs	by swatsp0p	2	359
How do I calculate APR for interest-only loans MK Manzer	by N Harkawat	4	2,090
Cell Calculations Lilbit	by Lilbit	4	487
Hyperlink-Programable replacement of Text with Its Actual Address Kathy	by Kathy	2	526
Moving formulas Chris White feeling dumb!	by Bob Phillips	3	380