Excel Worksheet Functions - Page 48

Thread / Thread Starter	Last Post	Replies	Views
Protect Sheet but allow sorting LucyK	by George M	4	2,547
Divide x/y should give Ratio x:y,How to express ratio in excel arvind3738	by Nick Hodge	2	2,547
Can Excel Calculate a Jensen Alpha? MPT Guy	by Harlan Grove	1	2,545
Circular reference, Indirect, and Sum cmrandom22	by ryguy7272	3	2,544
formula for 'If a cell is empty then insert numeric Zero' P Ryan Nutribio	by Max	4	2,544
How do I convert GMT date/time to different timezone Hooves57	by Hooves57	2	2,544
Excel drop down list arrow has disappeared. Tony Maly	by starguy	1	2,544
Delete Rows where there are #N/A Values FIRSTROUNDKO via OfficeKB.com	by FIRSTROUNDKO via OfficeKB.com	3	2,544
Indirect and Dynamic Range Graham Haughs	by Biff	16	2,544
Remove holidays from calculation Sal	by Sal	9	2,543
How to resize a comment box, by embedding code into a function? JJ	by Debra Dalgleish	13	2,543
Excel Macro: Type mismatch (Error 13) tb	by GS[_6_]	16	2,542
Using IF functions to calculate shipping cost and methods jjlandrum	by PeteJ	1	2,542
Function to return colour of formatted cell ExcelMonkey	by Gord Dibben	3	2,541
Vlookup across multiple tabs Hirsch	by Biff	2	2,540
lookup in colum a and compare values in colum b Boggled Excel User	by mzehr	14	2,539
If formula with two conditions to meet Carolina	by Carolina	7	2,539
Can wildcards be used in the Logic Test of an Excel "IF" function? Monte	by Ashish Mathur	3	2,538
Excel: Use a name with external workbook reference for data valida Fishyken	by Dave Peterson	3	2,537
How to check if a date falls within a range(2 cells: Start/End Dat MarcusMac	by MarcusMac	4	2,537
Is there an autofill for all row fields in a pivot table? Wendy B	by Frank Kabel	2	2,537
Formula for Increasing a Cell Reference by a Given Number Kentle	by romelsb	3	2,537
change text color based on logical test T3nMan	by JulieD	1	2,537
How do you calculate rate of return on monthly cash flows Philly Fan	by Fred Smith	1	2,537
How can I show up and down arrows when a value changes? Julie	by Eduardo	1	2,536
How do I make a cell stay blank if "0" result? Gregory Day	by Max	3	2,535
Applying Offset to Range in VBA [email protected]	by JMB	2	2,535
how to sum cells and ignore the #div/0! 's ? Todd	by abdul gaffoor	6	2,535
Remove Rows That Are NOT Duplicates Mongo the Magnificent	by Mongo the Magnificent[_2_]	4	2,535
math formula with upper and lower limits on data but also ranges kenneth	by kenneth	3	2,534
stock control template Gary L	by Eduardo	1	2,534
Insert Copied Rows or Drag/Drop Formulas While Protected veggies27	by Gord Dibben	2	2,534
How can I delete the rulers from my worksheet in 2007 Excel? Dee	by Sheeloo	1	2,534
is it possible to apply template to a existing worksheet Andy	by Andy	2	2,533
IRR calc Monthly vs Annual tdhaist	by Duke Carey	1	2,532
Weeks of Supply Function jeffbert	by Jim Cone	1	2,532
NESTED IF FORMULA - IGNORE BLANK CELLS Evan	by Evan	5	2,532
How To Stop Chart Sizing With Cells? Wayne[_3_]	by Wayne[_3_]	2	2,531
insert images in a protected worksheet kub	by Ron de Bruin	10	2,531
sum daily production data to monthly olga	by Ashish Mathur[_2_]	4	2,530
Macro button colour change??? Beefyme	by tjtjjtjt	1	2,529
Concatenate email addresses Renegade	by Rick Rothstein	3	2,529
How do I change text from all caps to normal type? Karol	by Ken Hudson	3	2,529
Update one worksheet tab to automatically update all other tabs? shoechic1	by Gary''s Student	1	2,528
VLOOKUP lindle101	by John C[_2_]	5	2,526
Finding first number in a row Cadders	by Cadders	2	2,526
How do you calc half day annual leave on a xls spread sheet using. RGayle_Imperial	by Jason Morin	5	2,525
Active sheet instead of a "sheet1" for Macro Pantera	by Jarek Kujawa[_2_]	7	2,525
Finding Partial Text in a Cell bob	by Harlan Grove	6	2,525
Formula results in font color change Jeff P	by Frank Kabel	2	2,524
formula to calculate amount of hours downtime spent in days Peter Gonzalez[_2_]	by Bernard Liengme[_2_]	1	2,523
TIR.NO.PER function, where do i found it in Office 2003??? Iliana Marroquin	by Iliana Marroquin	2	2,523
Calculating overdue date fields AHizon via OfficeKB.com	by AHizon via OfficeKB.com	3	2,523
Reverse false and combine with true true value Emmie99	by Emmie99	5	2,523
Complex IF formula Evan	by James Kay	5	2,522
Excel calculation of duration in hours and minutes [email protected]	by David Biddulph	4	2,522
Printing "Freeze Panes" sh2195	by j B	3	2,521
How do I automatically shade cells depending on data entered? Jim Johnson	by Bob Phillips	6	2,521
Programmatically add a Formula in a worksheet? circuit_breaker	by circuit_breaker	3	2,521
Define Name - same name for multiple cells on multiple sheets Thomas	by RagDyer	3	2,520
Sumproduct not working when summing values between two numbers FlamencoKid	by FlamencoKid	8	2,520
execute stored procedure from excel maxzsim	by Gary Brown	3	2,519
What regular savings, increasing every year to reach goal flossy129	by Michael Marshall	11	2,519
Sum totals based on product name jana	by T. Valko	21	2,518
Edit Drop Down List Lynn S	by MartinW	1	2,518
how to fourier/laplace transform a time signal? Movie Maker	by ryguy7272	1	2,518
How to sort and keep formulas Upya	by David McRitchie	2	2,518
Find and REPLACE within a selection, or column- not entire sheet/. smithers2002	by Arvi Laanemets	4	2,517
find top 25 codes JBoulton	by JBoulton	23	2,517
How do I add a zero in front of a text formatt number? p210driver	by RagDyeR	3	2,516
Use CountIf for a literal string chadkwelch	by Ashish Mathur[_2_]	3	2,516
Lists From Different Tabs Steve Z[_2_]	by Steve Z[_2_]	2	2,515
how to put quotation mark in each cell of the column crazyfisher	by Led_A_Muck[_2_]	17	2,515
Adding time in 24 hour format to produce hours in decimal format Hercdriver	by CellShocked	11	2,515
Can I modify the YIELD formula to use a monthly frequency? DDR	by Fred Smith	2	2,515