Excel Worksheet Functions - Page 570

Thread / Thread Starter	Last Post	Replies	Views
how to set default column function hui	by Teethless mama	3	536
Picture in scaled page Patrik S	by Patrik S	0	450
Count no of cells containing data for more than one criteria Jasmine	by Teethless mama	2	570
WEEKDAY in Conditional Formatting? Ken	by Ken	3	1,678
Order of Cell Advancement MRR	by Bob Phillips	1	546
SUMPRODUCT is OK for a while and later a similar formula returns 0 Pierian Spring	by Pierian Spring	4	601
HOW DO I CREATE A SUBTRACTION FORMULA MEDIC70736	by MEDIC70736	2	1,208
split email id list into 1 extra list with everything after "@" Rob	by Rob	4	1,378
sumif Martin	by RagDyeR	2	445
Copying Worksheets Rich	by Rich	0	523
Need help with recording a macro, attaching a button oxicottin	by oxicottin	9	592
Find Duplicate Values and Return Another Value [email protected]	by Mike	2	1,224
SUM OFFSET COLUMNS alien1155	by Duke Carey	4	906
using sumif to sum a range of values highwayman	by highwayman	4	659
Locking Cells or worksheets Steve	by Steve	4	625
Copy function across autofilter dd	by vezerid	13	1,040
Assistance with Alphabetizing a Library Worksheet bandre	by Gord Dibben	2	1,366
Creating Nested Functions Texicanslim	by T. Valko	12	1,235
Drop-down lists with colours or pictures Agneta in Stockholm	by vttanker	1	824
function to display contents of a cell Ronald	by Dave F	2	745
run time error 1004 Louise	by Louise	0	477
Counting specific character in text string Bob	by Bob	3	633
how to creat a formula to advance date by one year Liz Lalman	by Teethless mama	3	1,051
Combining Two Files PaulL	by Dave F	1	462
When exporting a report from Access to Excel columns misaligned coppinger	by coppinger	0	538
formula returns blank Karen	by Sandy Mann	5	661
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007) Gre	by T. Valko	3	614
SUMPRODUCT Formula Help CLM	by vttanker	4	528
If function David Platt	by Michael M	4	333
min & max values Robert Dieckmann	by T. Valko	4	478
Creating drop down box with worksheet names Steve	by Dave Peterson	8	529
Count the number of times a hyperlink is viewed RocketMan	by Gary''s Student	4	2,036
How to specific the cell format? Eric	by Epinn	6	536
how do I create random blocks of letter and words in excel? pencean	by Elkar	1	1,037
CAR LEASE CALCULATION WITH RESIDUAL FIN	by [email protected]	1	5,285
why won't my cells format correctly? shannonc80	by shannonc80	5	1,417
Selecting Hyperlinked data RBeau	by RBeau	6	629
How do I make a pop-up window that displays a range in Excel?? tyler.speer	by Martin Fishlock	1	597
Why do columns zero out when I try to re-sort two spreadsheets Excel neophyte	by RagDyeR	1	351
Changing numbers/percentages to letter grades Preston Steele	by Alan	7	917
If, Then Values bassplayerbg	by Teethless mama	3	459
excel, multiply problem hans	by Gord Dibben	2	564
Search table for string return next columns value mikpits	by T. Valko	3	732
Fit scores Sciguy	by Pete_UK	4	490
How can I interpolate values off a table? phil	by Lori	1	1,497
Making a Call to an external sheet using a variable... [email protected]	by [email protected]	2	580
WORKDAY Function in an IF statement [email protected]	by [email protected]	2	2,585
Conditional formatting a range of cells Givvie	by RagDyeR	3	478
sales invoice Al	by Al	3	458
embarrassed Al	by Sandy Mann	2	443
hiding zero values on all sheets & by default on new sheets WiFiMike2006	by vttanker	4	1,330
LOOKUP and #N/A Error Mike	by Poody	1	653
Conditional IF statements sike11 via OfficeKB.com	by Mike	9	724
Dynamic Rolling Average Lancer940	by Lancer940	5	1,335
= in cell does not upadate Karlos	by Karlos	0	443
columns like in word jenn	by Dave F	1	347
My SUM function is totalling to 0 tom	by daddylonglegs	1	1,106
Data Validation Problem Mark S	by Mark S	0	399
adding data to existing data cell Curious	by Teethless mama	2	564
Calling cell values from random sheets from a base sheet [email protected]	by Gary Brown	2	528
remove links when pasteing formulas from one workbook to anoth Roger	by Roger	1	1,263
counting check boxes mini MP	by mini MP	0	401
Conditional formatting date ranges arkmpr	by arkmpr	1	785
coloured fonts in cells tom	by tom	0	486
replace results from list with corresponding list Sean McDonald	by Sean McDonald	0	533
LOOKUP with 2 or more criteria Tomas	by Mike	1	425
My SUM function is totalling to 0 Caroline	by Caroline	0	574
counting check boxes mini MP	by mini MP	0	890
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') Lawrence C H Tan	by Lawrence C H Tan	0	1,579
Excel Function - Please help Neil Hindry	by daddylonglegs	6	442
saving filters CLR	by CLR	0	335
Get Macro warning, but can't find Macro Stilla	by Stilla	1	803
another array question Robert Dieckmann	by Epinn	5	488
Array formula for unique values Dan Hatola	by Dan Hatola	0	595
Complex Look Up Problem CJLuke	by T. Valko	5	457