Excel Worksheet Functions - Page 1039

Thread / Thread Starter	Last Post	Replies	Views
How do I add an apostrophy to a range of existing cells? stuck	by JoeU2004	3	623
subtract entries from allocated total until it reaches zero kirbydog	by Max	1	3,321
Using two hyphens in front of an Excel function. dlamarche	by dlamarche	4	5,616
Fill cell colour based on input in another cell Dan Wood[_2_]	by dlamarche	2	875
Formula for converting xx/xx/xxxx dates to a number between 1 and Rodney Reed	by Rick Rothstein	2	3,193
Match & Vlookup Function roter789	by dlamarche	1	696
logical functions Terri Farm[_2_]	by Rick Rothstein	6	773
How to select blank cells only whilst using sumproduct Romileyrunner1	by Jacob Skaria	1	760
Conditional Format - using 3 different cells conditions together j5b9721	by j5b9721	0	528
SUMPRODUCT ksel	by ksel	2	468
Marking new names connexion	by Eduardo	1	516
IF Lookup Formula Redi	by Redi	2	505
Count based on multiple criteria birdey	by Jacob Skaria	2	586
Another Formula Help with cell function[_2_]	by Eduardo	3	538
Nesting more than 7 IF statements (Excel 2003) Dee	by Pete_UK	7	1,076
Hidden cells KT	by Dave Peterson	1	660
Hidden cells expanding when completing calculation KT	by Dave Peterson	1	658
functioning of formulas Denise	by JP Ronse	3	564
Hyperlink to more than one file Tomas Stroem	by Tomas Stroem	2	623
CF, MACRO??? Tree	by Tree	3	431
XNPV Function David	by David	0	703
Excel2003 MAX and MIN with < hamricka[_3_]	by hamricka[_8_]	10	1,233
Sumif, unique counts, Chin Huat	by T. Valko	4	714
Average With < Continued hamricka[_7_]	by NBVC[_174_]	4	487
How to do summation of unique counts based on another variable? Chin Huat	by Bernd P	3	579
Deleting recuring data kjsmom98	by Bernie Deitrick	1	503
formula error Heather	by Heather	4	516
locking formulas in Excel 2007 so users can't change but can vieworiginal formula? Verna	by T. Valko	1	1,830
Alert in Microsoft Excel rayvn_	by rayvn_[_2_]	2	633
If statement 08/20/09 Angie G.[_2_]	by Angie G.[_2_]	3	500
Spell Check in Text Boxes Lee Ann[_2_]	by Lee Ann[_2_]	18	3,137
same picture different sheet Rhino V	by Rhino V	0	535
How to turn a number range into a date ljimages	by Teethless mama	2	609
Index roter789	by roter789	0	679
emailing a file Statindustry	by Gord Dibben	2	523
Copy Formula ONLY DebbieSue	by Gord Dibben	2	500
same picture different sheet Rhino V	by Rhino V	0	520
Sumif And Countif roter789	by roter789	7	791
Countdown days In Excel with conditional formating JR[_2_]	by Otto Moehrbach[_2_]	2	1,874
Formula rylv5050	by Pete_UK	1	447
How can I get Exel to display every (eg) 35th row only? browniebodrum	by Pete_UK	9	666
Short question on Datedif Basta1980	by OutsideObserver	4	637
worksheet tabs are cut off and can't see status bar MMcC	by Pete_UK	2	2,390
Date Range JeffK	by Jacob Skaria	2	416
Formula in CF dlamarche	by Dana DeLouis[_3_]	7	466
plus 6 months lesiofamily	by T. Valko	13	1,404
Nested formula...I think Diogie	by Jacob Skaria	1	483
Extracting and replacing the first word in a String of text RAYCV	by Jacob Skaria	5	697
hybrid formula H&Vlookup???? John Smith[_6_]	by Max	5	699
Nested If problem Harish Sharma[_2_]	by Pete_UK	3	644
Fomrulae to Hyperlink to cell in another tab with the same value/n KH76	by Pete_UK	8	1,630
Does Not Equal Orgelizer[_2_]	by Glenn	2	1,900
Nested If problem Harish Sharma[_2_]	by Squeaky	1	596
Conditional Formula with Words and different columns Misplaced Mainer	by Misplaced Mainer[_2_]	5	660
converting a text column to a number column & removing the ' Gayle from CyberCore	by RagDyeR	2	804
Accessing Other Sheet Tabs from within Excel Eric	by Tom Hutchins	4	678
formulas copying from sheet to sheet Troy[_2_]	by Troy[_2_]	6	592
editing a form and emailing without saving pdaws	by Susan	1	593
add leading zeros within a formula LG[_2_]	by T. Valko	2	2,070
add zeros to fill in and LG[_2_]	by LG[_2_]	0	551
add zeros to fill in and LG[_2_]	by LG[_2_]	0	707
Count the number of dates less than a given date mickblackburn2	by Luke M	1	1,988
Formulas with dates loulou	by Luke M	3	732
Creating a drop down which causes information to appear. kat21	by Gord Dibben	4	684
Data Validation marcia2026	by T. Valko	4	646
Logical Function DJ	by Pete_UK	1	573
Copy Data from One Spreadsheet to Another ?????? TLC	by Max	5	608
Counting Colors on a worksheet Loadmaster	by FSt1	1	490
number or working days Gibbyky2	by Bernd P	6	661
How do I calculate future date after number of days Vincent	by Per Jessen	1	1,470
Repeat formula for all cells in whole column Vincent	by Jacob Skaria	1	3,063
=counta() unless row is hidden Susan	by JLatham	5	1,004
Mirror Wildcard? thecdnmole	by Per Jessen	2	521
determining running counts phumpher	by ProfessionalExcel.com	5	678
Conditional Format - using 3 different cells conditions together j5b9721	by j5b9721	5	1,104