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	505
How to stop scrolling in side by side comparison? vdotMN	by Gord Dibben	2	1,671
Need formula to return exact match gootroots	by Gotroots	8	638
Pricing Chart chippette	by chippette	3	441
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	406
Excel MATCH Function Sal[_3_]	by Gary''s Student	1	383
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,756
In excel change color of a range of cells based on a cell value kwitt	by Squeaky	1	1,319
Multiple If Then Statement based on ranges Multiple If, Then statements	by T. Valko	5	2,348
Complex conditional summing - array COUNT works, array SUM gives#VALUE fatcatfan	by T. Valko	4	1,175
Reference constant cells in different files from a master workbook Byron	by Squeaky	1	860
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,382
my first excel experience (share portfolio) barbarebop	by barbarebop	2	1,321
IF statement based on need to recalculate pdberger	by Squeaky	1	448
Sum Multiple Criteria JCS	by JCS	7	697
Averageif is not working Curtis	by Squeaky	2	2,117
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	690
Hours and sum of hours u650431	by Jacob Skaria	2	863
Vlookup with AND, OR IF statements Novawitt	by Pete_UK	1	1,101
I have a worksheet Skip[_2_]	by Pete_UK	1	400
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,527
find a data in a list that have a few hit ssa	by Jacob Skaria	1	540
Need to separate multiple numbers in one cell sierra spiegel	by Ashish Mathur[_2_]	3	5,909
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	729
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,762
Inserting a cell value from an "IF" function liamellis91	by Ashish Mathur[_2_]	2	584
Conditional formatting of dates in two cells using Excel 2007 lemur99	by Jacob Skaria	2	665
Rows to Columns Walter Seaton	by Jan[_5_]	3	394
Quick VBA Worksheet Change Event or Selection Question: Damil4real	by Bernie Deitrick	6	788
conditional Formatting cell wildcard RogueIT	by Gord Dibben	4	1,912
Index and References within a workbook Curtis	by Pete_UK	4	694
Greater Than msao	by Harlan Grove[_2_]	6	752
Combine Two Similar Arrays Rob	by Glenn	1	1,030
how do i turn on side by side in excel R Kaleta	by Gord Dibben	1	1,236
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,027
I selected row 1 and row 2 to freeze and it is freezing at row 12 Lori Brooks	by Mike H	2	765
Insert row with a locked cell Robert	by Gord Dibben	1	978
Auto Fill Down Macro Angela T	by Gord Dibben	5	5,578
Format single words in cells Gabriele	by Pete_UK	3	505
Apply CF to Row after CF was applied to Column Dax Arroway	by Pete_UK	3	428
Copy sheets into one book Eva	by Eva	2	487
Function for different array John	by John	6	425
If Function Parker63385	by T. Valko	3	398
CF to Row after CF is applied to Column Dax Arroway	by Dax Arroway	2	478
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,129
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	899
Index & Match doesn't seem to work BEEJAY	by BEEJAY	2	1,767
FVSCHEDULE reremmak	by Fred Smith[_4_]	3	1,874
Modify and add extra condition gootroots	by Ms-Exl-Learner	2	461
Count Formula Annie	by Pete_UK	1	414