Excel Worksheet Functions - Page 809

Thread / Thread Starter	Last Post	Replies	Views
how to do a dynamic ranges? MadCow	by MadCow	2	557
Formula needed for 2 criteria Sue	by Dav	3	345
Indexing of Name Charlie	by Duke Carey	1	515
How do I count differert items in a column only if the date in an. Andy D	by Andy D	6	744
Can I freeze column A and scroll down the other columns in Excel? jlhudson	by jlhudson	5	1,116
UK Excel User Conference - July 19-21, 2006 Damon Longworth	by Damon Longworth	0	504
Bug Report for Excel David V.S.	by Ron Rosenfeld	1	578
min value ceemo	by ceemo	3	459
Excel Cell References are different to normal Diggsy	by bpeltzer	1	509
Using Countif when column A=Num and Column B=Yes CMO	by Ardus Petus	1	664
Adding up data in multiple cells for a single criteria. Philip	by Bob Phillips	1	1,214
how do I add a drop-down calendar in excel? MrsMac2000	by Bob Phillips	1	1,424
Help Please! - Creating Function Calculated Fields within Pivot Tables ColinS	by ColinS	0	988
how to use list in excel 2002 jeaNbLue	by EdMac	1	474
Rounding up/down problems ? Big Bad Nige	by Big Bad Nige	2	493
How to split worksheet to make smaller Ltl Doc	by Marijus	1	987
Navigation dgragg	by Marijus	1	530
What has happened to "Save As" in Excel 2003 Neil	by Biff	9	1,089
I want to be able to create a dynamic reference in excel, for exam Lee	by Biff	4	639
Stumped: If a cell contains a formula, can you make text color automatically change? qwopzxnm	by Max	7	2,189
unable to grasp SUMPRODUCT toddbob	by JMB	4	385
Macros Feene	by JMB	2	391
Highest value in column b returning column a macamarr	by macamarr	3	579
making gains or losses appear red or black in formula Blane	by Ron Coderre	1	881
Ranking on basis of 3 Parameters junoon	by junoon	0	488
Subtracting From 2 Cells scw1217	by scw1217	2	708
annual percentage return Stephen Watson	by Fred Smith	2	694
ReCalc'ing for almost everything I do Conan Kelly	by [email protected]	9	418
NPV IRR MIRR Santa Claus	by Fred Smith	3	1,004
How to format 39.5 to 39.5% Penny	by Fred Smith	3	329
if statements Merge	by Domenic	8	431
Excel Conditional sum, lookups and functions help PLEASE!! Billjary	by Pete_UK	1	559
use Now() in two cells for start and finish times DaveM	by Pete_UK	1	761
can this function do this? freestyle	by Pete_UK	1	355
return value other than #N/A mtbrindamour via OfficeKB.com	by Gord Dibben	2	344
Conditional Formatting Courtney	by Courtney	0	375
macro security too high in excel, I can not get into input data Diane	by Otto Moehrbach	5	742
Separating text and data in a column Amber	by Gord Dibben	1	406
hyperlink in combo box/data validation Dannycol	by Dannycol	0	567
cell painting idem idem	by Gord Dibben	2	513
Display a "0" when #N/A appears in formula DarnTootn	by DarnTootn	3	555
How to Share & "Un-Share" Worksheets crwiseman	by tdicapua	1	752
Formula that will test text conditions in a single cell Prohock	by Prohock	10	1,477
Macros Feene	by Feene	0	342
How do I circle a number in excel Dan Butler	by Peo Sjoblom	1	1,739
adding to different totals dependant upon selection from drop down Shaunnyb	by Shaunnyb	0	470
Mortage Calculations John in Surrey	by John in Surrey	2	387
Formula to a number can you tell scott	by Otto Moehrbach	3	322
how to retrieve information that was saved on a floppy disk? ASHA	by Mark Lincoln	1	608
Excel Form and Data Retrieval Johnny New Englander	by Johnny New Englander	0	716
Invoice Comparison Terrell	by Terrell	0	465
How can I use one formula to change case on an entire worksheet? pow835	by Gord Dibben	2	841
Conditional Expression in cell TPB	by TPB	3	519
Suggestion IGFET909	by Gord Dibben	5	515
elapsed time problems MeredithS	by MeredithS	0	460
edate function I Cruz	by Niek Otten	1	646
how do I update the scenario summary sheet? JEM	by JEM	0	847
Excel links Pat	by JR	1	381
find a value in a table, go to the previous column and add that co Paul	by JR	1	606
sum column containing both text and numbers cbuck	by Kevin Vaughn	4	1,166
stuck with macros vicvega	by vicvega	0	348
Comments in Excel JP	by JP	2	671
Can I lock worksheet reference? Kathleen	by JR	1	441
Formatting Bridget	by JR	1	372
I need a payroll sheet that can auto update figures each week Sheila	by JR	1	1,041
Cell reference between worksheets jitu_tikili	by JR	1	465
number lookup wcthrill	by JR	1	487
Help with formula Cliff	by SteveG	6	317
Date Value lmullenjr	by Biff	3	314
Cumulative Average Daryl	by Daryl	2	514
sum if conditions in two columns are met? Agallagher	by Biff	4	748
How do I get the MAX value of adjoining columns then SUM range? Dorothy	by Bob Phillips	1	529
Help for sumif / sumproduct jitu_tikili	by jitu_tikili	5	470
Rank a changing row amy	by Ron Coderre	3	410
how do i change an incorrect amount in a cloumn after download george	by george	0	390