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,858
Mail sheet template for Excel 2007 and 2010 Steved	by Steved	1	1,013
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	509
Help with SUMIF formula Iriemon	by RagDyer	3	381
Ok how about this formula using days :-/ Excel ??[_2_]	by Niek Otten	1	427
Saving sheet data to another sheet automatically John Aikin	by Per Jessen	7	628
State names into abbreviations jennie	by Lars-Åke Aspelin[_2_]	2	2,555
countif with 2 criteria tpeter	by Mike H	4	455
consolidate multiple worksheets se7098	by Ron de Bruin	13	1,295
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	399
Count Number of occurences of several texts in a range of cells kbeirne	by Mike H	3	476
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,522
Range Tara	by Gord Dibben	1	533
Go To Button on a spreadsheet. Bob[_16_]	by Mike H	1	412
CF help please j5b9721	by j5b9721	0	427
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	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	511
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	503
How do you make Data move into another cell?? Kyrie	by Don Guillett	4	439
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,093
Unhide column if range of cells contain data wizardmalcolm	by wizardmalcolm	0	405
Send keys from command button sunspot27	by sunspot27	0	570
Conditional Sum function does recognise % Geoff Newham	by Geoff Newham	2	474
Auto expanding charts Martin	by Martin	3	965
Formula Jules	by FSt1	1	489
customized toolbar issue Tami	by Bernie Deitrick	1	545
Calculate the first monday of a month in the future or in the past Morocco Mole	by Ron Rosenfeld	4	3,319
How to write a formulae Jules	by Max	2	507
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	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	524
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,079
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	655
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,213
Neative Formula jen	by macoute	6	534
find and delte duplicates Nick	by Bernard Liengme[_3_]	2	484
Using Networkdays with negative numbers VainDM	by Rich/rerat	4	1,603
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,330
Return a Value in Vlookup Q Seanie	by Max	3	585
Format duration in mm/dd hh:mm Malkowiak.work	by Malkowiak.work	4	781
file path displays incorrectly TinaB	by TinaB	0	458
what is the wrong? rajaiy	by rajaiy	0	505
App activate issue sunspot27	by sunspot27	0	501
Formula using data from 3 separate columns MSW Intern	by Francis	2	461
How do you get excel to spell out the amount (ie $5.55 = five dol. Elvira	by Taurien	3	770
Rounding Maxine	by Francis	2	514
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	513
Selecting random names from lists Jim	by Max	1	678
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 mh	by Ashish Mathur[_2_]	5	3,420
IF Statement Deano	by Bernard Liengme[_3_]	6	478
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,268
Summing +30 Non-adjacent cells Stacy C[_2_]	by Stacy C[_2_]	5	539