Excel Worksheet Functions - Page 20

Thread / Thread Starter	Last Post	Replies	Views
adding up time over & under a specified amount BookWight	by BookWight	3	616
Mapping strings to integers Walter Briscoe	by Claus Busch	6	580
Conditional Formatting help (2003) Jooniper	by Claus Busch	1	569
Alternate Row Shading with Filter Hadders	by Claus Busch	1	734
Vlookup? rednews07	by [email protected]	1	523
Mapping integers to strings Walter Briscoe	by Claus Busch	6	913
Help With Formula for Posting JoannieMaj	by JoannieMaj	5	1,096
Finding dynamic maxima Walter Briscoe	by Ron Rosenfeld[_2_]	10	1,367
How to record changing value of a cell RB[_2_]	by CellShocked	2	780
Force Distribution/ Force Ranking for Bell Curve moskau	by joeu2004[_2_]	1	3,837
3 IFs argument in one formula Cherrygrocery	by Calicojack	2	980
comapering two sheets in excel 2010 Marin[_2_]	by Marin[_2_]	0	525
Underline % format Will Fleenor	by txaggie90	5	939
Pulling background color from master to other sheet jkriesel	by Claus Busch	2	548
Dragging a formula down isn't working - where am I going wrong? CJoQ	by Claus Busch	2	645
Unhide column difficulty Walter Briscoe	by Walter Briscoe	3	586
Searching for text and returning text GreggyR	by Claus Busch	1	577
Copy and shift data automaticaly Karolus	by Karolus	0	587
IF Statement Table Help arceaf	by Claus Busch	1	592
Function or Sub to help with text string Jack Deuce	by Jack Deuce	5	648
Text Dates/times to d:hh:mm:ss Bigskenney	by Ron Rosenfeld[_2_]	6	1,172
finding repeating numerical pattern using array functions? [email protected]	by [email protected]	0	693
Formula for calculating target hours against actual hours Bootface	by Bootface	12	1,542
How do I create a formula that will refresh weekly anich22	by anich22	0	562
Questionnaire using Excel RB[_2_]	by GS[_2_]	3	650
Problems when using Date() function. Jan Kronsell[_5_]	by Ron Rosenfeld[_2_]	2	492
How do you Combine Two IF formulas Ardy	by Ardy	4	740
Cumulative sum, based on previous data downhillsheep	by Spencer101	1	628
Macro to change referenced column to the next one slvrd	by Claus Busch	1	533
Circular Reference Warning ??? Soth	by [email protected]	2	1,307
Text from one sheet cell to appear in another sheet cell mduck	by Hellbent706	6	3,395
Formula to separate cell values in a column with commas PuffyGrl82	by juancito	3	4,699
if and replace function? [email protected]	by [email protected]	5	711
Generate series according to range and increment primeride2k	by Claus Busch	5	796
Automatically populate value of cell dependent on adajecent cell Crystal84	by Crystal84	3	809
Advanced Drop-down Menu Jaz3385	by [email protected]	2	745
Varying cell ranges in formulas according to number of cells with certain value Dranoeler	by Claus Busch	1	805
Rosters, Dates and Displays Christian Michael	by Capt. Cave Man	1	650
Formula to add two spaces into a number stored as text [email protected]	by Ron Rosenfeld[_2_]	4	657
Dynamic Ranges Adding Extra Row KeriM	by KeriM	2	582
Recover Excel file that was saved over Myra	by [email protected]	9	5,466
CONDITIONAL FORMATTING IN EXCEL 2010 Malcolm Austin	by Claus Busch	1	765
Comparing two lists RB[_2_]	by RB[_2_]	0	703
2 Formulas needed!!! :) aswasis	by Mazzaropi	16	1,818
Multiple VLOOKUP lookup values SkyTheImmense	by [email protected]	1	627
Nameing a function Leslie Charles	by Leslie Charles	1	648
Removing #N/A from an "If/Then" statement Collin Ulvund	by Claus Busch	4	827
Converting a number into a cell reference szwanger	by Gord Dibben[_2_]	2	761
using duplicate function RB[_2_]	by GS[_2_]	17	1,519
Index Match & #values DanielF	by DanielF	0	568
subtract a positive from a negative wolfman	by Gord Dibben[_2_]	7	1,985
SUMIF with criteria "<" & "=" MikeG[_2_]	by GS[_2_]	4	634
Military Rate/Rank Formula TechD87	by Mazzaropi	1	870
Look up one value and return multiple corresponding values Faye1986	by Claus Busch	2	805
Problems with conditional average Jan Kronsell[_5_]	by Jan Kronsell[_5_]	2	567
conditional if loop ajay singh	by ajay singh	0	556
adding a forumla to cells with formula in them already iVassh	by Gord Dibben[_2_]	1	585
Nesting "indirect" within "sumifs" Hokie_16	by WPierce	3	1,275
Help with an if then scenario iVassh	by iVassh	2	566
Change cell color in protected sheet ansa	by Nic Rigden	2	2,821
COUNTIFS using multiple named ranges in the criteria u828576	by u828576	0	489
Excel PMT Function Help Harkins1721	by Harkins1721	2	1,083
Conditional Formatting kellyluise	by GS[_2_]	6	880
Custom Autonumber with Prefix and Category Grouping dlireland	by dlireland	3	724
Finding a Name chandan12	by chandan12	2	570
problem with time subtraction lozzauk13	by Claus Busch	7	986
VLOOKUP Keeps Returning #N/A Ric_M	by Katie & Emil	7	3,419
Displaying Returns from another worksheet that change? MichaelPK	by MyVeryOwnSelf[_3_]	3	670
Find the next row... dmarzean	by dmarzean	0	480
If Formula and Dates perpetual159	by Ron Rosenfeld[_2_]	4	856
Counting multiple occcurrences between date range KH3557	by KH3557	3	648
Excel 2003 formula Henzoo	by Mazzaropi	1	600
weekday last year Rob Nance	by Rob Nance	2	500
drag formula down from columns that go acros [email protected]	by [email protected]	3	626
Curly Brackets tb	by tb	2	609