Excel Worksheet Functions - Page 23

Thread / Thread Starter	Last Post	Replies	Views
Adding a VLookup to an AutoComplete ComboBox mw900000	by mw900000	0	760
conditional sum smithy4564	by Kevin@Radstock	5	897
Variable interest rate loan calculations- PLEASE HELP!!! AussieInNeed	by joeu2004[_2_]	1	787
Search closest day in the past from today Liquie	by Ron Rosenfeld[_2_]	2	721
SUMIF "value if false" not working [email protected]	by [email protected]	2	959
IF funtion question escelnewbie	by escelnewbie	2	910
Data Validation - Complex Q [email protected]	by [email protected]	2	608
If - Then Fields [email protected]	by Kevin@Radstock	2	617
To say number in words Frank Situmorang[_2_]	by [email protected]	6	1,023
Looking up other sheet for value X depnding on sheet Y and Z colums zildjian	by [email protected]	1	734
Show value from one cell in another cell if today falls between a date range perpetual159	by perpetual159	5	1,182
lookup two different variables [email protected]	by [email protected]	0	571
using different sheets match string to specific work and enter that work in active MarkDuffy	by MarkDuffy	0	582
Elementary SUMPRODUCT Question Happens	by joeu2004[_2_]	3	650
Show a cell's formula in text format in a linked cell TreeHugger1	by TreeHugger1	1	597
Formula to predict future data Loztrailia	by joeu2004[_2_]	1	634
Solution to tricky problem of showing exactly Top N rows in Pivottable excelaroni	by excelaroni	0	670
Formula to reference Cell Background Color TreeHugger1	by Ron Rosenfeld[_2_]	3	924
Generating a cut list wabbleknee	by CellShocked	11	1,595
Rolling 12 month comp1	by comp1	9	1,463
Length cutting optimizer CellShocked	by CellShocked	0	650
Auto populate date VBA code Keyrookie	by Claus Busch	7	955
Sum Function has small remainder Hi I am Michael	by Hi I am Michael	2	804
Year End totals Pamela Rease	by Pamela Rease	8	897
=sum with a filter CJH	by Claus Busch	2	584
Adding another if statement to an index formula Icehockey44	by Icehockey44	0	797
Summing Results Based On A Specific Date JPP	by Spencer101	5	885
Rounding cents Håkan Björkström	by Claus Busch	4	754
Sumproduct giving #Value error KeriM	by KeriM	6	793
Indicating where a range has overtime hours in a range of cells Baiona	by Baiona	3	785
Yes or blank, depending if value equals or exceeds value found inVLookup table. Steve[_16_]	by Steve[_16_]	4	799
Autosize Merged Cell TreeHugger1	by TreeHugger1	0	638
Conditional Sum Based on Cell Background Color Thomas M.	by TreeHugger1	7	2,745
Sorting problem. My header rom is getting sorted with the rest. javaj	by [email protected]	2	678
Concatenate cells with line breaks in them jerote	by Claus Busch	4	1,037
Excel 2010 countifs for date range puck1263	by Spencer101	4	1,899
How to ignore the in between cells? babapusy	by babapusy	0	667
Filtering by text saltarazan	by saltarazan	0	613
Copying formulas across columns Ricardo[_3_]	by GS[_2_]	2	693
Recurring Items in Spreadsheets Scaper	by GS[_2_]	2	888
Numbers in word FEVOOO	by Claus Busch	1	662
Time/Date auto insert upon click Keyrookie	by Keyrookie	0	723
How Do I Find Different Values In A String? tb	by tb	2	515
Line chart based on 3 columns galkas	by Spencer101	1	656
complex sort search and replace macro Colin Hayes	by Claus Busch	2	698
sumproduct montypython	by joeu2004[_2_]	1	715
Missing data when using TREND function Jeremy Bowyer	by Jeremy Bowyer	1	811
Ambiguous name detected: worksheet_change FlesburgT	by [email protected]	2	1,849
Can XIRR Work on Dates That Move Backwards in Time? W	by joeu2004[_2_]	3	812
sumproduct by year Jack Deuce	by Jack Deuce	2	858
Vlookup doesn't work: results are wrong GijsKijlstra	by GijsKijlstra	8	1,618
Help with a running total on multiple sheets Shari C	by [email protected]	5	1,156
vlookup or sumproduct ? cupertino	by cupertino	0	562
VLOOKUP within a Range of Dates wgmills	by Spencer101	1	569
PivotTable - feature like "value range" or "slices" available on regular fields? ChristopherW	by ChristopherW	0	601
If then formula Travelgirl333	by Travelgirl333	0	620
How can I count deviations between two rows? J. Gary Ellison	by baleshst	4	707
Macro to concatenate with previous bold cell alovell	by alovell	0	679
Seperate numbers in a cell jry277	by Kevin@Radstock	2	612
Find partial text and retrun value in corresponding column [email protected]	by MyVeryOwnSelf[_3_]	3	673
multiple SUMIF help/advice Lapo Zanuso	by Lapo Zanuso	3	695
is is any stuff for stock market heat map then pls share Dhaval Shah	by Dhaval Shah	0	560
Formula help needed please Bob Newman[_2_]	by Living the Dream	2	726
SUBTOTAL not updating correctly DVEINTIMILLA	by DVEINTIMILLA	3	2,162
Control F twiliams	by Stan Brown	1	676
Smoothing Data in Columsns in Excel 2012 munleyj	by joeu2004[_2_]	1	992
Copying a cell value to another sheet by using If statement naga rajan	by Claus Busch	1	622
TIME CALCULATION FEVOOO	by FEVOOO	6	998
Comparing MONTH and YEAR inside Formula ?? FPerg	by Claus Busch	1	711
Vlookup and return sheet name also [email protected]	by [email protected]	2	855
IF validation for time totaling JSmitty	by Claus Busch	2	714
Need formulas for searching for a value in a table and returning row/column name Johnrd1963	by Johnrd1963	8	1,242
VLookup IF word in string exists within cell, use the word. cellsandstuff	by cellsandstuff	0	987
Custom Cell Style - Shows as error and cannot be deleted Paul C	by [email protected]	2	5,046
Drop Down List Dependant Formula garygoodguy	by garygoodguy	1	778