Excel Worksheet Functions - Page 504

Thread / Thread Starter	Last Post	Replies	Views
Time Calculation ypurcaro	by joeu2004[_2_]	3	831
Name Farming Christian Michael	by Christian Michael	3	651
Need help with a formula dpsgolfer	by Ron Rosenfeld[_2_]	3	663
Needs help combining functions. gargamel875	by gargamel875	3	717
Count Word in long string tamer	by Claus Busch	3	598
Delete Text in Multiple Cells hbcobra	by Claus Busch	3	772
Help with lots of formulas always28smiling	by always28smiling	3	696
Sumproduct? [email protected]	by [email protected]	3	571
Function for summing or counting cells based on a specified fill color shriil	by shriil	3	749
Conditional Formatting Esradekan	by Esradekan	3	771
Sumproduct Help! [email protected]	by [email protected]	3	553
Inequalities Function EngAaron	by joeu2004[_2_]	3	958
Can UDF return a customized hyperlink? [email protected]	by Living the Dream	3	697
Define a Range based on Cell Values a.c.sanchez	by plinius	3	1,012
Elementary SUMPRODUCT Question Happens	by joeu2004[_2_]	3	640
Formula to reference Cell Background Color TreeHugger1	by Ron Rosenfeld[_2_]	3	911
Indicating where a range has overtime hours in a range of cells Baiona	by Baiona	3	766
Can XIRR Work on Dates That Move Backwards in Time? W	by joeu2004[_2_]	3	799
multiple SUMIF help/advice Lapo Zanuso	by Lapo Zanuso	3	676
Automatically populate value of cell dependent on adajecent cell Crystal84	by Crystal84	3	790
Is it Possible? Jham	by Tristan Goderis	3	547
Nested IF AND OR statement Colin Hayes	by Colin Hayes	3	540
Supress DIV/0 Colin Hayes	by Colin Hayes	3	653
Excel help separating / [email protected]	by James M[_3_]	3	670
=substitute Kalop	by Stan Brown	3	585
excel copy and paste... Menestrello	by [email protected]	3	738
adding up time over & under a specified amount BookWight	by BookWight	3	608
Unhide column difficulty Walter Briscoe	by Walter Briscoe	3	569
Questionnaire using Excel RB[_2_]	by GS[_2_]	3	637
Find partial text and retrun value in corresponding column [email protected]	by MyVeryOwnSelf[_3_]	3	659
Custom Autonumber with Prefix and Category Grouping dlireland	by dlireland	3	720
Nesting "indirect" within "sumifs" Hokie_16	by WPierce	3	1,248
drag formula down from columns that go acros [email protected]	by [email protected]	3	610
Counting multiple occcurrences between date range KH3557	by KH3557	3	642
Displaying Returns from another worksheet that change? MichaelPK	by MyVeryOwnSelf[_3_]	3	659
Multiple IF conditions Lestat	by GS[_2_]	3	640
Net Present Worth of reptitive costs? dexoey	by Financial Engineer	3	1,212
If then formula with multiple Ifs R&I Guy	by R&I Guy	3	857
rename worksheet tabs fix me	by EliMar	3	1,766
Convert number to text as displayed [email protected]	by Ron Rosenfeld[_2_]	3	923
Possible to determine whether any one instance within many satisfy a criteria? spamdavy	by spamdavy	3	948
Deriving several lists from a master list John Tonitto	by John Tonitto	3	925
Excel time leading 1st ZERO Jaime[_4_]	by [email protected]	3	818
Findiing highest and lowest in rows and columns NetNathan1	by NetNathan1	3	816
Joining VLookups with line breaks but ignoring blanks Andy Roberts[_3_]	by Ron Rosenfeld[_2_]	3	1,022
Excel Template required for Daily managing daily income and expense at Mobile shop nevillmehta	by [email protected]	3	2,218
Formula to separate cell values in a column with commas PuffyGrl82	by juancito	3	4,688
Finding most recent date for each customer - XL 2007 Geoff B	by Drea17	3	2,752
Formulas won't function mapnet	by [email protected]	3	863
How can I stop format change when copying data into unlocked cells Linty	by GraemeW	3	4,637
remove headers & Footers Excel 2007 Joel	by [email protected]	3	1,447
Excel Bank Statement reconciliation templates or??? Excel Spreadsheet for Bank Statements	by Milton[_2_]	3	1,540
Using VLookup when text isn't an exact match Ken K	by [email protected]	3	974
Count everything in a Column "except" Richard Horn[_2_]	by aynosgold	3	2,878
Convert number to word in indian currency Sudipta Sen[_2_]	by Arpit Dewan	3	6,403
Benford law option available in Microsoft Excel Auditor	by [email protected]	3	2,034
Combining Nested IF statement with Between operator Daisy	by gid951	3	2,675
Help. Trying to do the opposite of VLOOKUP Randy Sauve	by plinius	3	1,073
SUBTOTAL not updating correctly DVEINTIMILLA	by DVEINTIMILLA	3	2,138
IF Statement for Selection garygoodguy	by GS[_2_]	3	797
Copy columns, but not hidden ones Duncs	by Claus Busch	3	683
Index Match Max? Zsoup	by Kevin@Radstock	3	765
Match/Index/Sum function with date range JonathanK1	by JonathanK1	3	1,013
Calendar Logic: Recurring Dates Talka	by Maurizio Borrelli	3	1,134
COUNTING THE SAME VALUES IN A SHEET naga rajan	by Claus Busch	3	723
sorting noncontiguous data with exceptions al drah	by plinius	3	873
I can't see the cell reference (i.e A, B, C, 1, 2, 3). How do I . Aimee T	by Zulma	3	1,202
Setting a range in a named range Askjerry	by Ron Rosenfeld[_2_]	3	739
Help Needed! Using complex IF function John Ball	by joeu2004[_2_]	3	988
Help needed: Minimum value based upon either/or criteria Mfreit	by Mfreit	3	817
Extract the 2 Lowest % [email protected]	by [email protected]	3	749
Extract Alphabets and Numbers from a Cell tahir4awan	by Spencer101	3	883
range definition by cells numbers tuli	by tuli	3	828
Multiple Criteria Lookup JIMCREWE	by JIMCREWE	3	850
Conditional Formatting Formula deutz	by Living the Dream	3	929