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	387
Cash Flow for Investments Jeff Kahn	by Jeff Kahn	0	417
#DIV/0! Error - Need to display 0 or blank Brooks W.	by Brooks W.	5	1,251
$ sign for absolute reference Explanation pano	by bj	3	701
Random numbers of 1-9 using only 4 numbers in each column Janet	by bj	4	971
loss of fidelity message jon dougal	by Dave Peterson	2	1,050
How to know the difference value of a cell from previous value. ramulu	by Sandy Mann	1	451
If values are'nt entered in cell a popup window comes up?? pano	by Toppers	5	754
PRODUCT counting empty cells as 1 Supersonic	by Supersonic	3	553
Countblank formula EElliott	by Rodrigo Ferreira	4	700
Dynamic reference in OFFSET function manu	by Duke Carey	1	1,418
Sumproduct IF Q Sean	by Bob Phillips	4	415
Stopping formulas from changing when sorted Lehane	by Lehane	0	418
IRR & XIRR - Different Results Alex Morgan	by Alex Morgan[_2_]	10	4,459
Can I put few buttons on an excell worksheet to filter according . Jazim	by FSt1	1	388
How to hide a portion AS WELL AS it's formulas, then recalling FQGirl	by FQGirl	0	359
formula bar displays "=RC[-12]+RC[-11]". how to get normal view? Laurent	by Laurent	3	5,328
Comparing two workbooks. Kevin Porter	by Max	1	403
Vlookup does not return approx match djd	by T. Valko	7	971
Subtotal Steved	by Steved	2	350
COUNTIF conundrum mmcap	by Ron Coderre	5	522
Finding out whether text is in a list or not Max	by Max	0	325
If cell B1 is 0 show number in cell A1 pano	by T. Valko	5	328
Counting DD:HH:MM NETWORKDAYS and Hours Oliver L Randle	by daddylonglegs	4	2,069
Ratio - How To Create Your Own Function/Formula Dawg House Inc	by Dawg House Inc	2	984
How to find the value? Eric	by T. Valko	3	317
protected cells & sorting Jess	by Jess	0	511
unique count with conditions jogre	by Bob Phillips	5	385
Cummulative tjh	by driller	2	501
Help with formula rael_lucid	by rael_lucid	5	334
Conversions dengel	by David Biddulph	2	453
Excel 2000 to 2007 Ian	by Debra Dalgleish	2	371
numbering rows in a filtered worksheet olga	by Debra Dalgleish	3	394
Adding data to create ranges jodieg	by jodieg	4	388
Formulas within workbook but seperate sheets. kenmills2	by kenmills2	2	418
Cell Reference Gunhaver_06	by Gunhaver_06	1	496
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL YKPURI	by JE McGimpsey	1	1,845
Gosub - Goto ? El Bee	by Niek Otten	5	1,826
Can I schedule a macro to run automatically at a certain time? Colibri_2[_2_]	by bpeltzer	1	1,560
Wildcards in SUMIF Function Ron	by Bob Phillips	9	767
How do i put a cell reference in an If Function? ASAP robbie	by Robbie	2	410
Quotients in rows Sheba	by Gord Dibben	4	383
how do i join 2 "dqy" type queries in excel 2003 Joe	by Jim Thomlinson	1	821
Condit Format? Make date change colors tkg	by David Biddulph	6	1,045
List last 5 non-zero entries Rayo K	by JMB	3	1,097
Formatting Cells with Dates lls53	by JE McGimpsey	2	251
SumIf or SumProduct [email protected]	by T. Valko	8	607
sheet protection - only selected range to be able to select/input data Corey	by Gord Dibben	7	919
Freeze Panes in Shared Workbook NealMed	by NealMed	0	965
Count numbers in list Arne Hegefors	by Ron Coderre	6	538
Calculating a sliding scale John	by Bernie Deitrick	3	2,370
seperate two values fromone cell into 2 cells Darius	by Darius	3	370
Formula Question - starts "=+" mr tom	by SharonT	3	317
retrieving data Jess	by vezerid	1	484
if bigger than Arne Hegefors	by Sandy Mann	2	371
Passing Arguments in Excell UB	by JE McGimpsey	3	667
Countif? DES	by DES	4	393
How can I save Excel subtotals without saving hidden (Level 3) r Judy Stumpf	by Judy Stumpf	0	567
Asking in a different way for petrol sheet help pano	by vezerid	1	393
Too many IF-AND, can LOOKUP do this? tommcbrny	by Bob Phillips	2	327
Maximum Louisq	by JE McGimpsey	1	806
Limiting Number of Times a Workbook can be Opened Dan R	by JE McGimpsey	1	694
Need task list that includes date and days + or - SharonT	by SharonT	4	358
Wildcard for Conditional Sum Wizard statement. Ron	by Ron	3	1,288
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,595
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,803
Cubed square root Damon Longworth	by Harlan Grove	8	860
Lookup array RD Wirr	by RD Wirr	5	454
how i can do programming in MS Excel.? Vishvapal	by Gary''s Student	1	509
Hide the formula in a cell. sansk_23	by Bob Phillips	1	372
Adding and subtracting time Terry Bennett	by Terry Bennett	2	774
array formula Tim	by Tim	4	344
help with creating function and figuring out formula monkeytrader	by David Biddulph	3	624
simple minus formula help S S	by Joerg	4	440