Excel Worksheet Functions - Page 110

Thread / Thread Starter	Last Post	Replies	Views
Fun with SUMPRODUCT rweiss	by rweiss	14	869
have one sheet update others in workbook ashadiana	by Gord Dibben	1	494
How to stop scrolling in side by side comparison? vdotMN	by Gord Dibben	2	1,655
Need formula to return exact match gootroots	by Gotroots	8	607
Pricing Chart chippette	by chippette	3	430
Concatenate email addresses Renegade	by Rick Rothstein	3	2,524
Amount Owing LAM	by Luke M	1	529
Pivot Table Problem DCO	by Shane Devenshire[_2_]	1	453
PETTY CASH josros60 via OfficeKB.com	by josros60 via OfficeKB.com	0	392
Excel MATCH Function Sal[_3_]	by Gary''s Student	1	373
Timesheets Thomas 49	by Amish	2	456
Price Comparison formula TJC	by JBoulton	5	2,222
If (Vlookup 0) working, but what if Vlookup cell does not exist Steve	by Steve	18	2,673
In excel change color of a range of cells based on a cell value kwitt	by Squeaky	1	1,291
Multiple If Then Statement based on ranges Multiple If, Then statements	by T. Valko	5	2,327
Complex conditional summing - array COUNT works, array SUM gives#VALUE fatcatfan	by T. Valko	4	1,154
Reference constant cells in different files from a master workbook Byron	by Squeaky	1	833
Pulling data from another workbook Frustrated	by Tom Hutchins	2	511
Vlookup when lookup criteria is not an exact match jtoy	by Jacob Skaria	2	1,366
my first excel experience (share portfolio) barbarebop	by barbarebop	2	1,301
IF statement based on need to recalculate pdberger	by Squeaky	1	438
Sum Multiple Criteria JCS	by JCS	7	689
Averageif is not working Curtis	by Squeaky	2	2,098
date text to change colour when it gets over six months Nessa	by Jacob Skaria	1	571
True false function for alpha data R Y	by David Biddulph[_2_]	7	569
calculating number of days belonging to each month within a given week kate zareba	by JLatham	2	669
Hours and sum of hours u650431	by Jacob Skaria	2	841
Vlookup with AND, OR IF statements Novawitt	by Pete_UK	1	1,091
I have a worksheet Skip[_2_]	by Pete_UK	1	392
Fill down conditional formatting series gootroots	by Gotroots	7	3,805
i want to set conditional format to cells containing odd numbers ian c	by Ashish Mathur[_2_]	4	1,680
Date is displaying 00-Jan-00 when I type in 11/16/09. Clark	by David Biddulph[_2_]	4	562
Multiple formats in a cell Gridlock	by Ron Rosenfeld	2	474
How can I use the * wildcard in an array formula Bruce	by Ashish Mathur[_2_]	4	1,471
find a data in a list that have a few hit ssa	by Jacob Skaria	1	524
Need to separate multiple numbers in one cell sierra spiegel	by Ashish Mathur[_2_]	3	5,883
Excluding Cells From Avg Cals Due to Info in different col redstar_	by Jacob Skaria	6	530
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED Debbi	by T. Valko	2	711
Converting 0 values to Blanks kepetersen3405	by minyeh	5	1,520
macro adjust Mylan	by Jacob Skaria	1	484
what would it take to..... Steve	by Ashish Mathur[_2_]	2	438
Eliminate Duplicate Entries in Order to Create Labels Using Mail M Karen	by Ashish Mathur[_2_]	3	1,716
Inserting a cell value from an "IF" function liamellis91	by Ashish Mathur[_2_]	2	566
Conditional formatting of dates in two cells using Excel 2007 lemur99	by Jacob Skaria	2	652
Rows to Columns Walter Seaton	by Jan[_5_]	3	383
Quick VBA Worksheet Change Event or Selection Question: Damil4real	by Bernie Deitrick	6	756
conditional Formatting cell wildcard RogueIT	by Gord Dibben	4	1,900
Index and References within a workbook Curtis	by Pete_UK	4	677
Greater Than msao	by Harlan Grove[_2_]	6	719
Combine Two Similar Arrays Rob	by Glenn	1	1,005
how do i turn on side by side in excel R Kaleta	by Gord Dibben	1	1,223
Count IF Formula John	by Bernard Liengme	6	447
Formula based on variable range BruceM via OfficeKB.com	by BruceM via OfficeKB.com	3	1,017
I selected row 1 and row 2 to freeze and it is freezing at row 12 Lori Brooks	by Mike H	2	752
Insert row with a locked cell Robert	by Gord Dibben	1	969
Auto Fill Down Macro Angela T	by Gord Dibben	5	5,571
Format single words in cells Gabriele	by Pete_UK	3	497
Apply CF to Row after CF was applied to Column Dax Arroway	by Pete_UK	3	412
Copy sheets into one book Eva	by Eva	2	479
Function for different array John	by John	6	401
If Function Parker63385	by T. Valko	3	391
CF to Row after CF is applied to Column Dax Arroway	by Dax Arroway	2	464
CF for Row when CF is applied to Column Dax Arroway	by Dax Arroway	2	445
How do I roundup to .9 and rounddown to .9 Office Buddy	by Bernie Deitrick	3	1,105
Error Messages msao	by msao	4	523
Countif and values greater than zero for a named range Angela	by David Biddulph[_2_]	1	1,734
Error in subtracting times BadBoy	by David Biddulph[_2_]	2	481
help functions Jordon	by Jordon	0	346
Easy eay to copy / paste a formula in column watermt	by muddan madhu	2	463
Vlookup Help Curtis	by Curtis	2	463
multiple formats in a cell Gridlock	by Don Guillett	2	884
Index & Match doesn't seem to work BEEJAY	by BEEJAY	2	1,750
FVSCHEDULE reremmak	by Fred Smith[_4_]	3	1,851
Modify and add extra condition gootroots	by Ms-Exl-Learner	2	445
Count Formula Annie	by Pete_UK	1	407