Excel Worksheet Functions - Page 20

Thread / Thread Starter	Last Post	Replies	Views
unprotect sheet (icon is greyed out) dj888de	by Gord Dibben	1	4,376
Delete duplicate data in a single cell kacey28	by Dave	10	4,375
How do I limit formula results to positive only? mathjegna	by Peo Sjoblom[_3_]	4	4,375
How do I calculate NPV of perpetual annuity. Kalsang	by bpeltzer	1	4,372
ANOVA with two factors Ted M H	by Mike Middleton	2	4,371
Missing values when using TREND Asa_johannesen	by Asa_johannesen	2	4,371
Auto fill option box disappeared sbrimley	by Dave Peterson	5	4,367
Formula help - Sum results Pass or Fail Nadine	by [email protected]	9	4,367
Date Conversions from UTC to EST Kosher Kitten	by Peo Sjoblom	1	4,364
How do I calculate IRR using monthly cash flows, not annual? Mike Knoxville	by Ron Rosenfeld	2	4,361
Don't show all Pivot table subtotals tlc	by Sean Timmons	1	4,361
How to get compound annual growth rates in pivot tables. dunes	by dunes	2	4,359
Adding Fractions of a Second build	by Peo Sjoblom	7	4,357
How do I copy a vlookup formula without changing the data range? VickyL872	by Alan Beban[_2_]	2	4,352
Keep non-duplicates only GMK	by smw226 via OfficeKB.com	7	4,351
XIRR and IRR Dan	by Alok	2	4,351
Using Roundup in an IF Statement LBW[_2_]	by Joe User[_2_]	2	4,350
SUMIF NOT #VALUE Question Dax Arroway	by Domenic[_2_]	3	4,349
How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? Wesley Accellent	by Bernie Deitrick	6	4,347
Top 10 Text Values KarenH	by Domenic	14	4,345
vlookup, multiple values, sum values into one cell?? Phillips L	by Riq	4	4,344
Days until birthday Ward	by Ward	3	4,342
CONVERT TIME FROM 4:30 TO 4.5 keeb	by Mike H	2	4,342
can't see top of spreadsheet LuLu	by Susan	1	4,341
3-dimensional matrix XL comp.	by John C[_2_]	5	4,340
Will not calculate average/median formulas;acts like no data in c. Frustrated User of Excel today	by Hayeso	3	4,340
Automatically insert rows with formula susy	by susy	10	4,338
how to make a formula ignore blank cells Snap	by MyVeryOwnSelf	6	4,338
autofill down won't work!!!! yowzers	by ryguy7272	3	4,335
Finding duplicates in Excel 2003 MRDAPkelley	by David Biddulph[_2_]	2	4,326
How do i lengthen an existing VLOOKUP table array? artesia7	by artesia7	5	4,323
IRR vs XIRR Csmithers	by joeu2004[_2_]	8	4,321
Solver Binary Contraints problem Rick Kaullen	by Tushar Mehta	1	4,320
using linest to generate 3rd order polynomial coefficients Incoherent	by Incoherent	4	4,319
Writing an IF statement in Microsoft Query JTurner	by JTurner	6	4,316
how do i embed an editable word document into excel 2007? Scott S.[_2_]	by Jacob Skaria	1	4,315
Excel - Calculate age from DOB in years, months days Polly	by Polly	7	4,314
Restoring Gridlines Abradaxis	by David Biddulph[_2_]	3	4,312
Sort data separated by commas dab	by Ashish Mathur[_2_]	4	4,310
margin of error formula IC Data	by bj	3	4,310
Conditional Formatting Function for Anniversary Dates blucajun	by Sandy Mann	5	4,309
change Excel column headings from numbers to alpha characters Changing Excel Column Headings	by Toppers	2	4,306
Create refresh button in worksheet to refresh Pivot Table Data Ron	by Debra Dalgleish	1	4,305
Quick way to "Shrink to Fit" Sheeloo[_3_]	by Sheeloo[_3_]	0	4,303
How do I convert 1000 to One Thousand (i.e numberic to words)? Ratan Tilak	by Bob Phillips[_3_]	2	4,301
How do I link cells from one excel worksheet to another? stb	by Buckeroo	27	4,301
What is the little green triangle??? mscertified	by JW[_2_]	1	4,301
find LAST match in column Pantryman	by Aladin Akyurek	7	4,300
Protect Workbook vs Worksheet?? Dan B	by Don Guillett	3	4,298
Calculating pay-off time for Credit Card? Robert Blass	by Robert Blass	8	4,297
calculate a continuous percent of attendance -if then using count. IrisRandom*	by IrisRandom*[_2_]	2	4,294
consecutive blank cells old coach	by tarquinious	2	4,290
How do I sort pivot table data outside a pivot table Michael	by Bernie Deitrick	1	4,289
inserting current windows user id into a cell MartyMack74	by Ron Rosenfeld	2	4,288
Week ending calculation Michelle	by Ashish Mathur[_2_]	6	4,288
How do i disable/enable "Worksheet Move or copy" option? Saon	by Spiky	1	4,286
Percentage of Ownership Formula Bill Booth	by John C[_2_]	10	4,285
Exclude certain cells from printing. excelnewbie	by TRRed1	3	4,285
how do i use square root on excel - what is the formula Karen	by Frank Winston	4	4,283
Cells are not sorting correctly Daze3Daze	by Daze3Daze	2	4,280
How do you determine a seasonal index in Excel? [email protected]	by Mike Middleton	2	4,280
Interrupting A Worksheet Calculation carl	by MrShorty	2	4,279
Convert Decimal fractions to binary and vice versa [email protected]	by Ron Rosenfeld[_2_]	2	4,279
polynomial equation PAUL GRAZIDE	by Jerry W. Lewis	6	4,277
Searching a text string in a range of cells. heenanmc	by heenanmc	2	4,277
convert column of text email addresses to hyperlinks all at once Ann	by Tevuna	1	4,276
How do I create multiple scroll bars within one Excel sheet? [email protected]	by David McRitchie	5	4,274
How do I apply print settings to all worksheets Calgarybudget	by CherylK	1	4,272
Use find to select entire rows with a cell with that value Franky88	by Franky88	2	4,271
Calculate Selected cells only. Stan	by CLR	3	4,271
Macro will work on one computer but not on another Gillian	by Peo Sjoblom	11	4,270
Nested --- Subtotal IF function Lisa Beach	by Bob Phillips	3	4,266
How do I change the default header date format in Excel 2007? Jazzman721	by Gord Dibben	3	4,264
how to calculate a projected date farmgirl	by Ashish Mathur[_2_]	3	4,264
Subtotals (outline) features grayed out Rubystarx	by Kelly Gates	2	4,264