Excel Worksheet Functions - Page 123

Thread / Thread Starter	Last Post	Replies	Views
Custom Function Spencer Hutton	by Gord Dibben	2	785
Counting Entries Jimbo	by zackb	6	584
Enable hyperlinks Thermometer	by Gary Brown	3	415
a way to limit the characters allowed in a cell? EmRit24	by Per Erik Midtrød	3	815
Formula Problem - If Statement Margie	by Margie	4	871
Vlookup for part of a word jenhow	by Harlan Grove	7	1,228
excel macros cleve mc daniel	by Harald Staff	5	431
IRR data in different ranges GaryF	by SongBear	6	767
redistribute a column by a groups of rows Bill Davis	by Per Erik Midtrød	1	778
Calculating Overtime from Hours total Dreamweavn via OfficeKB.com	by Dreamweavn via OfficeKB.com	6	1,393
Drop down text too small James	by Paul B	1	495
Does excel have a 'cubed root' function? How can it work it out? Di in Oz	by Bob Phillips	1	1,306
Concatenation using IF AND - Possible? Col	by Col	3	486
Match a name to all clients? Dixie	by Peo Sjoblom	3	451
If function with blank cells Walter	by JulieD	5	513
SUMIF help needed Walter	by JulieD	9	599
CORRELATION / COVARIANCE MATRIX Walker	by Harlan Grove	1	1,899
buttons & macros Jock W	by Jock W	4	469
SUMIF(O18:O500,"=b21"Q18:Q5) i want to do this not "=001690" steve alcock	by William	1	335
How do i create a command button or macro to exit Microsoft Excel raj	by Paul B	1	755
Lookup cell contents in on sheet based on a formula in second sheet Michael Wright via OfficeKB.com	by Vasant Nanavati	1	885
I made a terrible mistake and need help Ray	by Bob Phillips	8	349
sumif? lookup? Duane	by Aladin Akyurek	3	528
Matching cells Sibbs	by RagDyeR	2	432
Auto Date Fill-in Dreamweavn via OfficeKB.com	by Lyali	2	476
Auto Date Lyali	by Peo Sjoblom	3	331
data fill question justinhill18	by justinhill18	3	584
How do I set the order of calculation of Data Tables in Excel? Charles Easton	by David McRitchie	1	1,273
Referencing a formula (as text) Nelson	by Nelson	3	460
Average of ... Tudor	by JulieD	8	404
Default comment location rlybarra	by David McRitchie	2	1,004
cell drop and drag D Snider	by Peo Sjoblom	1	766
Lookup baseball scores in 1 worksheet and have them display in ano Oceanverd	by Biff	3	719
How do I enter formula using % > or < = number? Candace	by SongBear	3	544
Sum Formula Kanga 85	by Max	4	339
scenario analysis-multiple variables joshjap	by Franz	3	756
excel function Roelamp	by Don Guillett	4	332
datafeeds Dchaney Indianapolis	by Dchaney Indianapolis	0	451
Add mailto (email) as function to a button in excel yagzzy	by Alan	1	2,422
Conditional format Sibbs	by Don Guillett	5	337
How do I get 1 cell calculate only if another cell has an "x" Rochelle B	by Don Guillett	10	683
question on excel Solver Avalon	by Vasant Nanavati	1	752
How can I convert entire columns of text to Uppercase in Excel? dplantlady	by David McRitchie	8	698
I want to sort everything but my validation list Steve	by Dave Peterson	5	483
Sheet Tab Names Bob G	by Bg	10	956
How do I insert A drop down dialog box as a 'list to choose from'? Rochelle B	by Rochelle B	2	909
Add to my Function / formula Roelamp	by Roelamp	0	571
How can I choose top two numbers in a column? Doug	by Ken Wright	3	802
Merge, update, and add only new entries into a list from other she Chab	by Debra Dalgleish	1	767
How do I make a sound as a result of an "if" statement in excel george	by Debra Dalgleish	1	420
enter a time into a cell, have the cell show two times the entry johnp	by johnp	3	977
Remove Numbers from text David	by David McRitchie	6	1,110
How do I nest these 3 IF functions? Rochelle B	by Rochelle B	4	707
Create a sheet name, won't let me, says already sheet named that Buckwheat	by Vasant Nanavati	7	1,072
How do you add sound file to a cell in excel Martin	by Vasant Nanavati	9	1,382
How to create specific formula STS	by STS	4	1,304
count the number of times data appears on the same row from two c. GavT9	by Max	1	633
Referencing a newly created worksheet Charyn	by Charyn	2	1,130
Data Validation - Custom - Formula DYeomans	by DYeomans	2	597
Using EXACT to Deduplicate Darrell Halverson via OfficeKB.com	by Darrell Halverson via OfficeKB.com	4	601
Can I format a cell to fill red when clicked with mouse (Excel)? mike.wilson	by mike wilson	4	881
Convert PivotTable data into a worksheet list sansk_23	by sansk_23	3	1,578
Parameter description Davids	by Bob Phillips	1	742
Using If function Antony Peter	by Bob Phillips	2	351
how i can call the function reneabesmer	by Bob Phillips	2	525
Lookup Help aeast50 - ExcelForums.com	by Dave Peterson	3	358
Inserting Columns and Formulas updating Jaime Balance Sheet	by Gary Brown	1	524
unique occurences in list Chandler	by Chandler	3	522
unique occurences in list Chandler	by Chandler	2	557
Can distance be calculated using latitude and longitude? Paxton	by Vasant Nanavati	1	1,213
Subtotal excl errors Rob	by Rob	2	902
RTD Problem Vlad Zelenko	by Vlad Zelenko	1	355
How do I add the sum of a series numbers generated by Rnd gen? RandomProblems	by RandomProblems	4	412
how to calculate number ranges Lori	by Lori	2	651
Emulate Index/Match combo function w/ VBA custom function Spencer Hutton	by Niek Otten	2	4,978