Excel Worksheet Functions - Page 123

Thread / Thread Starter	Last Post	Replies	Views
Custom Function Spencer Hutton	by Gord Dibben	2	792
Counting Entries Jimbo	by zackb	6	590
Enable hyperlinks Thermometer	by Gary Brown	3	421
a way to limit the characters allowed in a cell? EmRit24	by Per Erik Midtrød	3	837
Formula Problem - If Statement Margie	by Margie	4	881
Vlookup for part of a word jenhow	by Harlan Grove	7	1,236
excel macros cleve mc daniel	by Harald Staff	5	433
IRR data in different ranges GaryF	by SongBear	6	776
redistribute a column by a groups of rows Bill Davis	by Per Erik Midtrød	1	784
Calculating Overtime from Hours total Dreamweavn via OfficeKB.com	by Dreamweavn via OfficeKB.com	6	1,437
Drop down text too small James	by Paul B	1	501
Does excel have a 'cubed root' function? How can it work it out? Di in Oz	by Bob Phillips	1	1,314
Concatenation using IF AND - Possible? Col	by Col	3	490
Match a name to all clients? Dixie	by Peo Sjoblom	3	457
If function with blank cells Walter	by JulieD	5	520
SUMIF help needed Walter	by JulieD	9	601
CORRELATION / COVARIANCE MATRIX Walker	by Harlan Grove	1	1,907
buttons & macros Jock W	by Jock W	4	470
SUMIF(O18:O500,"=b21"Q18:Q5) i want to do this not "=001690" steve alcock	by William	1	340
How do i create a command button or macro to exit Microsoft Excel raj	by Paul B	1	764
Lookup cell contents in on sheet based on a formula in second sheet Michael Wright via OfficeKB.com	by Vasant Nanavati	1	894
I made a terrible mistake and need help Ray	by Bob Phillips	8	353
sumif? lookup? Duane	by Aladin Akyurek	3	533
Matching cells Sibbs	by RagDyeR	2	432
Auto Date Fill-in Dreamweavn via OfficeKB.com	by Lyali	2	481
Auto Date Lyali	by Peo Sjoblom	3	336
data fill question justinhill18	by justinhill18	3	587
How do I set the order of calculation of Data Tables in Excel? Charles Easton	by David McRitchie	1	1,280
Referencing a formula (as text) Nelson	by Nelson	3	461
Average of ... Tudor	by JulieD	8	406
Default comment location rlybarra	by David McRitchie	2	1,007
cell drop and drag D Snider	by Peo Sjoblom	1	767
Lookup baseball scores in 1 worksheet and have them display in ano Oceanverd	by Biff	3	723
How do I enter formula using % > or < = number? Candace	by SongBear	3	551
Sum Formula Kanga 85	by Max	4	340
scenario analysis-multiple variables joshjap	by Franz	3	758
excel function Roelamp	by Don Guillett	4	333
datafeeds Dchaney Indianapolis	by Dchaney Indianapolis	0	452
Add mailto (email) as function to a button in excel yagzzy	by Alan	1	2,424
Conditional format Sibbs	by Don Guillett	5	338
How do I get 1 cell calculate only if another cell has an "x" Rochelle B	by Don Guillett	10	684
question on excel Solver Avalon	by Vasant Nanavati	1	758
How can I convert entire columns of text to Uppercase in Excel? dplantlady	by David McRitchie	8	703
I want to sort everything but my validation list Steve	by Dave Peterson	5	486
Sheet Tab Names Bob G	by Bg	10	962
How do I insert A drop down dialog box as a 'list to choose from'? Rochelle B	by Rochelle B	2	911
Add to my Function / formula Roelamp	by Roelamp	0	576
How can I choose top two numbers in a column? Doug	by Ken Wright	3	810
Merge, update, and add only new entries into a list from other she Chab	by Debra Dalgleish	1	774
How do I make a sound as a result of an "if" statement in excel george	by Debra Dalgleish	1	424
enter a time into a cell, have the cell show two times the entry johnp	by johnp	3	981
Remove Numbers from text David	by David McRitchie	6	1,111
How do I nest these 3 IF functions? Rochelle B	by Rochelle B	4	722
Create a sheet name, won't let me, says already sheet named that Buckwheat	by Vasant Nanavati	7	1,100
How do you add sound file to a cell in excel Martin	by Vasant Nanavati	9	1,391
How to create specific formula STS	by STS	4	1,306
count the number of times data appears on the same row from two c. GavT9	by Max	1	638
Referencing a newly created worksheet Charyn	by Charyn	2	1,136
Data Validation - Custom - Formula DYeomans	by DYeomans	2	602
Using EXACT to Deduplicate Darrell Halverson via OfficeKB.com	by Darrell Halverson via OfficeKB.com	4	603
Can I format a cell to fill red when clicked with mouse (Excel)? mike.wilson	by mike wilson	4	886
Convert PivotTable data into a worksheet list sansk_23	by sansk_23	3	1,584
Parameter description Davids	by Bob Phillips	1	744
Using If function Antony Peter	by Bob Phillips	2	352
how i can call the function reneabesmer	by Bob Phillips	2	532
Lookup Help aeast50 - ExcelForums.com	by Dave Peterson	3	359
Inserting Columns and Formulas updating Jaime Balance Sheet	by Gary Brown	1	529
unique occurences in list Chandler	by Chandler	3	524
unique occurences in list Chandler	by Chandler	2	561
Can distance be calculated using latitude and longitude? Paxton	by Vasant Nanavati	1	1,221
Subtotal excl errors Rob	by Rob	2	904
RTD Problem Vlad Zelenko	by Vlad Zelenko	1	357
How do I add the sum of a series numbers generated by Rnd gen? RandomProblems	by RandomProblems	4	418
how to calculate number ranges Lori	by Lori	2	658
Emulate Index/Match combo function w/ VBA custom function Spencer Hutton	by Niek Otten	2	4,986