Excel Worksheet Functions - Page 18

Thread / Thread Starter	Last Post	Replies	Views
Why doesn't the INDIRECT function work when nested in FREQUENCY? Philip J Smith	by T. Valko	10	1,130
Why doesn't the finance rate in MIRR impact the formula result? opieandy	by opieandy	0	601
Why doesn't the DDB function work all the time? Pileski	by mphell0	2	596
Why doesn't the alignment dialog box come up like the book shows? [email protected]	by Rick Rothstein	2	472
Why doesn't spell check work on a protected worksheet? Creating Order Forms is Fun	by [email protected]	6	1,412
why doesn't sort work when it's choosen before protecting sheet Mearll	by Ron de Bruin	1	715
Why doesn't RANK(1,{2,1}) work? joeu2004	by joeu2004	2	457
Why doesn't Print Preview doesn't show everything correctly? Meenie	by Meenie	0	1,266
Why doesn't nesting subtotals work in 2003 version? Rebecca	by Peo Sjoblom	3	626
Why doesn't my resized worksheet have a minimize or close box in . Wade www	by Debra Dalgleish	3	1,068
Why doesn't my Excel '03 let me use brackets for negative numbers T Standish	by Gord Dibben	2	959
Why doesn't my audit arrows show up? rross23	by rross23	0	588
Why doesn't it print the colours? EN	by EN	8	464
why doesn't excel count "numbers" in an IF formula Noddy2011	by Mike H	3	372
Why doesn't excel 2003 accept this "IF" grade formula?? Please HE VD	by Don Guillett	6	474
Why doesn't "Replace" function find value I know exists? UHAAdminAsst	by Gord Dibben	4	1,551
Why does'nt sheet protection allow CTRL+PAGEUP/DOWN to work? rtm4833	by rtm4833	0	491
why does xlnm get superimposed in my formulas upon exit JD in Riverbank	by JD in Riverbank[_2_]	2	1,153
why does when i drag a formula in excel gives the same value? oliver	by Roger Govier[_3_]	5	1,066
Why does using @SUM in EXL 2002 trigger an O/L "new" email ? Retiree	by Dave Peterson	3	474
why does undo feature not work after value entered? dachsieluvr	by Dave Peterson	1	466
why does undo feature not work after value entered in cell in exce dachsieluvr	by Norman Jones	1	536
Why does this Formula work? Kevin Vaughn	by Kevin Vaughn	3	546
Why does this formula not work? DaveMoore	by Max	4	720
why does this formula have to be entered as an array formula? Dave F	by Dave F	3	315
Why does this formula clog my spreadsheet? andy62	by Charles Williams	3	374
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) =TEXT(RC3,Number)& / &TEXT(R32C,Number	by garfield-n-odie	2	677
Why does this confuse me?? -- ? on Offset function Awrex	by T. Valko	1	515
Why does this code not do what I want Patrick C. Simonds	by Rick Rothstein $MVP - VB$	5	426
why does this appear when i hit the = sign : =[ or[= susie	by Otto Moehrbach	1	299
Why does the word REG change to Rag when typed into a cell? Reg	by Gary''s Student	2	513
why does the vlookup function not work using time? vicky	by Marcelo	1	654
why does the toolbar have a button, $ and is said currency,it giv. Terry621	by Gary L Brown	1	439
Why does the Sort function stop recognizing Header Rows? Frostfire	by Dave Peterson	4	1,017
Why does the right 'Alt' key not work in Excel? zuzartej	by zuzartej	4	1,228
Why does the Pivot table iin Excel add a 2 to my name? SFD	by Debra Dalgleish	1	3,615
Why does the macro not work? Xanadude	by Ken Wright	4	617
Why does the formula result show a number but the screen shows ze. Jam-Du	by Ron Rosenfeld	2	1,163
Why does the font color not save on my excel spreadsheet? SheilaRay	by Gord Dibben	1	2,145
Why does the following formula not work: =IF(2<A1<=2.25,2.25," ") beava37	by Dave Peterson	1	403
why does the dateif function result in an error in Excel 2003? Cheryl	by Mike H	5	1,572
Why does the date change when copying? Jessica	by Gord Dibben	2	692
Why does the data shift out my outline when I refresh the Pivot table? Chris	by Debra Dalgleish	1	714
Why does tabbing from A1 take me to L1 then to W1 ConnieF	by ConnieF	2	436
why does sorting large columns create errors in top selection? Mitch	by MDBCT	1	656
Why does paging down skip ten rows? RADEANO	by Otto Moehrbach	2	457
why does ON = Ambiguous in substitution formula? waladd	by waladd	5	756
Why does not Excel 2003 Replace comand romove spaces from cell contents? Dmitry	by Ron Rosenfeld	5	683
WHY DOES MY WORKSHEET MOVE WHEN I USE THE ARROW KEYS? Melissa	by Dave Peterson	2	580
Why does my text in a cell with wrap text and auto height get cut HerbertB	by Gord Dibben	4	2,693
Why does my tab move to the end of the visable field instead of 1 Anne	by Dave Peterson	2	448
Why does my sheet have 60,000 rows when only 60 rows have data? Joe Fuller	by Ron de Bruin	1	656
Why does my shared spreadsheet have formula errors? Barb	by Dave Peterson	1	558
Why does my print preview (and print) not reflect the chosen margi Mecohano	by Mecohano	0	457
Why does my formula in Excell return a #N/A? Darrel A	by Kevin Vaughn	6	944
why does my excell worksheet start with only a gray view, no data tsplus	by Ken Wright	4	379
why does my excel change the print options of another user's file Julie of Red Sun Csutom	by Julie of Red Sun Csutom	0	536
wHY DOES MY CURSOR TURN INTO A CROSSHAIR AFTER I CUT AND PASTE SP Modesto Steve	by Fred Smith[_4_]	2	1,716
Why does my color palette automatically change? GRAero87	by GRAero87	0	1,401
why does my cells turn blue like I'm formatting when I try to ent. frewil	by Debra Dalgleish	1	1,648
why does my "TAB" key skip a column in excel spread sheets? luke01	by David Biddulph[_2_]	2	1,062
Why does it say "Filter mode" instead of "X of Y records"? lucky_jed	by lucky_jed	3	813
Why does it display #### in my cell? Lindsey-Star	by Joe User[_2_]	14	2,418
Why does freeze panes work on one sheet but not on another in sam. environengineer	by JulieD	1	1,250
Why does forumula show in cell instead of formula result? Ashley	by Dave Peterson[_2_]	2	1,833
Why does formula show rather than results (not in text format) Caseybay	by Caseybay	4	1,137
Why does Excel's DDB formula never depreciate the whole amount? brandi7862	by Tyro[_2_]	4	1,272
Why does Excel XP say that 25-25.08+0.08 = 1.706975E-15 instead o. Tarek	by Jerry W. Lewis	4	445
Why does excel sometimes subtract numbers incorrectly? spotoeg	by Niek Otten	2	716
why does Excel see my simple formulae as macros now? Chris	by Chris	4	418
Why does Excel say this formula contains an error? HuskerBronco	by HuskerBronco	12	1,811
Why does Excel return a : when I insert a . Jose	by Kevin Vaughn	2	328
Why does Excel not multiply a number generated by an IF formula? Free Ishii	by bj	5	558
Why does Excel freeze and have to close when I hold Alt down and . KDRNeutron	by KDRNeutron	0	1,306
why does excel DELETE rows of data when removing subotals? Karen	by Karen	2	654