Excel Worksheet Functions - Page 809

Thread / Thread Starter	Last Post	Replies	Views
how to do a dynamic ranges? MadCow	by MadCow	2	533
Formula needed for 2 criteria Sue	by Dav	3	335
Indexing of Name Charlie	by Duke Carey	1	488
How do I count differert items in a column only if the date in an. Andy D	by Andy D	6	713
Can I freeze column A and scroll down the other columns in Excel? jlhudson	by jlhudson	5	1,081
UK Excel User Conference - July 19-21, 2006 Damon Longworth	by Damon Longworth	0	468
Bug Report for Excel David V.S.	by Ron Rosenfeld	1	552
min value ceemo	by ceemo	3	436
Excel Cell References are different to normal Diggsy	by bpeltzer	1	486
Using Countif when column A=Num and Column B=Yes CMO	by Ardus Petus	1	644
Adding up data in multiple cells for a single criteria. Philip	by Bob Phillips	1	1,179
how do I add a drop-down calendar in excel? MrsMac2000	by Bob Phillips	1	1,403
Help Please! - Creating Function Calculated Fields within Pivot Tables ColinS	by ColinS	0	945
how to use list in excel 2002 jeaNbLue	by EdMac	1	446
Rounding up/down problems ? Big Bad Nige	by Big Bad Nige	2	470
How to split worksheet to make smaller Ltl Doc	by Marijus	1	935
Navigation dgragg	by Marijus	1	519
What has happened to "Save As" in Excel 2003 Neil	by Biff	9	1,057
I want to be able to create a dynamic reference in excel, for exam Lee	by Biff	4	615
Stumped: If a cell contains a formula, can you make text color automatically change? qwopzxnm	by Max	7	2,158
unable to grasp SUMPRODUCT toddbob	by JMB	4	379
Macros Feene	by JMB	2	374
Highest value in column b returning column a macamarr	by macamarr	3	550
making gains or losses appear red or black in formula Blane	by Ron Coderre	1	867
Ranking on basis of 3 Parameters junoon	by junoon	0	480
Subtracting From 2 Cells scw1217	by scw1217	2	691
annual percentage return Stephen Watson	by Fred Smith	2	672
ReCalc'ing for almost everything I do Conan Kelly	by [email protected]	9	409
NPV IRR MIRR Santa Claus	by Fred Smith	3	991
How to format 39.5 to 39.5% Penny	by Fred Smith	3	320
if statements Merge	by Domenic	8	415
Excel Conditional sum, lookups and functions help PLEASE!! Billjary	by Pete_UK	1	526
use Now() in two cells for start and finish times DaveM	by Pete_UK	1	729
can this function do this? freestyle	by Pete_UK	1	340
return value other than #N/A mtbrindamour via OfficeKB.com	by Gord Dibben	2	330
Conditional Formatting Courtney	by Courtney	0	357
macro security too high in excel, I can not get into input data Diane	by Otto Moehrbach	5	707
Separating text and data in a column Amber	by Gord Dibben	1	379
hyperlink in combo box/data validation Dannycol	by Dannycol	0	540
cell painting idem idem	by Gord Dibben	2	499
Display a "0" when #N/A appears in formula DarnTootn	by DarnTootn	3	527
How to Share & "Un-Share" Worksheets crwiseman	by tdicapua	1	742
Formula that will test text conditions in a single cell Prohock	by Prohock	10	1,400
Macros Feene	by Feene	0	330
How do I circle a number in excel Dan Butler	by Peo Sjoblom	1	1,693
adding to different totals dependant upon selection from drop down Shaunnyb	by Shaunnyb	0	439
Mortage Calculations John in Surrey	by John in Surrey	2	364
Formula to a number can you tell scott	by Otto Moehrbach	3	306
how to retrieve information that was saved on a floppy disk? ASHA	by Mark Lincoln	1	587
Excel Form and Data Retrieval Johnny New Englander	by Johnny New Englander	0	696
Invoice Comparison Terrell	by Terrell	0	450
How can I use one formula to change case on an entire worksheet? pow835	by Gord Dibben	2	762
Conditional Expression in cell TPB	by TPB	3	497
Suggestion IGFET909	by Gord Dibben	5	463
elapsed time problems MeredithS	by MeredithS	0	437
edate function I Cruz	by Niek Otten	1	626
how do I update the scenario summary sheet? JEM	by JEM	0	824
Excel links Pat	by JR	1	363
find a value in a table, go to the previous column and add that co Paul	by JR	1	588
sum column containing both text and numbers cbuck	by Kevin Vaughn	4	1,137
stuck with macros vicvega	by vicvega	0	337
Comments in Excel JP	by JP	2	642
Can I lock worksheet reference? Kathleen	by JR	1	432
Formatting Bridget	by JR	1	362
I need a payroll sheet that can auto update figures each week Sheila	by JR	1	1,028
Cell reference between worksheets jitu_tikili	by JR	1	437
number lookup wcthrill	by JR	1	478
Help with formula Cliff	by SteveG	6	312
Date Value lmullenjr	by Biff	3	301
Cumulative Average Daryl	by Daryl	2	505
sum if conditions in two columns are met? Agallagher	by Biff	4	725
How do I get the MAX value of adjoining columns then SUM range? Dorothy	by Bob Phillips	1	494
Help for sumif / sumproduct jitu_tikili	by jitu_tikili	5	452
Rank a changing row amy	by Ron Coderre	3	394
how do i change an incorrect amount in a cloumn after download george	by george	0	373