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	465
Name in cell ref used in a formula Phendrena	by T. Valko	5	477
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,319
future value TonyY	by joeu2004	2	967
Pivot Table Calculations mike	by mike	0	418
#N/A in lookup function [email protected]	by [email protected]	3	636
Sharing workbook DaveAsh	by David Biddulph[_2_]	1	431
Searching for a Appraisal form for Gems stomes and pearls Min	by Min	0	493
in excel: format font conditional on content of adjacing cell? carl87	by Giff	2	495
More lines to one Therese	by Therese	4	445
Automatic copy triggered by change in date Xerxes	by Gary''s Student	1	486
LInking workbooks DaveAsh	by DaveAsh	8	597
Formula modification yshridhar	by yshridhar	10	757
Changing ODBC server (MySQL) Groj	by Groj	0	423
Refering to other tabs easily Sean	by Max	11	1,094
compould yield calculation alex	by ryguy7272	1	624
Weird Multiplication! Gary T	by Stan Brown	6	629
#VALUE error an	by an	8	740
Conditional Formatting 2007 Steved	by Pete_UK	3	547
Comparing two columns and return a third casedk	by Pete_UK	3	2,862
How to convert function return value to text? merri	by Pete_UK	3	930
sort function for dates does not sort properly in Office 2007 Exc. Rosalie	by Pete_UK	1	1,325
Formula Noelline	by Jerry W. Lewis	7	377
vlookup left Mottyb	by Pete_UK	2	565
lookup left Mottyb	by Mike H	2	404
What are the calcs in PMT Micky G	by joeu2004	7	643
Multiple vlookup // sansk_23	by vezerid	2	689
Excell Sue Parsons	by Gord Dibben	5	370
SUMIFS Compatiblilty for Excel 2000 Freddy[_2_]	by Pete_UK	4	1,981
How to delete same column in every sheet CP	by Herbert Seidenberg	6	689
How do I apply a formula to multiple rows at the same time? ManhattanRebel	by Dave Peterson	1	1,229
Search, cut & paste chrisk	by chrisk	0	411
VLOOKUP Conversion from Excel 2003 to Excel 2007 Michael D. Ober	by Michael D. Ober	2	861
if statement hotlh	by Bob Phillips	2	406
Conditional Format to highlight entire row if a condition is met klmiura	by Bob Phillips	5	3,160
GRAPHS svangis	by Bernard Liengme	1	367
unprotect subtotals [email protected]	by Dave Peterson	1	704
call distribution Andrew@rushington	by Andrew@rushington[_2_]	5	695
to pull from multiple sheets-index,match,vlookup,if,and,or??? ladygr	by Pete_UK	10	1,540
HOW WILL MOVE TO 2ND WORKSHEET [email protected]	by [email protected]	2	458
how can find sheet on workbook have so many sheet ? Huy Nguyen	by Roger Govier[_3_]	1	572
Count date in 2 column Jason Au Yeung[_2_]	by JMB	3	486
How to calculate with #div/0! error? nagje	by nagje	12	1,564
Formula to Identify Col Data-Pairs that Differ by 2*pi monir	by monir	2	581
Excel autofilter freezes Vic07	by Vic07	0	1,175
Pivot Table Averages at Subtotal Blueglass	by Debra Dalgleish	3	3,021
data validation, dynamic ranges Rich Hayes	by Debra Dalgleish	3	631
Removing a period and leaving maintaingn a fixed #of numbers Iguss	by Iguss	5	448
need to lookup a value in one column to fill in another jspen	by JMB	2	506
print button macro & specific tabs to print Chuck[_3_]	by Dave Peterson	2	1,895
LINREGR Flemming	by Bernard Liengme	2	712
Help please with a lookup problem CP	by Gord Dibben	5	445
Redirecting a formula in an "IF THEN" statement Eden397	by JMB	13	920
Macro to save file as different filename mac	by FSt1	6	1,286
Nesting with "IF" Patrick	by Patrick	2	352
Add up all numbers in VLOOKUP that has identical lookup value ssolomon via OfficeKB.com	by T. Valko	5	1,069
How do I count the # of unique occurences of a text in a column? Rob Kaiser	by T. Valko	10	1,111
Can I have the formulas instead of computation on the screen. Printing formulas	by Niek Otten	3	393
subtotals in linked tables dave oatley	by dave oatley	0	476
Compare two Cells and highlight third cell Timmy	by Gord Dibben	3	2,385
Formulas for multiplying cells gdmn6	by Gord Dibben	4	435
Excell nested function question.... Malley87	by Don Guillett	1	526
XP EXCEL WORKSHEET WILL NOT SORT. HOW TO FIX frank	by CLR	1	428
unmerge cells when the merge and center button doesn't work Rhonda Fatt	by Gord Dibben	1	1,137
vlookup combine indirect [email protected]	by T. Valko	1	774
Need to extract certain text from text string Trista @ Pacific	by Trista @ Pacific[_2_]	4	609
Scale numbers for Y Axis. PayPaul	by Pete_UK	1	448
Validate Sku No in Sheet 1 against Sheet 2 jerminski73	by T. Valko	7	413
sum the difference in a range carla	by carla	2	506
Formulas that calculate to errors on one computer but not on anoth WKH	by Gord Dibben	5	463
can font color be controled in an IF statement Confused Rookie	by Gord Dibben	3	530
How do i set the scroll bar for increments of 0.5? Akrodon	by Bernie Deitrick	1	2,346
loan payments SEC	by SEC	5	772
conditional formating with isodd and iseven BIG D	by Gord Dibben	14	1,301