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	766
drop down list in Excel B9	by Debra Dalgleish	2	927
DateDif problem Annie	by Ron Rosenfeld	3	618
Dropdown list with named cells WaterDog	by Rowan Drummond	1	886
Condense formula Derek Y via OfficeKB.com	by bpeltzer	9	668
Identifying #N/A cells Lee Harris	by tjtjjtjt	1	520
Cascade Validation matelot	by matelot	3	679
tagging / tracing / referencing duplicate values jonpdavies	by jonpdavies	0	463
Place a "" around ALL values in a cell Phil	by Dave Peterson	7	680
Can I do this? Steven Sinclair	by Dave Peterson	9	444
Referencing cell in another sheet yields null? [email protected]	by [email protected]	4	796
countif and concatenate JP Long	by Harlan Grove	4	1,681
Financial Functions Hague2	by [email protected]	6	704
IF Function to test formula in a cell Fred Holmes	by Don Guillett	5	884
getting active cell value in another cell amrezzat	by Paul B	1	336
Using worksheet functions in macros in Excel2000 clippan	by Bob Phillips	1	521
Formulas KenNZ	by KenNZ	2	297
Conditional Formatting Ian.UK	by Rowan Drummond	6	349
problem with FIND cjsmith22	by Rowan Drummond	3	558
function to insert a picture movermike	by movermike	2	565
drop down box in cell cdeldegan	by Sandy	1	298
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,207
How do I fix a link pinetown83	by pinetown83	0	430
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,919
Mode between two serial dates/times ChrisM	by Biff	1	398
If ? maybe..... Pete	by Biff	5	374
Validation Help nicolebelle	by nicolebelle	8	486
Delete first two digits in column rjtees	by rjtees	4	1,447
Count if a number is between X and Y WBTKbeezy	by bpeltzer	3	1,469
Reference Cell Content Sloth	by Harlan Grove	1	532
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	387
Seperation of prime and sub inventory units Novice	by Kleev	1	596
search for text within text BigDave	by bobwhite	2	554
Automatic Date Update Jmoore	by Gord Dibben	1	552
why does sorting large columns create errors in top selection? Mitch	by MDBCT	1	685
Count According to Date Lori	by Bob Phillips	1	574
Refresh Button Iguss	by Iguss	0	450
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,164
comparing columns ~Q	by Kleev	1	632
SUMIF 2 conditions are met??? Granger	by Granger	3	1,075
Combine 2 formulasinto 1. Steved	by Steved	2	333
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,446
Problem with random inputs jtreme	by Gary''s Student	1	418
import with locked cells? Robert	by Robert	0	364
How do I copy comments into cells SeanCrown	by Gord Dibben	2	611
IF formula dtmd	by goober	4	343
separate name and address Aaron	by Aaron	4	1,225
How can you add an "&" in a footer? Christina_0123	by Gord Dibben	3	313
How do I highlight duplicate data on a spreadsheet? Grim72	by Gord Dibben	2	588
Converting numbers to text Chrisj20	by Gord Dibben	2	428
Use Index to get range Adella	by Adella	4	474
averging prices real problem amrezzat	by Roger Govier	6	447
How can I globally set "error message" parameters in Excel Evansct	by Evansct	5	483
Formula Workdays-Holidays-adjustments Glenna	by Glenna	4	500
How do I convert hours and mins into just minutes in excel? Jsmith5663	by Nise	1	430
how can i ignore blank cells when multiple cells? arash	by Dave Peterson	4	1,153
help on lookup functions Kesqsay	by Ian	1	487
Lock cell entry Sprankler	by Bernie Deitrick	1	768
DEMMAGE FILE SHAHZAIB ISMAIL	by Don Guillett	1	413
Return entry in column above/below cell TheRobsterUK	by TheRobsterUK	2	782
Search for record with specific name in a cell pomalley	by pomalley	2	610
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	434
Dates in Excel Fat Doris	by Ron Rosenfeld	1	391
Inserting graphics in protected worksheets HRMSN	by HRMSN	0	415
hyperlink changes when doc emailed Jane	by David McRitchie	1	496
Vlookup and forecast vijaya	by David McRitchie	1	616
Formulas Chrisj20	by David McRitchie	3	307