Excel Worksheet Functions - Page 110

Thread / Thread Starter	Last Post	Replies	Views
Fun with SUMPRODUCT rweiss	by rweiss	14	880
have one sheet update others in workbook ashadiana	by Gord Dibben	1	504
How to stop scrolling in side by side comparison? vdotMN	by Gord Dibben	2	1,670
Need formula to return exact match gootroots	by Gotroots	8	637
Pricing Chart chippette	by chippette	3	440
Concatenate email addresses Renegade	by Rick Rothstein	3	2,592
Amount Owing LAM	by Luke M	1	536
Pivot Table Problem DCO	by Shane Devenshire[_2_]	1	466
PETTY CASH josros60 via OfficeKB.com	by josros60 via OfficeKB.com	0	405
Excel MATCH Function Sal[_3_]	by Gary''s Student	1	382
Timesheets Thomas 49	by Amish	2	470
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,747
In excel change color of a range of cells based on a cell value kwitt	by Squeaky	1	1,316
Multiple If Then Statement based on ranges Multiple If, Then statements	by T. Valko	5	2,347
Complex conditional summing - array COUNT works, array SUM gives#VALUE fatcatfan	by T. Valko	4	1,170
Reference constant cells in different files from a master workbook Byron	by Squeaky	1	859
Pulling data from another workbook Frustrated	by Tom Hutchins	2	525
Vlookup when lookup criteria is not an exact match jtoy	by Jacob Skaria	2	1,380
my first excel experience (share portfolio) barbarebop	by barbarebop	2	1,320
IF statement based on need to recalculate pdberger	by Squeaky	1	446
Sum Multiple Criteria JCS	by JCS	7	696
Averageif is not working Curtis	by Squeaky	2	2,116
date text to change colour when it gets over six months Nessa	by Jacob Skaria	1	576
True false function for alpha data R Y	by David Biddulph[_2_]	7	581
calculating number of days belonging to each month within a given week kate zareba	by JLatham	2	689
Hours and sum of hours u650431	by Jacob Skaria	2	860
Vlookup with AND, OR IF statements Novawitt	by Pete_UK	1	1,099
I have a worksheet Skip[_2_]	by Pete_UK	1	399
Fill down conditional formatting series gootroots	by Gotroots	7	3,821
i want to set conditional format to cells containing odd numbers ian c	by Ashish Mathur[_2_]	4	1,694
Date is displaying 00-Jan-00 when I type in 11/16/09. Clark	by David Biddulph[_2_]	4	581
Multiple formats in a cell Gridlock	by Ron Rosenfeld	2	486
How can I use the * wildcard in an array formula Bruce	by Ashish Mathur[_2_]	4	1,523
find a data in a list that have a few hit ssa	by Jacob Skaria	1	539
Need to separate multiple numbers in one cell sierra spiegel	by Ashish Mathur[_2_]	3	5,906
Excluding Cells From Avg Cals Due to Info in different col redstar_	by Jacob Skaria	6	552
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED Debbi	by T. Valko	2	726
Converting 0 values to Blanks kepetersen3405	by minyeh	5	1,531
macro adjust Mylan	by Jacob Skaria	1	496
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,760
Inserting a cell value from an "IF" function liamellis91	by Ashish Mathur[_2_]	2	583
Conditional formatting of dates in two cells using Excel 2007 lemur99	by Jacob Skaria	2	664
Rows to Columns Walter Seaton	by Jan[_5_]	3	393
Quick VBA Worksheet Change Event or Selection Question: Damil4real	by Bernie Deitrick	6	781
conditional Formatting cell wildcard RogueIT	by Gord Dibben	4	1,912
Index and References within a workbook Curtis	by Pete_UK	4	687
Greater Than msao	by Harlan Grove[_2_]	6	749
Combine Two Similar Arrays Rob	by Glenn	1	1,021
how do i turn on side by side in excel R Kaleta	by Gord Dibben	1	1,233
Count IF Formula John	by Bernard Liengme	6	455
Formula based on variable range BruceM via OfficeKB.com	by BruceM via OfficeKB.com	3	1,026
I selected row 1 and row 2 to freeze and it is freezing at row 12 Lori Brooks	by Mike H	2	764
Insert row with a locked cell Robert	by Gord Dibben	1	976
Auto Fill Down Macro Angela T	by Gord Dibben	5	5,577
Format single words in cells Gabriele	by Pete_UK	3	503
Apply CF to Row after CF was applied to Column Dax Arroway	by Pete_UK	3	426
Copy sheets into one book Eva	by Eva	2	485
Function for different array John	by John	6	421
If Function Parker63385	by T. Valko	3	397
CF to Row after CF is applied to Column Dax Arroway	by Dax Arroway	2	477
CF for Row when CF is applied to Column Dax Arroway	by Dax Arroway	2	456
How do I roundup to .9 and rounddown to .9 Office Buddy	by Bernie Deitrick	3	1,125
Error Messages msao	by msao	4	548
Countif and values greater than zero for a named range Angela	by David Biddulph[_2_]	1	1,748
Error in subtracting times BadBoy	by David Biddulph[_2_]	2	495
help functions Jordon	by Jordon	0	350
Easy eay to copy / paste a formula in column watermt	by muddan madhu	2	481
Vlookup Help Curtis	by Curtis	2	472
multiple formats in a cell Gridlock	by Don Guillett	2	897
Index & Match doesn't seem to work BEEJAY	by BEEJAY	2	1,767
FVSCHEDULE reremmak	by Fred Smith[_4_]	3	1,873
Modify and add extra condition gootroots	by Ms-Exl-Learner	2	461
Count Formula Annie	by Pete_UK	1	413