Excel Worksheet Functions - Page 598

Thread / Thread Starter	Last Post	Replies	Views
format a column from E605EQ1212 to E 605 EQ 1212 Scott at Scott	by Ron Rosenfeld	2	388
Cash Flow for Investments Jeff Kahn	by Jeff Kahn	0	422
#DIV/0! Error - Need to display 0 or blank Brooks W.	by Brooks W.	5	1,257
$ sign for absolute reference Explanation pano	by bj	3	722
Random numbers of 1-9 using only 4 numbers in each column Janet	by bj	4	978
loss of fidelity message jon dougal	by Dave Peterson	2	1,073
How to know the difference value of a cell from previous value. ramulu	by Sandy Mann	1	457
If values are'nt entered in cell a popup window comes up?? pano	by Toppers	5	773
PRODUCT counting empty cells as 1 Supersonic	by Supersonic	3	563
Countblank formula EElliott	by Rodrigo Ferreira	4	714
Dynamic reference in OFFSET function manu	by Duke Carey	1	1,429
Sumproduct IF Q Sean	by Bob Phillips	4	429
Stopping formulas from changing when sorted Lehane	by Lehane	0	432
IRR & XIRR - Different Results Alex Morgan	by Alex Morgan[_2_]	10	4,465
Can I put few buttons on an excell worksheet to filter according . Jazim	by FSt1	1	400
How to hide a portion AS WELL AS it's formulas, then recalling FQGirl	by FQGirl	0	362
formula bar displays "=RC[-12]+RC[-11]". how to get normal view? Laurent	by Laurent	3	5,408
Comparing two workbooks. Kevin Porter	by Max	1	414
Vlookup does not return approx match djd	by T. Valko	7	986
Subtotal Steved	by Steved	2	362
COUNTIF conundrum mmcap	by Ron Coderre	5	541
Finding out whether text is in a list or not Max	by Max	0	333
If cell B1 is 0 show number in cell A1 pano	by T. Valko	5	330
Counting DD:HH:MM NETWORKDAYS and Hours Oliver L Randle	by daddylonglegs	4	2,079
Ratio - How To Create Your Own Function/Formula Dawg House Inc	by Dawg House Inc	2	1,052
How to find the value? Eric	by T. Valko	3	317
protected cells & sorting Jess	by Jess	0	523
unique count with conditions jogre	by Bob Phillips	5	402
Cummulative tjh	by driller	2	513
Help with formula rael_lucid	by rael_lucid	5	350
Conversions dengel	by David Biddulph	2	464
Excel 2000 to 2007 Ian	by Debra Dalgleish	2	383
numbering rows in a filtered worksheet olga	by Debra Dalgleish	3	406
Adding data to create ranges jodieg	by jodieg	4	393
Formulas within workbook but seperate sheets. kenmills2	by kenmills2	2	427
Cell Reference Gunhaver_06	by Gunhaver_06	1	507
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL YKPURI	by JE McGimpsey	1	1,868
Gosub - Goto ? El Bee	by Niek Otten	5	1,833
Can I schedule a macro to run automatically at a certain time? Colibri_2[_2_]	by bpeltzer	1	1,572
Wildcards in SUMIF Function Ron	by Bob Phillips	9	781
How do i put a cell reference in an If Function? ASAP robbie	by Robbie	2	426
Quotients in rows Sheba	by Gord Dibben	4	391
how do i join 2 "dqy" type queries in excel 2003 Joe	by Jim Thomlinson	1	834
Condit Format? Make date change colors tkg	by David Biddulph	6	1,063
List last 5 non-zero entries Rayo K	by JMB	3	1,119
Formatting Cells with Dates lls53	by JE McGimpsey	2	258
SumIf or SumProduct [email protected]	by T. Valko	8	658
sheet protection - only selected range to be able to select/input data Corey	by Gord Dibben	7	942
Freeze Panes in Shared Workbook NealMed	by NealMed	0	994
Count numbers in list Arne Hegefors	by Ron Coderre	6	554
Calculating a sliding scale John	by Bernie Deitrick	3	2,470
seperate two values fromone cell into 2 cells Darius	by Darius	3	386
Formula Question - starts "=+" mr tom	by SharonT	3	320
retrieving data Jess	by vezerid	1	501
if bigger than Arne Hegefors	by Sandy Mann	2	377
Passing Arguments in Excell UB	by JE McGimpsey	3	693
Countif? DES	by DES	4	401
How can I save Excel subtotals without saving hidden (Level 3) r Judy Stumpf	by Judy Stumpf	0	578
Asking in a different way for petrol sheet help pano	by vezerid	1	396
Too many IF-AND, can LOOKUP do this? tommcbrny	by Bob Phillips	2	327
Maximum Louisq	by JE McGimpsey	1	828
Limiting Number of Times a Workbook can be Opened Dan R	by JE McGimpsey	1	716
Need task list that includes date and days + or - SharonT	by SharonT	4	360
Wildcard for Conditional Sum Wizard statement. Ron	by Ron	3	1,313
Always keeping source formatting when copying and pasting in Excel Mail Merge and Form Protection in Word 2	by Mail Merge and Form Protection in Word 2	0	2,608
copy row with specific name to row 52 [email protected]	by [email protected]	0	316
What compounding assumption does excel use for its XIRR function? IRR calculator	by Harlan Grove	3	4,840
Cubed square root Damon Longworth	by Harlan Grove	8	880
Lookup array RD Wirr	by RD Wirr	5	469
how i can do programming in MS Excel.? Vishvapal	by Gary''s Student	1	522
Hide the formula in a cell. sansk_23	by Bob Phillips	1	374
Adding and subtracting time Terry Bennett	by Terry Bennett	2	835
array formula Tim	by Tim	4	354
help with creating function and figuring out formula monkeytrader	by David Biddulph	3	643
simple minus formula help S S	by Joerg	4	442