Excel Worksheet Functions - Page 154

Thread / Thread Starter	Last Post	Replies	Views
Indirect/match formula - array al	by smartin	1	1,077
parsing a full name out into Last, First, Middle Craig	by Ron Rosenfeld	2	2,762
Mail sheet template for Excel 2007 and 2010 Steved	by Steved	1	994
Average of Years employed SGee	by T. Valko	5	3,855
How do I protect cells or a range of cells in excel spreadsheet? Abundance	by Rajesh Mehmi	1	498
Help with SUMIF formula Iriemon	by RagDyer	3	377
Ok how about this formula using days :-/ Excel ??[_2_]	by Niek Otten	1	413
Saving sheet data to another sheet automatically John Aikin	by Per Jessen	7	608
State names into abbreviations jennie	by Lars-Åke Aspelin[_2_]	2	2,491
countif with 2 criteria tpeter	by Mike H	4	443
consolidate multiple worksheets se7098	by Ron de Bruin	13	1,280
I need Help with a count cell text formula Excel ??[_2_]	by RagDyer	4	416
Differenec formula: Dnt need '0' as a result;Rather have a blank c Rum	by Gord Dibben	4	386
Count Number of occurences of several texts in a range of cells kbeirne	by Mike H	3	463
trim everything from left of first underscore in the text? Mitchell_Collen via OfficeKB.com	by Mitchell_Collen via OfficeKB.com	4	3,303
Vlookup for a max value ? Steve	by Steve	4	1,477
Range Tara	by Gord Dibben	1	525
Go To Button on a spreadsheet. Bob[_16_]	by Mike H	1	402
CF help please j5b9721	by j5b9721	0	407
Help with MAX / MIN formula (I think) Mark D	by T. Valko	13	1,101
Complicated Lookup Trefor	by Trefor	13	1,071
Can you save each sheet in a workbook separately? Angela	by Ron de Bruin	2	1,388
Getting the out put from different cells EBnLP01	by EBnLP01	4	649
how do I convert sq. meters to hectares in a batch 1bigfokker	by David Biddulph[_2_]	3	5,879
Excel and Citrix fragmentation question TKM	by TKM	0	478
Countif contains a word in a reference cell Go Bucks!!![_2_]	by RagDyeR	3	1,887
Display text source in multiple sheets Nic Daniels	by Luke M	1	504
count if the cell contains a word found in another cell Go Bucks!!![_2_]	by Go Bucks!!![_2_]	2	1,832
Validation Against another Cell Stacy C[_2_]	by Luke M	2	465
How do you make Data move into another cell?? Kyrie	by Don Guillett	4	419
reference cells on one tab by value of cell on other tab buscher75	by buscher75	5	990
Conditional formatting using text and exceptions Nic Daniels	by Nic Daniels	4	3,050
Unhide column if range of cells contain data wizardmalcolm	by wizardmalcolm	0	392
Send keys from command button sunspot27	by sunspot27	0	533
Conditional Sum function does recognise % Geoff Newham	by Geoff Newham	2	463
Auto expanding charts Martin	by Martin	3	951
Formula Jules	by FSt1	1	484
customized toolbar issue Tami	by Bernie Deitrick	1	527
Calculate the first monday of a month in the future or in the past Morocco Mole	by Ron Rosenfeld	4	3,295
How to write a formulae Jules	by Max	2	495
Formula Pete_UK	by Pete_UK	0	413
How to calculate the number of Workdays for irregular work pattern Angelaf	by Chip Pearson	1	608
Average Function Stacy C[_2_]	by Stacy C[_2_]	2	356
my data is bundled. how do I isolate in separate cells? ExcelED	by Stacy C[_2_]	1	489
Calculate workdays for irregular work patterns Angelaf	by Niek Otten	1	727
CC130 Hercules Payload Distribution and Wt and Balance Loadmaster	by T. Valko	2	554
how to add comment in cell using excel 2007 esto bear	by esto bear[_2_]	4	503
References to external workbooks Preston	by Preston	4	675
Use multiple criteria with COUNTIF: between dates and not blank l.shields	by T. Valko	13	3,037
Validation Sum Stacy C[_2_]	by T. Valko	7	486
Tracking Active Projects Slim	by Glenn	1	554
How to calculate dates Pat	by David Biddulph[_2_]	6	615
Can I unstack multiple spread sheets in Windows XP? Jocelyn[_2_]	by RagDyeR	1	1,813
Counting using data from 2 columns darbs	by Eduardo	14	1,204
Neative Formula jen	by macoute	6	516
find and delte duplicates Nick	by Bernard Liengme[_3_]	2	474
Using Networkdays with negative numbers VainDM	by Rich/rerat	4	1,595
Formular for refrencing two referances steve clarke	by steve clarke	3	574
Find numbers in a range that sum up to a specified number Cheryl Elizabeth	by Max	6	1,310
Return a Value in Vlookup Q Seanie	by Max	3	569
Format duration in mm/dd hh:mm Malkowiak.work	by Malkowiak.work	4	764
file path displays incorrectly TinaB	by TinaB	0	446
what is the wrong? rajaiy	by rajaiy	0	496
App activate issue sunspot27	by sunspot27	0	488
Formula using data from 3 separate columns MSW Intern	by Francis	2	455
How do you get excel to spell out the amount (ie $5.55 = five dol. Elvira	by Taurien	3	754
Rounding Maxine	by Francis	2	464
Help with Editing VB (a really beginner question) nadhra	by Simon Lloyd[_339_]	3	405
save as , and dellete botton after saving one page. rajaiy	by rajaiy	0	500
Selecting random names from lists Jim	by Max	1	673
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 mh	by Ashish Mathur[_2_]	5	3,349
IF Statement Deano	by Bernard Liengme[_3_]	6	463
Hlookup row 5 Clinton	by barry houdini[_13_]	1	517
How do I chg the text size in my validation drop down box? tmeloff	by Colin	11	2,225
Summing +30 Non-adjacent cells Stacy C[_2_]	by Stacy C[_2_]	5	525