Excel Worksheet Functions - Page 20

Thread / Thread Starter	Last Post	Replies	Views
adding up time over & under a specified amount BookWight	by BookWight	3	605
Mapping strings to integers Walter Briscoe	by Claus Busch	6	566
Conditional Formatting help (2003) Jooniper	by Claus Busch	1	562
Alternate Row Shading with Filter Hadders	by Claus Busch	1	720
Vlookup? rednews07	by [email protected]	1	517
Mapping integers to strings Walter Briscoe	by Claus Busch	6	896
Help With Formula for Posting JoannieMaj	by JoannieMaj	5	1,084
Finding dynamic maxima Walter Briscoe	by Ron Rosenfeld[_2_]	10	1,347
How to record changing value of a cell RB[_2_]	by CellShocked	2	769
Force Distribution/ Force Ranking for Bell Curve moskau	by joeu2004[_2_]	1	3,765
3 IFs argument in one formula Cherrygrocery	by Calicojack	2	962
comapering two sheets in excel 2010 Marin[_2_]	by Marin[_2_]	0	514
Underline % format Will Fleenor	by txaggie90	5	905
Pulling background color from master to other sheet jkriesel	by Claus Busch	2	532
Dragging a formula down isn't working - where am I going wrong? CJoQ	by Claus Busch	2	639
Unhide column difficulty Walter Briscoe	by Walter Briscoe	3	566
Searching for text and returning text GreggyR	by Claus Busch	1	568
Copy and shift data automaticaly Karolus	by Karolus	0	570
IF Statement Table Help arceaf	by Claus Busch	1	580
Function or Sub to help with text string Jack Deuce	by Jack Deuce	5	636
Text Dates/times to d:hh:mm:ss Bigskenney	by Ron Rosenfeld[_2_]	6	1,154
finding repeating numerical pattern using array functions? [email protected]	by [email protected]	0	684
Formula for calculating target hours against actual hours Bootface	by Bootface	12	1,522
How do I create a formula that will refresh weekly anich22	by anich22	0	546
Questionnaire using Excel RB[_2_]	by GS[_2_]	3	634
Problems when using Date() function. Jan Kronsell[_5_]	by Ron Rosenfeld[_2_]	2	477
How do you Combine Two IF formulas Ardy	by Ardy	4	722
Cumulative sum, based on previous data downhillsheep	by Spencer101	1	614
Macro to change referenced column to the next one slvrd	by Claus Busch	1	487
Circular Reference Warning ??? Soth	by [email protected]	2	1,274
Text from one sheet cell to appear in another sheet cell mduck	by Hellbent706	6	3,201
Formula to separate cell values in a column with commas PuffyGrl82	by juancito	3	4,665
if and replace function? [email protected]	by [email protected]	5	693
Generate series according to range and increment primeride2k	by Claus Busch	5	781
Automatically populate value of cell dependent on adajecent cell Crystal84	by Crystal84	3	789
Advanced Drop-down Menu Jaz3385	by [email protected]	2	729
Varying cell ranges in formulas according to number of cells with certain value Dranoeler	by Claus Busch	1	787
Rosters, Dates and Displays Christian Michael	by Capt. Cave Man	1	643
Formula to add two spaces into a number stored as text [email protected]	by Ron Rosenfeld[_2_]	4	645
Dynamic Ranges Adding Extra Row KeriM	by KeriM	2	569
Recover Excel file that was saved over Myra	by [email protected]	9	5,447
CONDITIONAL FORMATTING IN EXCEL 2010 Malcolm Austin	by Claus Busch	1	753
Comparing two lists RB[_2_]	by RB[_2_]	0	679
2 Formulas needed!!! :) aswasis	by Mazzaropi	16	1,809
Multiple VLOOKUP lookup values SkyTheImmense	by [email protected]	1	610
Nameing a function Leslie Charles	by Leslie Charles	1	639
Removing #N/A from an "If/Then" statement Collin Ulvund	by Claus Busch	4	811
Converting a number into a cell reference szwanger	by Gord Dibben[_2_]	2	748
using duplicate function RB[_2_]	by GS[_2_]	17	1,502
Index Match & #values DanielF	by DanielF	0	557
subtract a positive from a negative wolfman	by Gord Dibben[_2_]	7	1,961
SUMIF with criteria "<" & "=" MikeG[_2_]	by GS[_2_]	4	621
Military Rate/Rank Formula TechD87	by Mazzaropi	1	836
Look up one value and return multiple corresponding values Faye1986	by Claus Busch	2	750
Problems with conditional average Jan Kronsell[_5_]	by Jan Kronsell[_5_]	2	553
conditional if loop ajay singh	by ajay singh	0	543
adding a forumla to cells with formula in them already iVassh	by Gord Dibben[_2_]	1	572
Nesting "indirect" within "sumifs" Hokie_16	by WPierce	3	1,248
Help with an if then scenario iVassh	by iVassh	2	546
Change cell color in protected sheet ansa	by Nic Rigden	2	2,797
COUNTIFS using multiple named ranges in the criteria u828576	by u828576	0	480
Excel PMT Function Help Harkins1721	by Harkins1721	2	1,062
Conditional Formatting kellyluise	by GS[_2_]	6	856
Custom Autonumber with Prefix and Category Grouping dlireland	by dlireland	3	715
Finding a Name chandan12	by chandan12	2	564
problem with time subtraction lozzauk13	by Claus Busch	7	962
VLOOKUP Keeps Returning #N/A Ric_M	by Katie & Emil	7	3,408
Displaying Returns from another worksheet that change? MichaelPK	by MyVeryOwnSelf[_3_]	3	659
Find the next row... dmarzean	by dmarzean	0	469
If Formula and Dates perpetual159	by Ron Rosenfeld[_2_]	4	842
Counting multiple occcurrences between date range KH3557	by KH3557	3	639
Excel 2003 formula Henzoo	by Mazzaropi	1	589
weekday last year Rob Nance	by Rob Nance	2	490
drag formula down from columns that go acros [email protected]	by [email protected]	3	609
Curly Brackets tb	by tb	2	600