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	452
Name in cell ref used in a formula Phendrena	by T. Valko	5	465
Calculating business days minus holidays RJ Swain	by Peo Sjoblom	4	2,559
Calc days between two dates and exclude leap year days scoz	by Ron Rosenfeld	5	5,248
future value TonyY	by joeu2004	2	957
Pivot Table Calculations mike	by mike	0	409
#N/A in lookup function [email protected]	by [email protected]	3	598
Sharing workbook DaveAsh	by David Biddulph[_2_]	1	424
Searching for a Appraisal form for Gems stomes and pearls Min	by Min	0	485
in excel: format font conditional on content of adjacing cell? carl87	by Giff	2	486
More lines to one Therese	by Therese	4	437
Automatic copy triggered by change in date Xerxes	by Gary''s Student	1	469
LInking workbooks DaveAsh	by DaveAsh	8	585
Formula modification yshridhar	by yshridhar	10	736
Changing ODBC server (MySQL) Groj	by Groj	0	412
Refering to other tabs easily Sean	by Max	11	1,087
compould yield calculation alex	by ryguy7272	1	607
Weird Multiplication! Gary T	by Stan Brown	6	618
#VALUE error an	by an	8	728
Conditional Formatting 2007 Steved	by Pete_UK	3	532
Comparing two columns and return a third casedk	by Pete_UK	3	2,850
How to convert function return value to text? merri	by Pete_UK	3	912
sort function for dates does not sort properly in Office 2007 Exc. Rosalie	by Pete_UK	1	1,303
Formula Noelline	by Jerry W. Lewis	7	368
vlookup left Mottyb	by Pete_UK	2	556
lookup left Mottyb	by Mike H	2	396
What are the calcs in PMT Micky G	by joeu2004	7	633
Multiple vlookup // sansk_23	by vezerid	2	684
Excell Sue Parsons	by Gord Dibben	5	359
SUMIFS Compatiblilty for Excel 2000 Freddy[_2_]	by Pete_UK	4	1,965
How to delete same column in every sheet CP	by Herbert Seidenberg	6	678
How do I apply a formula to multiple rows at the same time? ManhattanRebel	by Dave Peterson	1	1,209
Search, cut & paste chrisk	by chrisk	0	403
VLOOKUP Conversion from Excel 2003 to Excel 2007 Michael D. Ober	by Michael D. Ober	2	844
if statement hotlh	by Bob Phillips	2	392
Conditional Format to highlight entire row if a condition is met klmiura	by Bob Phillips	5	3,128
GRAPHS svangis	by Bernard Liengme	1	361
unprotect subtotals [email protected]	by Dave Peterson	1	691
call distribution Andrew@rushington	by Andrew@rushington[_2_]	5	687
to pull from multiple sheets-index,match,vlookup,if,and,or??? ladygr	by Pete_UK	10	1,526
HOW WILL MOVE TO 2ND WORKSHEET [email protected]	by [email protected]	2	441
how can find sheet on workbook have so many sheet ? Huy Nguyen	by Roger Govier[_3_]	1	565
Count date in 2 column Jason Au Yeung[_2_]	by JMB	3	472
How to calculate with #div/0! error? nagje	by nagje	12	1,548
Formula to Identify Col Data-Pairs that Differ by 2*pi monir	by monir	2	560
Excel autofilter freezes Vic07	by Vic07	0	1,167
Pivot Table Averages at Subtotal Blueglass	by Debra Dalgleish	3	2,990
data validation, dynamic ranges Rich Hayes	by Debra Dalgleish	3	605
Removing a period and leaving maintaingn a fixed #of numbers Iguss	by Iguss	5	436
need to lookup a value in one column to fill in another jspen	by JMB	2	500
print button macro & specific tabs to print Chuck[_3_]	by Dave Peterson	2	1,895
LINREGR Flemming	by Bernard Liengme	2	702
Help please with a lookup problem CP	by Gord Dibben	5	433
Redirecting a formula in an "IF THEN" statement Eden397	by JMB	13	900
Macro to save file as different filename mac	by FSt1	6	1,270
Nesting with "IF" Patrick	by Patrick	2	340
Add up all numbers in VLOOKUP that has identical lookup value ssolomon via OfficeKB.com	by T. Valko	5	1,053
How do I count the # of unique occurences of a text in a column? Rob Kaiser	by T. Valko	10	1,091
Can I have the formulas instead of computation on the screen. Printing formulas	by Niek Otten	3	383
subtotals in linked tables dave oatley	by dave oatley	0	462
Compare two Cells and highlight third cell Timmy	by Gord Dibben	3	2,366
Formulas for multiplying cells gdmn6	by Gord Dibben	4	422
Excell nested function question.... Malley87	by Don Guillett	1	514
XP EXCEL WORKSHEET WILL NOT SORT. HOW TO FIX frank	by CLR	1	416
unmerge cells when the merge and center button doesn't work Rhonda Fatt	by Gord Dibben	1	1,117
vlookup combine indirect [email protected]	by T. Valko	1	766
Need to extract certain text from text string Trista @ Pacific	by Trista @ Pacific[_2_]	4	581
Scale numbers for Y Axis. PayPaul	by Pete_UK	1	442
Validate Sku No in Sheet 1 against Sheet 2 jerminski73	by T. Valko	7	396
sum the difference in a range carla	by carla	2	495
Formulas that calculate to errors on one computer but not on anoth WKH	by Gord Dibben	5	454
can font color be controled in an IF statement Confused Rookie	by Gord Dibben	3	516
How do i set the scroll bar for increments of 0.5? Akrodon	by Bernie Deitrick	1	2,307
loan payments SEC	by SEC	5	748
conditional formating with isodd and iseven BIG D	by Gord Dibben	14	1,222