Excel Worksheet Functions - Page 154

Thread / Thread Starter	Last Post	Replies	Views
Indirect/match formula - array al	by smartin	1	1,093
parsing a full name out into Last, First, Middle Craig	by Ron Rosenfeld	2	2,862
Mail sheet template for Excel 2007 and 2010 Steved	by Steved	1	1,017
Average of Years employed SGee	by T. Valko	5	3,896
How do I protect cells or a range of cells in excel spreadsheet? Abundance	by Rajesh Mehmi	1	519
Help with SUMIF formula Iriemon	by RagDyer	3	381
Ok how about this formula using days :-/ Excel ??[_2_]	by Niek Otten	1	436
Saving sheet data to another sheet automatically John Aikin	by Per Jessen	7	636
State names into abbreviations jennie	by Lars-Åke Aspelin[_2_]	2	2,557
countif with 2 criteria tpeter	by Mike H	4	460
consolidate multiple worksheets se7098	by Ron de Bruin	13	1,296
I need Help with a count cell text formula Excel ??[_2_]	by RagDyer	4	428
Differenec formula: Dnt need '0' as a result;Rather have a blank c Rum	by Gord Dibben	4	402
Count Number of occurences of several texts in a range of cells kbeirne	by Mike H	3	483
trim everything from left of first underscore in the text? Mitchell_Collen via OfficeKB.com	by Mitchell_Collen via OfficeKB.com	4	3,327
Vlookup for a max value ? Steve	by Steve	4	1,523
Range Tara	by Gord Dibben	1	533
Go To Button on a spreadsheet. Bob[_16_]	by Mike H	1	425
CF help please j5b9721	by j5b9721	0	428
Help with MAX / MIN formula (I think) Mark D	by T. Valko	13	1,119
Complicated Lookup Trefor	by Trefor	13	1,087
Can you save each sheet in a workbook separately? Angela	by Ron de Bruin	2	1,394
Getting the out put from different cells EBnLP01	by EBnLP01	4	654
how do I convert sq. meters to hectares in a batch 1bigfokker	by David Biddulph[_2_]	3	5,989
Excel and Citrix fragmentation question TKM	by TKM	0	509
Countif contains a word in a reference cell Go Bucks!!![_2_]	by RagDyeR	3	1,911
Display text source in multiple sheets Nic Daniels	by Luke M	1	519
count if the cell contains a word found in another cell Go Bucks!!![_2_]	by Go Bucks!!![_2_]	2	1,852
Validation Against another Cell Stacy C[_2_]	by Luke M	2	503
How do you make Data move into another cell?? Kyrie	by Don Guillett	4	450
reference cells on one tab by value of cell on other tab buscher75	by buscher75	5	1,001
Conditional formatting using text and exceptions Nic Daniels	by Nic Daniels	4	3,100
Unhide column if range of cells contain data wizardmalcolm	by wizardmalcolm	0	416
Send keys from command button sunspot27	by sunspot27	0	580
Conditional Sum function does recognise % Geoff Newham	by Geoff Newham	2	474
Auto expanding charts Martin	by Martin	3	969
Formula Jules	by FSt1	1	490
customized toolbar issue Tami	by Bernie Deitrick	1	547
Calculate the first monday of a month in the future or in the past Morocco Mole	by Ron Rosenfeld	4	3,321
How to write a formulae Jules	by Max	2	516
Formula Pete_UK	by Pete_UK	0	420
How to calculate the number of Workdays for irregular work pattern Angelaf	by Chip Pearson	1	616
Average Function Stacy C[_2_]	by Stacy C[_2_]	2	359
my data is bundled. how do I isolate in separate cells? ExcelED	by Stacy C[_2_]	1	505
Calculate workdays for irregular work patterns Angelaf	by Niek Otten	1	745
CC130 Hercules Payload Distribution and Wt and Balance Loadmaster	by T. Valko	2	562
how to add comment in cell using excel 2007 esto bear	by esto bear[_2_]	4	534
References to external workbooks Preston	by Preston	4	689
Use multiple criteria with COUNTIF: between dates and not blank l.shields	by T. Valko	13	3,089
Validation Sum Stacy C[_2_]	by T. Valko	7	490
Tracking Active Projects Slim	by Glenn	1	562
How to calculate dates Pat	by David Biddulph[_2_]	6	664
Can I unstack multiple spread sheets in Windows XP? Jocelyn[_2_]	by RagDyeR	1	1,840
Counting using data from 2 columns darbs	by Eduardo	14	1,215
Neative Formula jen	by macoute	6	539
find and delte duplicates Nick	by Bernard Liengme[_3_]	2	491
Using Networkdays with negative numbers VainDM	by Rich/rerat	4	1,611
Formular for refrencing two referances steve clarke	by steve clarke	3	595
Find numbers in a range that sum up to a specified number Cheryl Elizabeth	by Max	6	1,338
Return a Value in Vlookup Q Seanie	by Max	3	586
Format duration in mm/dd hh:mm Malkowiak.work	by Malkowiak.work	4	784
file path displays incorrectly TinaB	by TinaB	0	458
what is the wrong? rajaiy	by rajaiy	0	513
App activate issue sunspot27	by sunspot27	0	511
Formula using data from 3 separate columns MSW Intern	by Francis	2	472
How do you get excel to spell out the amount (ie $5.55 = five dol. Elvira	by Taurien	3	771
Rounding Maxine	by Francis	2	524
Help with Editing VB (a really beginner question) nadhra	by Simon Lloyd[_339_]	3	430
save as , and dellete botton after saving one page. rajaiy	by rajaiy	0	513
Selecting random names from lists Jim	by Max	1	683
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 mh	by Ashish Mathur[_2_]	5	3,425
IF Statement Deano	by Bernard Liengme[_3_]	6	479
Hlookup row 5 Clinton	by barry houdini[_13_]	1	528
How do I chg the text size in my validation drop down box? tmeloff	by Colin	11	2,277
Summing +30 Non-adjacent cells Stacy C[_2_]	by Stacy C[_2_]	5	542