Excel Worksheet Functions - Page 110

Thread / Thread Starter	Last Post	Replies	Views
Fun with SUMPRODUCT rweiss	by rweiss	14	865
have one sheet update others in workbook ashadiana	by Gord Dibben	1	490
How to stop scrolling in side by side comparison? vdotMN	by Gord Dibben	2	1,651
Need formula to return exact match gootroots	by Gotroots	8	607
Pricing Chart chippette	by chippette	3	426
Concatenate email addresses Renegade	by Rick Rothstein	3	2,520
Amount Owing LAM	by Luke M	1	525
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	369
Timesheets Thomas 49	by Amish	2	452
Price Comparison formula TJC	by JBoulton	5	2,218
If (Vlookup 0) working, but what if Vlookup cell does not exist Steve	by Steve	18	2,669
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,362
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	685
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	837
Vlookup with AND, OR IF statements Novawitt	by Pete_UK	1	1,091
I have a worksheet Skip[_2_]	by Pete_UK	1	388
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,676
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	526
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED Debbi	by T. Valko	2	705
Converting 0 values to Blanks kepetersen3405	by minyeh	5	1,516
macro adjust Mylan	by Jacob Skaria	1	484
what would it take to..... Steve	by Ashish Mathur[_2_]	2	434
Eliminate Duplicate Entries in Order to Create Labels Using Mail M Karen	by Ashish Mathur[_2_]	3	1,715
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	651
Rows to Columns Walter Seaton	by Jan[_5_]	3	379
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	714
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,219
Count IF Formula John	by Bernard Liengme	6	443
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	748
Insert row with a locked cell Robert	by Gord Dibben	1	965
Auto Fill Down Macro Angela T	by Gord Dibben	5	5,571
Format single words in cells Gabriele	by Pete_UK	3	493
Apply CF to Row after CF was applied to Column Dax Arroway	by Pete_UK	3	408
Copy sheets into one book Eva	by Eva	2	476
Function for different array John	by John	6	401
If Function Parker63385	by T. Valko	3	387
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	477
help functions Jordon	by Jordon	0	342
Easy eay to copy / paste a formula in column watermt	by muddan madhu	2	463
Vlookup Help Curtis	by Curtis	2	459
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,847
Modify and add extra condition gootroots	by Ms-Exl-Learner	2	445
Count Formula Annie	by Pete_UK	1	403