Excel Worksheet Functions - Page 1161

Thread / Thread Starter	Last Post	Replies	Views
sumproduct by year Jack Deuce	by Jack Deuce	2	837
Can XIRR Work on Dates That Move Backwards in Time? W	by joeu2004[_2_]	3	803
Ambiguous name detected: worksheet_change FlesburgT	by [email protected]	2	1,834
Missing data when using TREND function Jeremy Bowyer	by Jeremy Bowyer	1	797
sumproduct montypython	by joeu2004[_2_]	1	710
complex sort search and replace macro Colin Hayes	by Claus Busch	2	685
Line chart based on 3 columns galkas	by Spencer101	1	645
How Do I Find Different Values In A String? tb	by tb	2	505
Time/Date auto insert upon click Keyrookie	by Keyrookie	0	666
Numbers in word FEVOOO	by Claus Busch	1	650
Recurring Items in Spreadsheets Scaper	by GS[_2_]	2	879
Copying formulas across columns Ricardo[_3_]	by GS[_2_]	2	680
Filtering by text saltarazan	by saltarazan	0	609
How to ignore the in between cells? babapusy	by babapusy	0	649
Excel 2010 countifs for date range puck1263	by Spencer101	4	1,876
Concatenate cells with line breaks in them jerote	by Claus Busch	4	1,028
Sorting problem. My header rom is getting sorted with the rest. javaj	by [email protected]	2	669
Conditional Sum Based on Cell Background Color Thomas M.	by TreeHugger1	7	2,699
Autosize Merged Cell TreeHugger1	by TreeHugger1	0	623
Yes or blank, depending if value equals or exceeds value found inVLookup table. Steve[_16_]	by Steve[_16_]	4	792
Indicating where a range has overtime hours in a range of cells Baiona	by Baiona	3	766
Sumproduct giving #Value error KeriM	by KeriM	6	779
Rounding cents Håkan Björkström	by Claus Busch	4	739
Summing Results Based On A Specific Date JPP	by Spencer101	5	869
Adding another if statement to an index formula Icehockey44	by Icehockey44	0	728
=sum with a filter CJH	by Claus Busch	2	577
Year End totals Pamela Rease	by Pamela Rease	8	886
Sum Function has small remainder Hi I am Michael	by Hi I am Michael	2	797
Auto populate date VBA code Keyrookie	by Claus Busch	7	904
Length cutting optimizer CellShocked	by CellShocked	0	631
Rolling 12 month comp1	by comp1	9	1,418
Generating a cut list wabbleknee	by CellShocked	11	1,583
Formula to reference Cell Background Color TreeHugger1	by Ron Rosenfeld[_2_]	3	912
Solution to tricky problem of showing exactly Top N rows in Pivottable excelaroni	by excelaroni	0	657
Formula to predict future data Loztrailia	by joeu2004[_2_]	1	625
Show a cell's formula in text format in a linked cell TreeHugger1	by TreeHugger1	1	579
Elementary SUMPRODUCT Question Happens	by joeu2004[_2_]	3	643
using different sheets match string to specific work and enter that work in active MarkDuffy	by MarkDuffy	0	577
lookup two different variables [email protected]	by [email protected]	0	562
Show value from one cell in another cell if today falls between a date range perpetual159	by perpetual159	5	1,168
Looking up other sheet for value X depnding on sheet Y and Z colums zildjian	by [email protected]	1	722
To say number in words Frank Situmorang[_2_]	by [email protected]	6	1,012
If - Then Fields [email protected]	by Kevin@Radstock	2	606
Data Validation - Complex Q [email protected]	by [email protected]	2	601
IF funtion question escelnewbie	by escelnewbie	2	901
SUMIF "value if false" not working [email protected]	by [email protected]	2	945
Search closest day in the past from today Liquie	by Ron Rosenfeld[_2_]	2	712
Variable interest rate loan calculations- PLEASE HELP!!! AussieInNeed	by joeu2004[_2_]	1	765
conditional sum smithy4564	by Kevin@Radstock	5	880
Adding a VLookup to an AutoComplete ComboBox mw900000	by mw900000	0	747
Define a Range based on Cell Values a.c.sanchez	by plinius	3	1,014
vlookup formatting problem [email protected]	by MyVeryOwnSelf[_3_]	1	592
text to number graph sjoerdje92	by Living the Dream	4	696
adding a colon to military time Suzanne	by [email protected]	7	2,328
Go To a Named Range [email protected]	by Paga Mike	1	629
Divide a # into 3 #'s rounded to a whole # TreeHugger1	by TreeHugger1	2	690
somewhat complex if statement help PLEASE!!!! [email protected]	by joeu2004[_2_]	1	578
How Do I Avoid #REF! In Formulas? tb	by tb	5	1,170
renaming tabs to fit formulas themiz	by Spencer101	1	684
VB code. If statement between two values nappyjim	by Ron Rosenfeld[_2_]	1	808
Why is excel rounding my numbers in VBA? nappyjim	by joeu2004[_2_]	2	825
Moving Cells SprAmos	by SprAmos	0	715
Need help to update a column when Drop Down List is changed tanyag2	by tanyag2	0	710
VLOOKUP duplicate values in table the table array? Help me solve chase5lewis	by Kevin@Radstock	1	833
Complex formula aferguson3	by aferguson3	0	657
Returning a Date with Multiple Criteria Lookup Values Almellac	by Almellac	0	727
Fraction to Decimal Michael Dugan	by Ron Rosenfeld[_2_]	2	783
Inequalities Function EngAaron	by joeu2004[_2_]	3	964
Help! Need to compare 2 sets of data StiltsCC	by Spencer101	1	694
Can UDF return a customized hyperlink? [email protected]	by Living the Dream	3	697
Can we unprotect a Excel sheet having password by Save as Option . How do we unprotect Excel sheet?	by tweetoo123	2	2,198
Divide a # into 3 #'s rounded to a whole # TreeHugger1	by joeu2004[_2_]	7	1,032
Checking for date and time overlaps D3JAdwin	by D3JAdwin	0	680
I forgot my password, how do I open a sheet if I forgot the pass Hector Solorzano	by henrypotter04	4	1,925
using mid find to either extract a number with 2 decimals or excludeFROM A STRING [email protected]	by [email protected]	5	668