Excel Worksheet Functions - Page 384

Thread / Thread Starter	Last Post	Replies	Views
If, Count & Array Bec[_3_]	by T. Valko	2	490
hoW TO LOCK AND UNLOCK A CELL USING A FUNCTION/FORMULA Ridhi	by Ridhi	6	2,638
adjustable interest rate with caps jrenglish86	by Fred Smith[_4_]	3	738
SumIf Function Amber	by Tyro[_2_]	2	418
MS EXcel Help Abhijit Saha	by Ashish Mathur[_2_]	4	486
Lookup Formula not working completely Newsgal	by Max	9	463
Hyperlink to exit Excel Pimamedic	by Pimamedic	8	1,615
Excel 2003/2007 paste special values shows bizarre results TeeDub	by Ashish Mathur[_2_]	11	2,170
eliminating duplicate lines JohnnyJomp	by Bernd P	5	725
auto filter use with command button deen	by OssieMac	9	1,006
Wildcard for dsum formula jeq214	by jeq214	7	2,286
cell reference in a formula using 2 worksheets Oxpictas	by T. Valko	5	601
Lookup or reference 3 data points AG	by AG	4	503
Macro to move one cell down tjb	by Dave	13	1,843
macro; reorganize blocks of data anand	by Lars-Åke Aspelin[_2_]	3	506
How do I sum cashflows within date range given dates and cash flow Gerry Pat	by Jim	1	940
Counting Various Things robzrob	by Herbert Seidenberg	2	454
Max function DianeG	by DianeG	4	454
Dependent vlookups - nested vlookups (maybe) Maniv	by Maniv	1	1,054
Subtracting time Eliott	by Eliott	5	392
Random selections Kim	by Bernie Deitrick	2	392
neat trick - excel art - very nice with out functions yshridhar	by Gord Dibben	1	673
Imbedded Objects with filters on All user	by All user	0	468
weighted averages in a pivot table - how? Vic	by Vic	0	593
Warning upon closing sheet stevieboy1313	by Gord Dibben	6	879
change Data from column b into row based on value in column a CmSant2	by Max	1	583
Change Format of Date in Header Sriram	by Gord Dibben	2	1,122
Running Total per group of items Brightgirl168	by Spiky	3	1,839
Deleting Workbook from others Julia	by Gord Dibben	2	409
Product by Month formula Brian	by Max	5	426
Paramters or Arugment Auto-Label for User-Defined Function [email protected]	by Gord Dibben	5	881
sum total of hours minutes seconds in excel 2003 Sherri Grezel[_2_]	by David Biddulph[_2_]	2	1,267
Fixing Page Breaks vic1	by Spiky	3	593
VLOOKUP using Fifth Column RoadKill	by RoadKill	3	346
Excel file not opening when saved with Extention .html sfleck	by Zack Barresse	1	541
sum hours minutes seconds excel 2003 Sherri Grezel	by Peo Sjoblom	1	582
Special Consultation Morfeo	by Morfeo	4	311
macro; reorganize blocks of data anand	by Tom Hutchins	1	563
EXEL 2003 Randall	by Tom Hutchins	1	427
How do you merge a dollar amount into a word doc and keep the $? Campo	by ryguy7272	2	1,794
Having cells default to 0 Riptide	by Riptide	2	394
IF statement with 2 array formulae nathan_savidge	by Bob Phillips	1	776
Totalling Dynamic Range Subtotals in Excel 2003 max@SATX	by max@SATX	6	2,071
if condition Christopher Naveen[_2_]	by Max	12	1,097
how can I insert lines with the help of formulas Gurdeep Kalra	by Gary''s Student	1	482
Possible sumproduct to find/sum the last entry in each row Sarah (OGI)	by Sarah (OGI)	2	479
Save file as semi-colon delimited? Colin Hayes	by Stefi	2	2,651
excel error033160_01 Deep	by Deep	0	380
excel error033160_01 Deep	by Deep	0	422
open text file in excel George Applegate[_2_]	by Tyro[_2_]	2	506
VLOOKUP using Fifth Column Max	by Max	0	314
VLOOKUP using Fifth Column Dave	by Dave	0	464
Last NonBlank cell in a range Koffiepit	by RagDyer	7	712
search and copy text from one sheet to others simpsonehh	by Max	4	418
Index & Match phuser[_2_]	by phuser[_2_]	4	454
Embedded OR, AND statements in an IF structure W Wolfe	by Rick Rothstein $MVP - VB$[_350_]	4	701
Unique count formula Daniel Bonallack	by T. Valko	3	489
Compiled data from many files Unda	by ryguy7272	1	406
Help with a conditional formula using ranges cabana_boy	by Gaurav[_2_]	5	391
count if column A is 1-2 and column B is 03/02/08 to 03/09/08 bokey	by Peo Sjoblom	4	379
Copy parts of a data range into a new spreadsheet forest8	by JLatham	4	1,008
text on worksheet with no gridlines Carol	by BoniM	2	406
GETPIVOTDATA function only returns zero's Steven Cheng	by Steven Cheng	0	447
Overtime Calculation for Overtime SilviaG	by joeu2004	4	1,448
multiple range array with ttest erinlm	by erinlm	2	1,533
Matching a column of new data to existing larger data set. Sirjay	by Pete_UK	1	745
tieing copies together dkb43	by Pete_UK	1	407
Sumproduct krandall	by Pete_UK	1	284
how to format a worksheet to tab through a series of check boxes? charvel	by charvel	0	524
Need help creating a formula that will auto post amts when marked. Cindy E.	by Mike	1	541
Need help with formular on excel 2007 Buzz Local#30	by Pete_UK	3	559
adding the qty's of products from several worksheets. Steve	by ryguy7272	3	378
Remove Merge and Center for entire spreadsheet JE	by ryguy7272	3	3,143
HLOOKUP across two spreadsheets Beverly Darvill	by Beverly Darvill[_2_]	3	1,118
SUMIF from multiple files Unda	by David Biddulph[_2_]	3	416