Excel Worksheet Functions - Page 586

Thread / Thread Starter	Last Post	Replies	Views
Count numbers in list Arne Hegefors	by Ron Coderre	6	543
Freeze Panes in Shared Workbook NealMed	by NealMed	0	971
sheet protection - only selected range to be able to select/input data Corey	by Gord Dibben	7	924
SumIf or SumProduct [email protected]	by T. Valko	8	645
Formatting Cells with Dates lls53	by JE McGimpsey	2	253
List last 5 non-zero entries Rayo K	by JMB	3	1,098
Condit Format? Make date change colors tkg	by David Biddulph	6	1,048
how do i join 2 "dqy" type queries in excel 2003 Joe	by Jim Thomlinson	1	827
Quotients in rows Sheba	by Gord Dibben	4	389
How do i put a cell reference in an If Function? ASAP robbie	by Robbie	2	411
Wildcards in SUMIF Function Ron	by Bob Phillips	9	771
Can I schedule a macro to run automatically at a certain time? Colibri_2[_2_]	by bpeltzer	1	1,562
Gosub - Goto ? El Bee	by Niek Otten	5	1,826
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL YKPURI	by JE McGimpsey	1	1,852
Cell Reference Gunhaver_06	by Gunhaver_06	1	503
Formulas within workbook but seperate sheets. kenmills2	by kenmills2	2	420
Adding data to create ranges jodieg	by jodieg	4	389
numbering rows in a filtered worksheet olga	by Debra Dalgleish	3	396
Excel 2000 to 2007 Ian	by Debra Dalgleish	2	372
Conversions dengel	by David Biddulph	2	453
Help with formula rael_lucid	by rael_lucid	5	334
Cummulative tjh	by driller	2	503
unique count with conditions jogre	by Bob Phillips	5	386
protected cells & sorting Jess	by Jess	0	512
How to find the value? Eric	by T. Valko	3	317
Ratio - How To Create Your Own Function/Formula Dawg House Inc	by Dawg House Inc	2	1,025
Counting DD:HH:MM NETWORKDAYS and Hours Oliver L Randle	by daddylonglegs	4	2,070
If cell B1 is 0 show number in cell A1 pano	by T. Valko	5	328
Finding out whether text is in a list or not Max	by Max	0	329
COUNTIF conundrum mmcap	by Ron Coderre	5	529
Subtotal Steved	by Steved	2	353
Vlookup does not return approx match djd	by T. Valko	7	976
Comparing two workbooks. Kevin Porter	by Max	1	407
formula bar displays "=RC[-12]+RC[-11]". how to get normal view? Laurent	by Laurent	3	5,375
How to hide a portion AS WELL AS it's formulas, then recalling FQGirl	by FQGirl	0	360
Can I put few buttons on an excell worksheet to filter according . Jazim	by FSt1	1	389
IRR & XIRR - Different Results Alex Morgan	by Alex Morgan[_2_]	10	4,460
Stopping formulas from changing when sorted Lehane	by Lehane	0	422
Sumproduct IF Q Sean	by Bob Phillips	4	419
Dynamic reference in OFFSET function manu	by Duke Carey	1	1,419
Countblank formula EElliott	by Rodrigo Ferreira	4	705
PRODUCT counting empty cells as 1 Supersonic	by Supersonic	3	556
If values are'nt entered in cell a popup window comes up?? pano	by Toppers	5	763
How to know the difference value of a cell from previous value. ramulu	by Sandy Mann	1	452
loss of fidelity message jon dougal	by Dave Peterson	2	1,059
Random numbers of 1-9 using only 4 numbers in each column Janet	by bj	4	972
$ sign for absolute reference Explanation pano	by bj	3	712
#DIV/0! Error - Need to display 0 or blank Brooks W.	by Brooks W.	5	1,252
Cash Flow for Investments Jeff Kahn	by Jeff Kahn	0	418
format a column from E605EQ1212 to E 605 EQ 1212 Scott at Scott	by Ron Rosenfeld	2	387
Can you calculate a cell name? and How to return a value from an adjacent cell? HK[_2_]	by vezerid	4	502
Number vs Text felipe_mfds	by Don Guillett	5	364
SubTotal for Sum function returning zeros ForestFeeder	by ForestFeeder	2	1,303
Gone Blank on formula - please help Nick Wakeham	by Nick Wakeham	2	406
FV with inconsistant cash flow [email protected]	by [email protected]	2	456
Look up a value in a table using both exact and approx matching Elbowes	by Elbowes	8	663
Data List - Total Row - Only displays "Total" Debbie Long	by Debbie Long	0	747
Summing Subtotals Exceller	by Exceller	4	573
lookup Jordan	by vezerid	3	427
Help: Vlookup, Index, Match, or Sumproduct? Phrank	by T. Valko	3	854
Lost text & fill colors from worksheet Basher Bates	by Gord Dibben	1	946
Setting password on worksheet in Excel 2000 Bill[_2_]	by JLatham	1	493
EXCEL M.GONZALEZ	by M.GONZALEZ[_2_]	2	343
VLOOKUP or HLOOKUP function question MMangen	by T. Valko	1	391
vlookup problem Jeanette	by Jeanette	4	423
syntax correction Richard	by Tom Ogilvy	4	480
min function on non consecutive rows bikemrh	by bikemrh	4	580
Count Unique Numbers Averitt Engineer	by Harlan Grove	6	594
Hyperlink to link to text, not just a cell Ben	by Dave Peterson	1	733
Testing for a consistent value counting blanks [email protected]	by Bernie Deitrick	1	412
disable Total and/or Sub total for a single column Voyager	by Roger Govier	3	638
Conditional Formatting of Merged Cells Fishman4	by Fishman4	7	1,083
find a character location in a string starting from the right funtipoom	by daddylonglegs	2	3,939
Nested 'IF', 'LOOKUP', 'AND' or 'INDEX', 'MATCH' JT	by JT	2	1,832
how do I link pivot table data into a separate document? Hendy	by Debra Dalgleish	1	662