Excel Worksheet Functions - Page 920

Thread / Thread Starter	Last Post	Replies	Views
display words in a formula result in Excel dhollifield	by Rowan Drummond	2	765
drop down list in Excel B9	by Debra Dalgleish	2	927
DateDif problem Annie	by Ron Rosenfeld	3	612
Dropdown list with named cells WaterDog	by Rowan Drummond	1	885
Condense formula Derek Y via OfficeKB.com	by bpeltzer	9	667
Identifying #N/A cells Lee Harris	by tjtjjtjt	1	520
Cascade Validation matelot	by matelot	3	669
tagging / tracing / referencing duplicate values jonpdavies	by jonpdavies	0	453
Place a "" around ALL values in a cell Phil	by Dave Peterson	7	680
Can I do this? Steven Sinclair	by Dave Peterson	9	441
Referencing cell in another sheet yields null? [email protected]	by [email protected]	4	786
countif and concatenate JP Long	by Harlan Grove	4	1,670
Financial Functions Hague2	by [email protected]	6	699
IF Function to test formula in a cell Fred Holmes	by Don Guillett	5	877
getting active cell value in another cell amrezzat	by Paul B	1	330
Using worksheet functions in macros in Excel2000 clippan	by Bob Phillips	1	521
Formulas KenNZ	by KenNZ	2	292
Conditional Formatting Ian.UK	by Rowan Drummond	6	348
problem with FIND cjsmith22	by Rowan Drummond	3	558
function to insert a picture movermike	by movermike	2	555
drop down box in cell cdeldegan	by Sandy	1	295
colour due to conditional formatting & hyperlink/shortcut to a directory Peter STEVENS	by Gord Dibben	1	752
Count nonblank cells with multiple criteria Daniel	by Bob Phillips	5	1,200
How do I fix a link pinetown83	by pinetown83	0	428
In excel, how can i delete 1 digit and the decimal point? rjtees	by Biff	1	770
Lookup values in one column to return another [email protected]	by [email protected]	4	1,914
Mode between two serial dates/times ChrisM	by Biff	1	387
If ? maybe..... Pete	by Biff	5	370
Validation Help nicolebelle	by nicolebelle	8	481
Delete first two digits in column rjtees	by rjtees	4	1,439
Count if a number is between X and Y WBTKbeezy	by bpeltzer	3	1,461
Reference Cell Content Sloth	by Harlan Grove	1	530
how do I calculate a monthly payment based on a variable rate? Chick N Egg	by bpeltzer	1	966
Conditional Formatting Kimberly5590	by Gord Dibben	5	377
Seperation of prime and sub inventory units Novice	by Kleev	1	596
search for text within text BigDave	by bobwhite	2	552
Automatic Date Update Jmoore	by Gord Dibben	1	552
why does sorting large columns create errors in top selection? Mitch	by MDBCT	1	683
Count According to Date Lori	by Bob Phillips	1	564
Refresh Button Iguss	by Iguss	0	443
Protection of worksheet / merging Cells dtmd	by Olivia Trimble	1	596
find all combinations of cells that add up to certain number AD	by Duke Carey	1	2,155
comparing columns ~Q	by Kleev	1	626
SUMIF 2 conditions are met??? Granger	by Granger	3	1,071
Combine 2 formulasinto 1. Steved	by Steved	2	325
multiple Lookup shaj	by shaj	2	417
Date from text to Date format Nise	by Gord Dibben	6	508
Checking a number of sheets sphenisc	by Domenic	1	486
Return Array with Array Brad	by Brad	10	1,437
Problem with random inputs jtreme	by Gary''s Student	1	410
import with locked cells? Robert	by Robert	0	363
How do I copy comments into cells SeanCrown	by Gord Dibben	2	610
IF formula dtmd	by goober	4	340
separate name and address Aaron	by Aaron	4	1,225
How can you add an "&" in a footer? Christina_0123	by Gord Dibben	3	306
How do I highlight duplicate data on a spreadsheet? Grim72	by Gord Dibben	2	582
Converting numbers to text Chrisj20	by Gord Dibben	2	428
Use Index to get range Adella	by Adella	4	464
averging prices real problem amrezzat	by Roger Govier	6	436
How can I globally set "error message" parameters in Excel Evansct	by Evansct	5	473
Formula Workdays-Holidays-adjustments Glenna	by Glenna	4	499
How do I convert hours and mins into just minutes in excel? Jsmith5663	by Nise	1	425
how can i ignore blank cells when multiple cells? arash	by Dave Peterson	4	1,145
help on lookup functions Kesqsay	by Ian	1	487
Lock cell entry Sprankler	by Bernie Deitrick	1	767
DEMMAGE FILE SHAHZAIB ISMAIL	by Don Guillett	1	406
Return entry in column above/below cell TheRobsterUK	by TheRobsterUK	2	780
Search for record with specific name in a cell pomalley	by pomalley	2	601
SUMIF question (I think) Barb Reinhardt	by Barb Reinhardt	1	583
How can I automate something to be added to a formula in excel? Reepicheep	by Anne Troy	1	427
Dates in Excel Fat Doris	by Ron Rosenfeld	1	388
Inserting graphics in protected worksheets HRMSN	by HRMSN	0	414
hyperlink changes when doc emailed Jane	by David McRitchie	1	496
Vlookup and forecast vijaya	by David McRitchie	1	615
Formulas Chrisj20	by David McRitchie	3	301