Excel Worksheet Functions - Page 809

Thread / Thread Starter	Last Post	Replies	Views
how to do a dynamic ranges? MadCow	by MadCow	2	552
Formula needed for 2 criteria Sue	by Dav	3	345
Indexing of Name Charlie	by Duke Carey	1	502
How do I count differert items in a column only if the date in an. Andy D	by Andy D	6	734
Can I freeze column A and scroll down the other columns in Excel? jlhudson	by jlhudson	5	1,114
UK Excel User Conference - July 19-21, 2006 Damon Longworth	by Damon Longworth	0	503
Bug Report for Excel David V.S.	by Ron Rosenfeld	1	569
min value ceemo	by ceemo	3	451
Excel Cell References are different to normal Diggsy	by bpeltzer	1	503
Using Countif when column A=Num and Column B=Yes CMO	by Ardus Petus	1	650
Adding up data in multiple cells for a single criteria. Philip	by Bob Phillips	1	1,210
how do I add a drop-down calendar in excel? MrsMac2000	by Bob Phillips	1	1,413
Help Please! - Creating Function Calculated Fields within Pivot Tables ColinS	by ColinS	0	978
how to use list in excel 2002 jeaNbLue	by EdMac	1	461
Rounding up/down problems ? Big Bad Nige	by Big Bad Nige	2	486
How to split worksheet to make smaller Ltl Doc	by Marijus	1	984
Navigation dgragg	by Marijus	1	530
What has happened to "Save As" in Excel 2003 Neil	by Biff	9	1,086
I want to be able to create a dynamic reference in excel, for exam Lee	by Biff	4	637
Stumped: If a cell contains a formula, can you make text color automatically change? qwopzxnm	by Max	7	2,186
unable to grasp SUMPRODUCT toddbob	by JMB	4	385
Macros Feene	by JMB	2	382
Highest value in column b returning column a macamarr	by macamarr	3	570
making gains or losses appear red or black in formula Blane	by Ron Coderre	1	880
Ranking on basis of 3 Parameters junoon	by junoon	0	486
Subtracting From 2 Cells scw1217	by scw1217	2	706
annual percentage return Stephen Watson	by Fred Smith	2	693
ReCalc'ing for almost everything I do Conan Kelly	by [email protected]	9	415
NPV IRR MIRR Santa Claus	by Fred Smith	3	1,001
How to format 39.5 to 39.5% Penny	by Fred Smith	3	328
if statements Merge	by Domenic	8	427
Excel Conditional sum, lookups and functions help PLEASE!! Billjary	by Pete_UK	1	549
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	347
return value other than #N/A mtbrindamour via OfficeKB.com	by Gord Dibben	2	338
Conditional Formatting Courtney	by Courtney	0	364
macro security too high in excel, I can not get into input data Diane	by Otto Moehrbach	5	732
Separating text and data in a column Amber	by Gord Dibben	1	394
hyperlink in combo box/data validation Dannycol	by Dannycol	0	557
cell painting idem idem	by Gord Dibben	2	513
Display a "0" when #N/A appears in formula DarnTootn	by DarnTootn	3	547
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,476
Macros Feene	by Feene	0	337
How do I circle a number in excel Dan Butler	by Peo Sjoblom	1	1,733
adding to different totals dependant upon selection from drop down Shaunnyb	by Shaunnyb	0	463
Mortage Calculations John in Surrey	by John in Surrey	2	384
Formula to a number can you tell scott	by Otto Moehrbach	3	319
how to retrieve information that was saved on a floppy disk? ASHA	by Mark Lincoln	1	601
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	512
Suggestion IGFET909	by Gord Dibben	5	515
elapsed time problems MeredithS	by MeredithS	0	460
edate function I Cruz	by Niek Otten	1	641
how do I update the scenario summary sheet? JEM	by JEM	0	847
Excel links Pat	by JR	1	369
find a value in a table, go to the previous column and add that co Paul	by JR	1	596
sum column containing both text and numbers cbuck	by Kevin Vaughn	4	1,160
stuck with macros vicvega	by vicvega	0	346
Comments in Excel JP	by JP	2	659
Can I lock worksheet reference? Kathleen	by JR	1	441
Formatting Bridget	by JR	1	368
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	464
number lookup wcthrill	by JR	1	486
Help with formula Cliff	by SteveG	6	316
Date Value lmullenjr	by Biff	3	313
Cumulative Average Daryl	by Daryl	2	513
sum if conditions in two columns are met? Agallagher	by Biff	4	735
How do I get the MAX value of adjoining columns then SUM range? Dorothy	by Bob Phillips	1	516
Help for sumif / sumproduct jitu_tikili	by jitu_tikili	5	467
Rank a changing row amy	by Ron Coderre	3	407
how do i change an incorrect amount in a cloumn after download george	by george	0	390