Excel Worksheet Functions - Page 452

Thread / Thread Starter	Last Post	Replies	Views
calculating number of days between first day to last day, inclusiv Damian	by JE McGimpsey	1	468
Name in cell ref used in a formula Phendrena	by T. Valko	5	480
Calculating business days minus holidays RJ Swain	by Peo Sjoblom	4	2,576
Calc days between two dates and exclude leap year days scoz	by Ron Rosenfeld	5	5,353
future value TonyY	by joeu2004	2	968
Pivot Table Calculations mike	by mike	0	419
#N/A in lookup function [email protected]	by [email protected]	3	638
Sharing workbook DaveAsh	by David Biddulph[_2_]	1	434
Searching for a Appraisal form for Gems stomes and pearls Min	by Min	0	494
in excel: format font conditional on content of adjacing cell? carl87	by Giff	2	496
More lines to one Therese	by Therese	4	450
Automatic copy triggered by change in date Xerxes	by Gary''s Student	1	490
LInking workbooks DaveAsh	by DaveAsh	8	599
Formula modification yshridhar	by yshridhar	10	759
Changing ODBC server (MySQL) Groj	by Groj	0	427
Refering to other tabs easily Sean	by Max	11	1,097
compould yield calculation alex	by ryguy7272	1	628
Weird Multiplication! Gary T	by Stan Brown	6	629
#VALUE error an	by an	8	744
Conditional Formatting 2007 Steved	by Pete_UK	3	551
Comparing two columns and return a third casedk	by Pete_UK	3	2,864
How to convert function return value to text? merri	by Pete_UK	3	935
sort function for dates does not sort properly in Office 2007 Exc. Rosalie	by Pete_UK	1	1,332
Formula Noelline	by Jerry W. Lewis	7	378
vlookup left Mottyb	by Pete_UK	2	568
lookup left Mottyb	by Mike H	2	404
What are the calcs in PMT Micky G	by joeu2004	7	645
Multiple vlookup // sansk_23	by vezerid	2	693
Excell Sue Parsons	by Gord Dibben	5	372
SUMIFS Compatiblilty for Excel 2000 Freddy[_2_]	by Pete_UK	4	1,982
How to delete same column in every sheet CP	by Herbert Seidenberg	6	691
How do I apply a formula to multiple rows at the same time? ManhattanRebel	by Dave Peterson	1	1,230
Search, cut & paste chrisk	by chrisk	0	413
VLOOKUP Conversion from Excel 2003 to Excel 2007 Michael D. Ober	by Michael D. Ober	2	866
if statement hotlh	by Bob Phillips	2	413
Conditional Format to highlight entire row if a condition is met klmiura	by Bob Phillips	5	3,165
GRAPHS svangis	by Bernard Liengme	1	369
unprotect subtotals [email protected]	by Dave Peterson	1	705
call distribution Andrew@rushington	by Andrew@rushington[_2_]	5	703
to pull from multiple sheets-index,match,vlookup,if,and,or??? ladygr	by Pete_UK	10	1,542
HOW WILL MOVE TO 2ND WORKSHEET [email protected]	by [email protected]	2	459
how can find sheet on workbook have so many sheet ? Huy Nguyen	by Roger Govier[_3_]	1	573
Count date in 2 column Jason Au Yeung[_2_]	by JMB	3	489
How to calculate with #div/0! error? nagje	by nagje	12	1,565
Formula to Identify Col Data-Pairs that Differ by 2*pi monir	by monir	2	582
Excel autofilter freezes Vic07	by Vic07	0	1,180
Pivot Table Averages at Subtotal Blueglass	by Debra Dalgleish	3	3,023
data validation, dynamic ranges Rich Hayes	by Debra Dalgleish	3	632
Removing a period and leaving maintaingn a fixed #of numbers Iguss	by Iguss	5	455
need to lookup a value in one column to fill in another jspen	by JMB	2	508
print button macro & specific tabs to print Chuck[_3_]	by Dave Peterson	2	1,896
LINREGR Flemming	by Bernard Liengme	2	715
Help please with a lookup problem CP	by Gord Dibben	5	446
Redirecting a formula in an "IF THEN" statement Eden397	by JMB	13	921
Macro to save file as different filename mac	by FSt1	6	1,287
Nesting with "IF" Patrick	by Patrick	2	354
Add up all numbers in VLOOKUP that has identical lookup value ssolomon via OfficeKB.com	by T. Valko	5	1,072
How do I count the # of unique occurences of a text in a column? Rob Kaiser	by T. Valko	10	1,113
Can I have the formulas instead of computation on the screen. Printing formulas	by Niek Otten	3	394
subtotals in linked tables dave oatley	by dave oatley	0	478
Compare two Cells and highlight third cell Timmy	by Gord Dibben	3	2,387
Formulas for multiplying cells gdmn6	by Gord Dibben	4	437
Excell nested function question.... Malley87	by Don Guillett	1	528
XP EXCEL WORKSHEET WILL NOT SORT. HOW TO FIX frank	by CLR	1	429
unmerge cells when the merge and center button doesn't work Rhonda Fatt	by Gord Dibben	1	1,140
vlookup combine indirect [email protected]	by T. Valko	1	777
Need to extract certain text from text string Trista @ Pacific	by Trista @ Pacific[_2_]	4	667
Scale numbers for Y Axis. PayPaul	by Pete_UK	1	450
Validate Sku No in Sheet 1 against Sheet 2 jerminski73	by T. Valko	7	415
sum the difference in a range carla	by carla	2	507
Formulas that calculate to errors on one computer but not on anoth WKH	by Gord Dibben	5	464
can font color be controled in an IF statement Confused Rookie	by Gord Dibben	3	532
How do i set the scroll bar for increments of 0.5? Akrodon	by Bernie Deitrick	1	2,349
loan payments SEC	by SEC	5	781
conditional formating with isodd and iseven BIG D	by Gord Dibben	14	1,336