Excel Worksheet Functions - Page 384

Thread / Thread Starter	Last Post	Replies	Views
If, Count & Array Bec[_3_]	by T. Valko	2	478
hoW TO LOCK AND UNLOCK A CELL USING A FUNCTION/FORMULA Ridhi	by Ridhi	6	2,609
adjustable interest rate with caps jrenglish86	by Fred Smith[_4_]	3	723
SumIf Function Amber	by Tyro[_2_]	2	412
MS EXcel Help Abhijit Saha	by Ashish Mathur[_2_]	4	482
Lookup Formula not working completely Newsgal	by Max	9	451
Hyperlink to exit Excel Pimamedic	by Pimamedic	8	1,606
Excel 2003/2007 paste special values shows bizarre results TeeDub	by Ashish Mathur[_2_]	11	2,144
eliminating duplicate lines JohnnyJomp	by Bernd P	5	700
auto filter use with command button deen	by OssieMac	9	986
Wildcard for dsum formula jeq214	by jeq214	7	2,271
cell reference in a formula using 2 worksheets Oxpictas	by T. Valko	5	598
Lookup or reference 3 data points AG	by AG	4	499
Macro to move one cell down tjb	by Dave	13	1,778
macro; reorganize blocks of data anand	by Lars-Åke Aspelin[_2_]	3	494
How do I sum cashflows within date range given dates and cash flow Gerry Pat	by Jim	1	929
Counting Various Things robzrob	by Herbert Seidenberg	2	430
Max function DianeG	by DianeG	4	449
Dependent vlookups - nested vlookups (maybe) Maniv	by Maniv	1	1,031
Subtracting time Eliott	by Eliott	5	383
Random selections Kim	by Bernie Deitrick	2	385
neat trick - excel art - very nice with out functions yshridhar	by Gord Dibben	1	659
Imbedded Objects with filters on All user	by All user	0	454
weighted averages in a pivot table - how? Vic	by Vic	0	578
Warning upon closing sheet stevieboy1313	by Gord Dibben	6	868
change Data from column b into row based on value in column a CmSant2	by Max	1	561
Change Format of Date in Header Sriram	by Gord Dibben	2	1,113
Running Total per group of items Brightgirl168	by Spiky	3	1,817
Deleting Workbook from others Julia	by Gord Dibben	2	391
Product by Month formula Brian	by Max	5	418
Paramters or Arugment Auto-Label for User-Defined Function [email protected]	by Gord Dibben	5	864
sum total of hours minutes seconds in excel 2003 Sherri Grezel[_2_]	by David Biddulph[_2_]	2	1,253
Fixing Page Breaks vic1	by Spiky	3	589
VLOOKUP using Fifth Column RoadKill	by RoadKill	3	333
Excel file not opening when saved with Extention .html sfleck	by Zack Barresse	1	519
sum hours minutes seconds excel 2003 Sherri Grezel	by Peo Sjoblom	1	565
Special Consultation Morfeo	by Morfeo	4	305
macro; reorganize blocks of data anand	by Tom Hutchins	1	549
EXEL 2003 Randall	by Tom Hutchins	1	418
How do you merge a dollar amount into a word doc and keep the $? Campo	by ryguy7272	2	1,783
Having cells default to 0 Riptide	by Riptide	2	391
IF statement with 2 array formulae nathan_savidge	by Bob Phillips	1	753
Totalling Dynamic Range Subtotals in Excel 2003 max@SATX	by max@SATX	6	2,057
if condition Christopher Naveen[_2_]	by Max	12	1,076
how can I insert lines with the help of formulas Gurdeep Kalra	by Gary''s Student	1	463
Possible sumproduct to find/sum the last entry in each row Sarah (OGI)	by Sarah (OGI)	2	454
Save file as semi-colon delimited? Colin Hayes	by Stefi	2	2,631
excel error033160_01 Deep	by Deep	0	374
excel error033160_01 Deep	by Deep	0	408
open text file in excel George Applegate[_2_]	by Tyro[_2_]	2	493
VLOOKUP using Fifth Column Max	by Max	0	308
VLOOKUP using Fifth Column Dave	by Dave	0	462
Last NonBlank cell in a range Koffiepit	by RagDyer	7	693
search and copy text from one sheet to others simpsonehh	by Max	4	400
Index & Match phuser[_2_]	by phuser[_2_]	4	451
Embedded OR, AND statements in an IF structure W Wolfe	by Rick Rothstein $MVP - VB$[_350_]	4	694
Unique count formula Daniel Bonallack	by T. Valko	3	478
Compiled data from many files Unda	by ryguy7272	1	394
Help with a conditional formula using ranges cabana_boy	by Gaurav[_2_]	5	384
count if column A is 1-2 and column B is 03/02/08 to 03/09/08 bokey	by Peo Sjoblom	4	376
Copy parts of a data range into a new spreadsheet forest8	by JLatham	4	977
text on worksheet with no gridlines Carol	by BoniM	2	400
GETPIVOTDATA function only returns zero's Steven Cheng	by Steven Cheng	0	438
Overtime Calculation for Overtime SilviaG	by joeu2004	4	1,421
multiple range array with ttest erinlm	by erinlm	2	1,519
Matching a column of new data to existing larger data set. Sirjay	by Pete_UK	1	720
tieing copies together dkb43	by Pete_UK	1	397
Sumproduct krandall	by Pete_UK	1	282
how to format a worksheet to tab through a series of check boxes? charvel	by charvel	0	511
Need help creating a formula that will auto post amts when marked. Cindy E.	by Mike	1	502
Need help with formular on excel 2007 Buzz Local#30	by Pete_UK	3	549
adding the qty's of products from several worksheets. Steve	by ryguy7272	3	367
Remove Merge and Center for entire spreadsheet JE	by ryguy7272	3	3,131
HLOOKUP across two spreadsheets Beverly Darvill	by Beverly Darvill[_2_]	3	1,114
SUMIF from multiple files Unda	by David Biddulph[_2_]	3	414