Excel Worksheet Functions - Page 64

Thread / Thread Starter	Last Post	Replies	Views
Removing ''VALUES'' Mark D[_2_]	by Ziggy	5	616
Use vlookup within offset? berniean	by T. Valko	4	1,441
SUMPRODUCT multiple criteria (with a twist) GD	by Ranjith Rajaratnam	13	2,844
adding result of "if" statement.. Xiamen	by Ziggy	3	427
Last number in a column shows in the total/summay line cell Jen S[_2_]	by Ziggy	3	678
Combining data nitengale	by Eduardo	1	420
Filling formulas with specific cell references remaining the same quinxorin	by quinxorin	2	519
Excel data from spreadsheet to database Ricki Miles	by Gord Dibben	1	479
group/ungroup protected sheets? RLD	by Gord Dibben	1	2,288
Excel 2007 - Autocomplete Alpha List Jannoth	by Gord Dibben	4	1,599
Jpeg links opening in Explorer instead of Picture Manager stripedfrog via OfficeKB.com	by stripedfrog via OfficeKB.com	0	1,067
Nesting Lookup Functions eionjess	by Ziggy	4	778
VLookup with Search for in String Benjamin	by Ziggy	4	2,198
SUMPRODUCT help Mark D[_2_]	by Fred Smith[_4_]	3	473
Repost - Functions on filtered data LiAD	by LiAD	0	560
Array formula to find date Amylou	by Amylou	0	654
Print Preview Different than What I see in the Excel File Kashmira	by Kashmira	0	1,657
Macros AlwaysQuestions	by ericaamousseau	8	514
Formula Needed for lowest three values in a Column frankjh19701	by frankjh19701	12	1,221
Formula for multiple countifs J.Scargill[_2_]	by J.Scargill[_2_]	4	792
Multiple IF function Jecker	by Jecker	7	640
counting based on two conditions in excel 2003 Anand	by Bob Phillips[_4_]	4	610
General Calculator MIKEY	by Gary''s Student	1	464
How can I count values in multiple non-consecutive cells? Kevin M.[_2_]	by Bob Phillips[_4_]	1	992
Sumproduct, but errors in column ker_01	by Bob Phillips[_4_]	6	2,166
IF - more than seven arguments Hannah	by Hannah	2	576
HELP! TJ	by TJ	4	495
Entering Formula - Cannot select cell as it is hidden by formula Jim	by Jim	0	778
Missing Record in Table Lookup Jim	by Jim	0	494
Using Sumproduct when some of the values are null SanCarlosCyclist	by SanCarlosCyclist	5	1,634
find cmkwolf	by FSt1	1	389
Vlookup possibly ? Steve	by Pete_UK	3	490
Looking for Text strings Scats	by Scats	3	507
Segrigation of different datas from one colum Roy Thomas[_2_]	by ker_01	1	434
Excell Spreedsheets Jack Wheeler	by Tony	1	473
Indirect and Sheet Name Rob	by Rob	4	2,499
mark up arKwelder	by David Biddulph[_2_]	3	568
Select 'Sort By' column by simply typing heading letter dsavant	by Roger Govier[_8_]	1	818
Downward column climate	by climate	1	444
Pivot Table Refresh Eric	by Eric	5	1,392
Trying to convert mm/yy in text to Dec-07, it adds day & current y Excellency	by Héctor Miguel	12	1,200
Pivot Table - Calculated Field Mike C	by Roger Govier[_8_]	2	860
Row Height Adds Blank Space at End of Text Meg	by Meg	0	1,080
Calculate Number of Days worked in Each Month by Project froggygremblin	by froggygremblin	2	1,482
SELECT SUM(h) WHERE e = 'eBay Payment Sent' yawnmoth	by T. Valko	4	529
Redistribution of values after reaching maximum DG	by DG	4	1,058
adding figures that match 2 true and 1 false if statement conditio UKMAN	by Eduardo	5	596
count number of dates in range Sunflower[_3_]	by Francis	2	945
Excel not pasting the formula or reference Lindsey	by Luke M[_4_]	1	2,341
Date Formatting DaveMoore	by Daryl S	2	474
Sumproduct? Hannah	by Glenn	1	405
Too many rows highlighted RLD	by Mike H	1	619
Data Validation drop-down width, with named range source (XL03 and ker_01	by T. Valko	4	2,387
Date Calculation problem petedacook	by petedacook	3	761
In new Office 2007 EXCEL, can more the 8 IF statements be used? MORRIPJ	by Mike H	1	733
Data Validation List - Can I have multiple ranges displayed? Jim	by Jim	4	1,805
Data Connection Wizard Richard Horn[_2_]	by Richard Horn[_2_]	0	561
Hidden column showiesg	by arealbasketcase	1	572
formula question... 000ani	by Joe User[_2_]	2	532
Convert Date in Text to month and Year Excellency	by T. Valko	3	2,315
Matching two sets of data? Zuo	by Zuo	5	593
file names Mr Widget	by Ashish Mathur[_2_]	3	662
find all instances of a search item and put result in a single cel Art	by Ashish Mathur[_2_]	5	964
Automating a Worksheet hankb	by Max	6	516
Calculating Resolution Rates Rhonda Urbanczyk	by Rhonda Urbanczyk[_2_]	4	632
"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!! gamn	by Bernard Liengme[_2_]	5	539
Justify across selection bfloyd	by Ziggy	1	644
Removing Special Characters Cathy Landry	by Cathy Landry	2	1,905
macro shortcut help ericaamousseau	by tompl	1	491
Vlookup, IF, concantenate, Right -- can all these be in one formu SRH@Boise	by T. Valko	6	1,029
counting function with weekdays only LSG	by T. Valko	5	524
SUMIFS using a text rage Ziggy	by Ziggy	0	804
SUMIFS using a text rage Ziggy	by Ziggy	0	592
Date Format DaveMoore	by T. Valko	1	510
Column Average Given 2 Criteria AAA1986	by T. Valko	4	560