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	736
drop down list in Excel B9	by Debra Dalgleish	2	904
DateDif problem Annie	by Ron Rosenfeld	3	600
Dropdown list with named cells WaterDog	by Rowan Drummond	1	848
Condense formula Derek Y via OfficeKB.com	by bpeltzer	9	658
Identifying #N/A cells Lee Harris	by tjtjjtjt	1	508
Cascade Validation matelot	by matelot	3	652
tagging / tracing / referencing duplicate values jonpdavies	by jonpdavies	0	445
Place a "" around ALL values in a cell Phil	by Dave Peterson	7	669
Can I do this? Steven Sinclair	by Dave Peterson	9	437
Referencing cell in another sheet yields null? [email protected]	by [email protected]	4	761
countif and concatenate JP Long	by Harlan Grove	4	1,646
Financial Functions Hague2	by [email protected]	6	682
IF Function to test formula in a cell Fred Holmes	by Don Guillett	5	856
getting active cell value in another cell amrezzat	by Paul B	1	327
Using worksheet functions in macros in Excel2000 clippan	by Bob Phillips	1	505
Formulas KenNZ	by KenNZ	2	283
Conditional Formatting Ian.UK	by Rowan Drummond	6	332
problem with FIND cjsmith22	by Rowan Drummond	3	546
function to insert a picture movermike	by movermike	2	545
drop down box in cell cdeldegan	by Sandy	1	291
colour due to conditional formatting & hyperlink/shortcut to a directory Peter STEVENS	by Gord Dibben	1	719
Count nonblank cells with multiple criteria Daniel	by Bob Phillips	5	1,181
How do I fix a link pinetown83	by pinetown83	0	425
In excel, how can i delete 1 digit and the decimal point? rjtees	by Biff	1	752
Lookup values in one column to return another [email protected]	by [email protected]	4	1,892
Mode between two serial dates/times ChrisM	by Biff	1	379
If ? maybe..... Pete	by Biff	5	347
Validation Help nicolebelle	by nicolebelle	8	476
Delete first two digits in column rjtees	by rjtees	4	1,418
Count if a number is between X and Y WBTKbeezy	by bpeltzer	3	1,451
Reference Cell Content Sloth	by Harlan Grove	1	505
how do I calculate a monthly payment based on a variable rate? Chick N Egg	by bpeltzer	1	943
Conditional Formatting Kimberly5590	by Gord Dibben	5	367
Seperation of prime and sub inventory units Novice	by Kleev	1	583
search for text within text BigDave	by bobwhite	2	521
Automatic Date Update Jmoore	by Gord Dibben	1	539
why does sorting large columns create errors in top selection? Mitch	by MDBCT	1	656
Count According to Date Lori	by Bob Phillips	1	557
Refresh Button Iguss	by Iguss	0	442
Protection of worksheet / merging Cells dtmd	by Olivia Trimble	1	554
find all combinations of cells that add up to certain number AD	by Duke Carey	1	2,133
comparing columns ~Q	by Kleev	1	606
SUMIF 2 conditions are met??? Granger	by Granger	3	1,063
Combine 2 formulasinto 1. Steved	by Steved	2	323
multiple Lookup shaj	by shaj	2	404
Date from text to Date format Nise	by Gord Dibben	6	493
Checking a number of sheets sphenisc	by Domenic	1	476
Return Array with Array Brad	by Brad	10	1,414
Problem with random inputs jtreme	by Gary''s Student	1	406
import with locked cells? Robert	by Robert	0	357
How do I copy comments into cells SeanCrown	by Gord Dibben	2	594
IF formula dtmd	by goober	4	339
separate name and address Aaron	by Aaron	4	1,216
How can you add an "&" in a footer? Christina_0123	by Gord Dibben	3	304
How do I highlight duplicate data on a spreadsheet? Grim72	by Gord Dibben	2	556
Converting numbers to text Chrisj20	by Gord Dibben	2	415
Use Index to get range Adella	by Adella	4	454
averging prices real problem amrezzat	by Roger Govier	6	424
How can I globally set "error message" parameters in Excel Evansct	by Evansct	5	448
Formula Workdays-Holidays-adjustments Glenna	by Glenna	4	485
How do I convert hours and mins into just minutes in excel? Jsmith5663	by Nise	1	403
how can i ignore blank cells when multiple cells? arash	by Dave Peterson	4	1,097
help on lookup functions Kesqsay	by Ian	1	467
Lock cell entry Sprankler	by Bernie Deitrick	1	753
DEMMAGE FILE SHAHZAIB ISMAIL	by Don Guillett	1	403
Return entry in column above/below cell TheRobsterUK	by TheRobsterUK	2	758
Search for record with specific name in a cell pomalley	by pomalley	2	585
SUMIF question (I think) Barb Reinhardt	by Barb Reinhardt	1	573
How can I automate something to be added to a formula in excel? Reepicheep	by Anne Troy	1	415
Dates in Excel Fat Doris	by Ron Rosenfeld	1	384
Inserting graphics in protected worksheets HRMSN	by HRMSN	0	399
hyperlink changes when doc emailed Jane	by David McRitchie	1	481
Vlookup and forecast vijaya	by David McRitchie	1	598
Formulas Chrisj20	by David McRitchie	3	297