Excel Worksheet Functions - Page 64

Thread / Thread Starter	Last Post	Replies	Views
Removing ''VALUES'' Mark D[_2_]	by Ziggy	5	639
Use vlookup within offset? berniean	by T. Valko	4	1,459
SUMPRODUCT multiple criteria (with a twist) GD	by Ranjith Rajaratnam	13	2,860
adding result of "if" statement.. Xiamen	by Ziggy	3	431
Last number in a column shows in the total/summay line cell Jen S[_2_]	by Ziggy	3	692
Combining data nitengale	by Eduardo	1	443
Filling formulas with specific cell references remaining the same quinxorin	by quinxorin	2	529
Excel data from spreadsheet to database Ricki Miles	by Gord Dibben	1	511
group/ungroup protected sheets? RLD	by Gord Dibben	1	2,306
Excel 2007 - Autocomplete Alpha List Jannoth	by Gord Dibben	4	1,691
Jpeg links opening in Explorer instead of Picture Manager stripedfrog via OfficeKB.com	by stripedfrog via OfficeKB.com	0	1,085
Nesting Lookup Functions eionjess	by Ziggy	4	789
VLookup with Search for in String Benjamin	by Ziggy	4	2,203
SUMPRODUCT help Mark D[_2_]	by Fred Smith[_4_]	3	483
Repost - Functions on filtered data LiAD	by LiAD	0	588
Array formula to find date Amylou	by Amylou	0	675
Print Preview Different than What I see in the Excel File Kashmira	by Kashmira	0	1,675
Macros AlwaysQuestions	by ericaamousseau	8	518
Formula Needed for lowest three values in a Column frankjh19701	by frankjh19701	12	1,250
Formula for multiple countifs J.Scargill[_2_]	by J.Scargill[_2_]	4	822
Multiple IF function Jecker	by Jecker	7	655
counting based on two conditions in excel 2003 Anand	by Bob Phillips[_4_]	4	631
General Calculator MIKEY	by Gary''s Student	1	476
How can I count values in multiple non-consecutive cells? Kevin M.[_2_]	by Bob Phillips[_4_]	1	1,006
Sumproduct, but errors in column ker_01	by Bob Phillips[_4_]	6	2,180
IF - more than seven arguments Hannah	by Hannah	2	595
HELP! TJ	by TJ	4	519
Entering Formula - Cannot select cell as it is hidden by formula Jim	by Jim	0	800
Missing Record in Table Lookup Jim	by Jim	0	514
Using Sumproduct when some of the values are null SanCarlosCyclist	by SanCarlosCyclist	5	1,650
find cmkwolf	by FSt1	1	397
Vlookup possibly ? Steve	by Pete_UK	3	497
Looking for Text strings Scats	by Scats	3	560
Segrigation of different datas from one colum Roy Thomas[_2_]	by ker_01	1	448
Excell Spreedsheets Jack Wheeler	by Tony	1	487
Indirect and Sheet Name Rob	by Rob	4	2,516
mark up arKwelder	by David Biddulph[_2_]	3	580
Select 'Sort By' column by simply typing heading letter dsavant	by Roger Govier[_8_]	1	829
Downward column climate	by climate	1	452
Pivot Table Refresh Eric	by Eric	5	1,426
Trying to convert mm/yy in text to Dec-07, it adds day & current y Excellency	by Héctor Miguel	12	1,223
Pivot Table - Calculated Field Mike C	by Roger Govier[_8_]	2	916
Row Height Adds Blank Space at End of Text Meg	by Meg	0	1,097
Calculate Number of Days worked in Each Month by Project froggygremblin	by froggygremblin	2	1,495
SELECT SUM(h) WHERE e = 'eBay Payment Sent' yawnmoth	by T. Valko	4	540
Redistribution of values after reaching maximum DG	by DG	4	1,076
adding figures that match 2 true and 1 false if statement conditio UKMAN	by Eduardo	5	611
count number of dates in range Sunflower[_3_]	by Francis	2	974
Excel not pasting the formula or reference Lindsey	by Luke M[_4_]	1	2,361
Date Formatting DaveMoore	by Daryl S	2	518
Sumproduct? Hannah	by Glenn	1	417
Too many rows highlighted RLD	by Mike H	1	637
Data Validation drop-down width, with named range source (XL03 and ker_01	by T. Valko	4	2,433
Date Calculation problem petedacook	by petedacook	3	784
In new Office 2007 EXCEL, can more the 8 IF statements be used? MORRIPJ	by Mike H	1	752
Data Validation List - Can I have multiple ranges displayed? Jim	by Jim	4	1,886
Data Connection Wizard Richard Horn[_2_]	by Richard Horn[_2_]	0	581
Hidden column showiesg	by arealbasketcase	1	580
formula question... 000ani	by Joe User[_2_]	2	539
Convert Date in Text to month and Year Excellency	by T. Valko	3	2,338
Matching two sets of data? Zuo	by Zuo	5	615
file names Mr Widget	by Ashish Mathur[_2_]	3	683
find all instances of a search item and put result in a single cel Art	by Ashish Mathur[_2_]	5	988
Automating a Worksheet hankb	by Max	6	530
Calculating Resolution Rates Rhonda Urbanczyk	by Rhonda Urbanczyk[_2_]	4	652
"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!! gamn	by Bernard Liengme[_2_]	5	572
Justify across selection bfloyd	by Ziggy	1	658
Removing Special Characters Cathy Landry	by Cathy Landry	2	1,917
macro shortcut help ericaamousseau	by tompl	1	511
Vlookup, IF, concantenate, Right -- can all these be in one formu SRH@Boise	by T. Valko	6	1,050
counting function with weekdays only LSG	by T. Valko	5	532
SUMIFS using a text rage Ziggy	by Ziggy	0	815
SUMIFS using a text rage Ziggy	by Ziggy	0	612
Date Format DaveMoore	by T. Valko	1	520
Column Average Given 2 Criteria AAA1986	by T. Valko	4	618