Excel Worksheet Functions - Page 1017

Thread / Thread Starter	Last Post	Replies	Views
What If Scenario and/or Pivot Table eightandup	by eightandup	0	598
DSUM using alpha numeric codes brian	by brian	1	702
IF formula & formatting rh33a	by Fred Smith[_4_]	3	486
Woman age 40 Tony_student	by Tony_student[_2_]	6	544
Merge 2 datasheets into single Pivot Table. free_ur_mind	by Eduardo	2	2,508
Array formulas Lynda	by Shane Devenshire[_2_]	3	780
How do I get Excel to display a table on a different worksheet? John	by Stefi	6	1,121
Track Changes Kanmi	by Kanmi	0	421
How do I freeze individual cells with formulas in them Robernaut	by Eduardo	2	3,756
Turn of 'Read Only' Barb	by Barb	2	649
Check for CAPS Heidi	by Heidi	3	572
count value dependent on unique or repeated values in another colu singing_inmysleep	by RagDyeR	2	813
Merge two columns of data with a condition Richard	by Sam Wilson	1	1,090
i need some help in a type Vatos	by Shane Devenshire[_2_]	2	398
Copying Worksheets which contain Named Ranges Terry Bennett	by Terry Bennett	0	625
Extracting email address from various data Wade	by Jacob Skaria	2	438
Woman age 40 Tony_student	by JLatham	9	531
Sorting Coloumns that are Formula's heritage1450	by Eduardo	1	402
how to make a preforated page-break insert KoldKream	by Gord Dibben	2	419
how to use vlookup for more than 1line LHM	by LHM	3	584
Conditional Count Formula Mully	by T. Valko	3	620
Using tab key in protected worksheet bev	by bev	4	1,422
lookup issue.... John	by Gord Dibben	2	428
forgoten password Leon	by Hans Terkelsen	4	412
Excel Comments lisa	by lisa	5	766
Automatic Cell Copy to other worksheets sharice.g	by Ron de Bruin	1	427
Cycle Times PAL	by PAL	4	481
SUMPRODUCT not working. Gaurav[_4_]	by Gord Dibben	2	525
Replace hard return with a delimiter? Erin.	by Ethan Strauss	3	1,640
How do I subtotal specific / random rows from a spreadsheet? Duke Bond	by Tom Hutchins	1	1,067
Comparing two ranges and get true or false in one cell depending onresult Leon[_2_]	by Leon[_2_]	3	772
adding text to the end of a formula Lodge	by Jim Cone[_2_]	1	564
FAQ : Answers to show in another cell gwtechie72	by FatBytestard	4	414
VB CODE Kanmi	by Jacob Skaria	7	477
If blank cell, copy information from cell above Oceangate	by Ashish Mathur[_2_]	5	3,274
Want to split 922 037 022 into 3cols and recombine without spaces Confused	by Jacob Skaria	4	544
Relative Worksheet references mjb1	by mjb1	4	650
Doing multiple borders Herb[_2_]	by Shane Devenshire[_2_]	1	485
Isolate UNIQUE combination of Z cells from a range N that adds up alex	by Sam Wilson	3	515
Worksheet protection ssdsibes	by FatBytestard	1	403
excel - outlines meghnal	by meghnal	4	584
How do I get a new calculated date from different date ranges? Ann LeBlanc	by Mike H	3	678
Keeping the selected font when creating charts in Excel 2007 Lars	by Bernard Liengme[_3_]	1	487
need complex if formula (I think) b4nature	by Bernd P	3	526
Iserror for an array diepvic	by diepvic	8	3,091
ACCRUED INTEREST (ACCRINT) Bug Keith	by Keith	2	1,112
Pivot Table Percent Question mark	by mark	4	906
VLOOKUP Kanmi	by Max	3	388
CONDITIONAL FORMATING FORMULA Kanmi	by Kanmi	6	397
VLookup formula question Tim at alliant	by Tim at alliant	2	384
AUTOMATIC CHANGES HIGHLIGHTING Kanmi	by Kanmi	0	390
Excel2007 Conditional Formatting Slow Performance Issue Michael F	by Bassman62	1	1,617
Sorting Dates by Month and Day only John P[_2_]	by Mike H	6	1,406
tracking inventory Jackie	by Ken	6	611
Assigning a number value to strings JRD	by JLatham	1	496
Duplication of string values within a range JRD	by Ron Rosenfeld	4	431
Conditional =CONCATENATE formula Bullocks	by Bullocks	2	1,384
Adding 2 columns together on 1 worksheet with sum on other. CE	by Mike H	3	487
CAn IF compare two cells? KevinS	by Mike H	1	617
Excel 2007 - Developer tab - xml import/export functions biz7	by biz7	1	1,688
How do I create IF function that inserts cells when condition is m jmsith	by Bernard Liengme[_3_]	1	505
Can I replace data in all sheets in a workbook at the same time? LynetteB	by Meenie	2	458
Can I insert in a cell the "date revised" (in a worksheet,etc) WendyT	by Gord Dibben	1	508
Can't get my xlSheetVeryHidden cristine	by cristine	2	760
Averaging data from a range calculated using cell reference number Feolet20	by Bernard Liengme[_3_]	3	578
Histogram Function iperlovsky	by Mike Middleton[_2_]	2	901
Odd problem with formula counting Yes and No Meenie	by Ken	5	541
Extracting Rows based on a number in a field Yookaroo	by Herbert Seidenberg	2	471
Zero's PAL	by Fred Smith[_4_]	3	430
MISSING PARENTHESIS Kanmi	by Fred Smith[_4_]	3	1,264
Macro?? Connie Martin	by Don Guillett	24	1,935
Excel Functions - IF? LaDonna Brooks	by MyVeryOwnSelf[_2_]	3	415
Date-time updates every cell? Penny Miller	by MyVeryOwnSelf[_2_]	3	644
Copyin the greater than 15 days project rows from one sheet to ano Max	by Max	3	513
trouble with calculating wages to hours worked skylar0605	by T. Valko	3	719