Excel Worksheet Functions - Page 154

Thread / Thread Starter	Last Post	Replies	Views
Indirect/match formula - array al	by smartin	1	1,083
parsing a full name out into Last, First, Middle Craig	by Ron Rosenfeld	2	2,784
Mail sheet template for Excel 2007 and 2010 Steved	by Steved	1	1,011
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	508
Help with SUMIF formula Iriemon	by RagDyer	3	381
Ok how about this formula using days :-/ Excel ??[_2_]	by Niek Otten	1	426
Saving sheet data to another sheet automatically John Aikin	by Per Jessen	7	627
State names into abbreviations jennie	by Lars-Åke Aspelin[_2_]	2	2,550
countif with 2 criteria tpeter	by Mike H	4	453
consolidate multiple worksheets se7098	by Ron de Bruin	13	1,293
I need Help with a count cell text formula Excel ??[_2_]	by RagDyer	4	425
Differenec formula: Dnt need '0' as a result;Rather have a blank c Rum	by Gord Dibben	4	399
Count Number of occurences of several texts in a range of cells kbeirne	by Mike H	3	475
trim everything from left of first underscore in the text? Mitchell_Collen via OfficeKB.com	by Mitchell_Collen via OfficeKB.com	4	3,316
Vlookup for a max value ? Steve	by Steve	4	1,516
Range Tara	by Gord Dibben	1	532
Go To Button on a spreadsheet. Bob[_16_]	by Mike H	1	411
CF help please j5b9721	by j5b9721	0	424
Help with MAX / MIN formula (I think) Mark D	by T. Valko	13	1,117
Complicated Lookup Trefor	by Trefor	13	1,084
Can you save each sheet in a workbook separately? Angela	by Ron de Bruin	2	1,392
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	498
Countif contains a word in a reference cell Go Bucks!!![_2_]	by RagDyeR	3	1,903
Display text source in multiple sheets Nic Daniels	by Luke M	1	510
count if the cell contains a word found in another cell Go Bucks!!![_2_]	by Go Bucks!!![_2_]	2	1,847
Validation Against another Cell Stacy C[_2_]	by Luke M	2	501
How do you make Data move into another cell?? Kyrie	by Don Guillett	4	436
reference cells on one tab by value of cell on other tab buscher75	by buscher75	5	999
Conditional formatting using text and exceptions Nic Daniels	by Nic Daniels	4	3,087
Unhide column if range of cells contain data wizardmalcolm	by wizardmalcolm	0	405
Send keys from command button sunspot27	by sunspot27	0	565
Conditional Sum function does recognise % Geoff Newham	by Geoff Newham	2	473
Auto expanding charts Martin	by Martin	3	964
Formula Jules	by FSt1	1	488
customized toolbar issue Tami	by Bernie Deitrick	1	540
Calculate the first monday of a month in the future or in the past Morocco Mole	by Ron Rosenfeld	4	3,318
How to write a formulae Jules	by Max	2	505
Formula Pete_UK	by Pete_UK	0	418
How to calculate the number of Workdays for irregular work pattern Angelaf	by Chip Pearson	1	615
Average Function Stacy C[_2_]	by Stacy C[_2_]	2	358
my data is bundled. how do I isolate in separate cells? ExcelED	by Stacy C[_2_]	1	503
Calculate workdays for irregular work patterns Angelaf	by Niek Otten	1	744
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	522
References to external workbooks Preston	by Preston	4	684
Use multiple criteria with COUNTIF: between dates and not blank l.shields	by T. Valko	13	3,077
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	654
Can I unstack multiple spread sheets in Windows XP? Jocelyn[_2_]	by RagDyeR	1	1,832
Counting using data from 2 columns darbs	by Eduardo	14	1,210
Neative Formula jen	by macoute	6	534
find and delte duplicates Nick	by Bernard Liengme[_3_]	2	482
Using Networkdays with negative numbers VainDM	by Rich/rerat	4	1,602
Formular for refrencing two referances steve clarke	by steve clarke	3	583
Find numbers in a range that sum up to a specified number Cheryl Elizabeth	by Max	6	1,323
Return a Value in Vlookup Q Seanie	by Max	3	582
Format duration in mm/dd hh:mm Malkowiak.work	by Malkowiak.work	4	780
file path displays incorrectly TinaB	by TinaB	0	457
what is the wrong? rajaiy	by rajaiy	0	504
App activate issue sunspot27	by sunspot27	0	500
Formula using data from 3 separate columns MSW Intern	by Francis	2	459
How do you get excel to spell out the amount (ie $5.55 = five dol. Elvira	by Taurien	3	765
Rounding Maxine	by Francis	2	513
Help with Editing VB (a really beginner question) nadhra	by Simon Lloyd[_339_]	3	421
save as , and dellete botton after saving one page. rajaiy	by rajaiy	0	510
Selecting random names from lists Jim	by Max	1	677
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 mh	by Ashish Mathur[_2_]	5	3,417
IF Statement Deano	by Bernard Liengme[_3_]	6	476
Hlookup row 5 Clinton	by barry houdini[_13_]	1	524
How do I chg the text size in my validation drop down box? tmeloff	by Colin	11	2,250
Summing +30 Non-adjacent cells Stacy C[_2_]	by Stacy C[_2_]	5	536