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	896
Variable interest rate loan calculations- PLEASE HELP!!! AussieInNeed	by joeu2004[_2_]	1	785
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	907
Data Validation - Complex Q [email protected]	by [email protected]	2	608
If - Then Fields [email protected]	by Kevin@Radstock	2	615
To say number in words Frank Situmorang[_2_]	by [email protected]	6	1,022
Looking up other sheet for value X depnding on sheet Y and Z colums zildjian	by [email protected]	1	733
Show value from one cell in another cell if today falls between a date range perpetual159	by perpetual159	5	1,176
lookup two different variables [email protected]	by [email protected]	0	570
using different sheets match string to specific work and enter that work in active MarkDuffy	by MarkDuffy	0	581
Elementary SUMPRODUCT Question Happens	by joeu2004[_2_]	3	649
Show a cell's formula in text format in a linked cell TreeHugger1	by TreeHugger1	1	596
Formula to predict future data Loztrailia	by joeu2004[_2_]	1	632
Solution to tricky problem of showing exactly Top N rows in Pivottable excelaroni	by excelaroni	0	665
Formula to reference Cell Background Color TreeHugger1	by Ron Rosenfeld[_2_]	3	922
Generating a cut list wabbleknee	by CellShocked	11	1,593
Rolling 12 month comp1	by comp1	9	1,461
Length cutting optimizer CellShocked	by CellShocked	0	649
Auto populate date VBA code Keyrookie	by Claus Busch	7	909
Sum Function has small remainder Hi I am Michael	by Hi I am Michael	2	803
Year End totals Pamela Rease	by Pamela Rease	8	895
=sum with a filter CJH	by Claus Busch	2	582
Adding another if statement to an index formula Icehockey44	by Icehockey44	0	743
Summing Results Based On A Specific Date JPP	by Spencer101	5	881
Rounding cents Håkan Björkström	by Claus Busch	4	750
Sumproduct giving #Value error KeriM	by KeriM	6	790
Indicating where a range has overtime hours in a range of cells Baiona	by Baiona	3	780
Yes or blank, depending if value equals or exceeds value found inVLookup table. Steve[_16_]	by Steve[_16_]	4	798
Autosize Merged Cell TreeHugger1	by TreeHugger1	0	638
Conditional Sum Based on Cell Background Color Thomas M.	by TreeHugger1	7	2,738
Sorting problem. My header rom is getting sorted with the rest. javaj	by [email protected]	2	676
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,896
How to ignore the in between cells? babapusy	by babapusy	0	662
Filtering by text saltarazan	by saltarazan	0	613
Copying formulas across columns Ricardo[_3_]	by GS[_2_]	2	691
Recurring Items in Spreadsheets Scaper	by GS[_2_]	2	886
Numbers in word FEVOOO	by Claus Busch	1	662
Time/Date auto insert upon click Keyrookie	by Keyrookie	0	676
How Do I Find Different Values In A String? tb	by tb	2	514
Line chart based on 3 columns galkas	by Spencer101	1	652
complex sort search and replace macro Colin Hayes	by Claus Busch	2	693
sumproduct montypython	by joeu2004[_2_]	1	714
Missing data when using TREND function Jeremy Bowyer	by Jeremy Bowyer	1	809
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	811
sumproduct by year Jack Deuce	by Jack Deuce	2	858
Vlookup doesn't work: results are wrong GijsKijlstra	by GijsKijlstra	8	1,616
Help with a running total on multiple sheets Shari C	by [email protected]	5	1,153
vlookup or sumproduct ? cupertino	by cupertino	0	560
VLOOKUP within a Range of Dates wgmills	by Spencer101	1	567
PivotTable - feature like "value range" or "slices" available on regular fields? ChristopherW	by ChristopherW	0	599
If then formula Travelgirl333	by Travelgirl333	0	619
How can I count deviations between two rows? J. Gary Ellison	by baleshst	4	703
Macro to concatenate with previous bold cell alovell	by alovell	0	677
Seperate numbers in a cell jry277	by Kevin@Radstock	2	610
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	691
is is any stuff for stock market heat map then pls share Dhaval Shah	by Dhaval Shah	0	549
Formula help needed please Bob Newman[_2_]	by Living the Dream	2	723
SUBTOTAL not updating correctly DVEINTIMILLA	by DVEINTIMILLA	3	2,160
Control F twiliams	by Stan Brown	1	676
Smoothing Data in Columsns in Excel 2012 munleyj	by joeu2004[_2_]	1	991
Copying a cell value to another sheet by using If statement naga rajan	by Claus Busch	1	621
TIME CALCULATION FEVOOO	by FEVOOO	6	993
Comparing MONTH and YEAR inside Formula ?? FPerg	by Claus Busch	1	711
Vlookup and return sheet name also [email protected]	by [email protected]	2	853
IF validation for time totaling JSmitty	by Claus Busch	2	711
Need formulas for searching for a value in a table and returning row/column name Johnrd1963	by Johnrd1963	8	1,241
VLookup IF word in string exists within cell, use the word. cellsandstuff	by cellsandstuff	0	984
Custom Cell Style - Shows as error and cannot be deleted Paul C	by [email protected]	2	5,044
Drop Down List Dependant Formula garygoodguy	by garygoodguy	1	778