Excel Worksheet Functions - Page 110

Thread / Thread Starter	Last Post	Replies	Views
Fun with SUMPRODUCT rweiss	by rweiss	14	881
have one sheet update others in workbook ashadiana	by Gord Dibben	1	505
How to stop scrolling in side by side comparison? vdotMN	by Gord Dibben	2	1,683
Need formula to return exact match gootroots	by Gotroots	8	647
Pricing Chart chippette	by chippette	3	441
Concatenate email addresses Renegade	by Rick Rothstein	3	2,608
Amount Owing LAM	by Luke M	1	543
Pivot Table Problem DCO	by Shane Devenshire[_2_]	1	480
PETTY CASH josros60 via OfficeKB.com	by josros60 via OfficeKB.com	0	406
Excel MATCH Function Sal[_3_]	by Gary''s Student	1	391
Timesheets Thomas 49	by Amish	2	471
Price Comparison formula TJC	by JBoulton	5	2,232
If (Vlookup 0) working, but what if Vlookup cell does not exist Steve	by Steve	18	2,767
In excel change color of a range of cells based on a cell value kwitt	by Squeaky	1	1,327
Multiple If Then Statement based on ranges Multiple If, Then statements	by T. Valko	5	2,360
Complex conditional summing - array COUNT works, array SUM gives#VALUE fatcatfan	by T. Valko	4	1,187
Reference constant cells in different files from a master workbook Byron	by Squeaky	1	866
Pulling data from another workbook Frustrated	by Tom Hutchins	2	538
Vlookup when lookup criteria is not an exact match jtoy	by Jacob Skaria	2	1,383
my first excel experience (share portfolio) barbarebop	by barbarebop	2	1,324
IF statement based on need to recalculate pdberger	by Squeaky	1	452
Sum Multiple Criteria JCS	by JCS	7	698
Averageif is not working Curtis	by Squeaky	2	2,129
date text to change colour when it gets over six months Nessa	by Jacob Skaria	1	585
True false function for alpha data R Y	by David Biddulph[_2_]	7	583
calculating number of days belonging to each month within a given week kate zareba	by JLatham	2	703
Hours and sum of hours u650431	by Jacob Skaria	2	866
Vlookup with AND, OR IF statements Novawitt	by Pete_UK	1	1,106
I have a worksheet Skip[_2_]	by Pete_UK	1	401
Fill down conditional formatting series gootroots	by Gotroots	7	3,835
i want to set conditional format to cells containing odd numbers ian c	by Ashish Mathur[_2_]	4	1,707
Date is displaying 00-Jan-00 when I type in 11/16/09. Clark	by David Biddulph[_2_]	4	592
Multiple formats in a cell Gridlock	by Ron Rosenfeld	2	499
How can I use the * wildcard in an array formula Bruce	by Ashish Mathur[_2_]	4	1,539
find a data in a list that have a few hit ssa	by Jacob Skaria	1	555
Need to separate multiple numbers in one cell sierra spiegel	by Ashish Mathur[_2_]	3	5,922
Excluding Cells From Avg Cals Due to Info in different col redstar_	by Jacob Skaria	6	553
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED Debbi	by T. Valko	2	739
Converting 0 values to Blanks kepetersen3405	by minyeh	5	1,542
macro adjust Mylan	by Jacob Skaria	1	502
what would it take to..... Steve	by Ashish Mathur[_2_]	2	454
Eliminate Duplicate Entries in Order to Create Labels Using Mail M Karen	by Ashish Mathur[_2_]	3	1,776
Inserting a cell value from an "IF" function liamellis91	by Ashish Mathur[_2_]	2	597
Conditional formatting of dates in two cells using Excel 2007 lemur99	by Jacob Skaria	2	673
Rows to Columns Walter Seaton	by Jan[_5_]	3	405
Quick VBA Worksheet Change Event or Selection Question: Damil4real	by Bernie Deitrick	6	797
conditional Formatting cell wildcard RogueIT	by Gord Dibben	4	1,924
Index and References within a workbook Curtis	by Pete_UK	4	704
Greater Than msao	by Harlan Grove[_2_]	6	754
Combine Two Similar Arrays Rob	by Glenn	1	1,041
how do i turn on side by side in excel R Kaleta	by Gord Dibben	1	1,246
Count IF Formula John	by Bernard Liengme	6	468
Formula based on variable range BruceM via OfficeKB.com	by BruceM via OfficeKB.com	3	1,034
I selected row 1 and row 2 to freeze and it is freezing at row 12 Lori Brooks	by Mike H	2	771
Insert row with a locked cell Robert	by Gord Dibben	1	986
Auto Fill Down Macro Angela T	by Gord Dibben	5	5,588
Format single words in cells Gabriele	by Pete_UK	3	509
Apply CF to Row after CF was applied to Column Dax Arroway	by Pete_UK	3	431
Copy sheets into one book Eva	by Eva	2	495
Function for different array John	by John	6	438
If Function Parker63385	by T. Valko	3	408
CF to Row after CF is applied to Column Dax Arroway	by Dax Arroway	2	493
CF for Row when CF is applied to Column Dax Arroway	by Dax Arroway	2	462
How do I roundup to .9 and rounddown to .9 Office Buddy	by Bernie Deitrick	3	1,129
Error Messages msao	by msao	4	563
Countif and values greater than zero for a named range Angela	by David Biddulph[_2_]	1	1,761
Error in subtracting times BadBoy	by David Biddulph[_2_]	2	495
help functions Jordon	by Jordon	0	359
Easy eay to copy / paste a formula in column watermt	by muddan madhu	2	483
Vlookup Help Curtis	by Curtis	2	472
multiple formats in a cell Gridlock	by Don Guillett	2	909
Index & Match doesn't seem to work BEEJAY	by BEEJAY	2	1,779
FVSCHEDULE reremmak	by Fred Smith[_4_]	3	1,874
Modify and add extra condition gootroots	by Ms-Exl-Learner	2	473
Count Formula Annie	by Pete_UK	1	423