Excel Worksheet Functions - Page 64

Thread / Thread Starter	Last Post	Replies	Views
Removing ''VALUES'' Mark D[_2_]	by Ziggy	5	626
Use vlookup within offset? berniean	by T. Valko	4	1,453
SUMPRODUCT multiple criteria (with a twist) GD	by Ranjith Rajaratnam	13	2,854
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	687
Combining data nitengale	by Eduardo	1	438
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	501
group/ungroup protected sheets? RLD	by Gord Dibben	1	2,298
Excel 2007 - Autocomplete Alpha List Jannoth	by Gord Dibben	4	1,689
Jpeg links opening in Explorer instead of Picture Manager stripedfrog via OfficeKB.com	by stripedfrog via OfficeKB.com	0	1,081
Nesting Lookup Functions eionjess	by Ziggy	4	788
VLookup with Search for in String Benjamin	by Ziggy	4	2,202
SUMPRODUCT help Mark D[_2_]	by Fred Smith[_4_]	3	479
Repost - Functions on filtered data LiAD	by LiAD	0	577
Array formula to find date Amylou	by Amylou	0	668
Print Preview Different than What I see in the Excel File Kashmira	by Kashmira	0	1,666
Macros AlwaysQuestions	by ericaamousseau	8	518
Formula Needed for lowest three values in a Column frankjh19701	by frankjh19701	12	1,234
Formula for multiple countifs J.Scargill[_2_]	by J.Scargill[_2_]	4	807
Multiple IF function Jecker	by Jecker	7	653
counting based on two conditions in excel 2003 Anand	by Bob Phillips[_4_]	4	623
General Calculator MIKEY	by Gary''s Student	1	475
How can I count values in multiple non-consecutive cells? Kevin M.[_2_]	by Bob Phillips[_4_]	1	1,000
Sumproduct, but errors in column ker_01	by Bob Phillips[_4_]	6	2,173
IF - more than seven arguments Hannah	by Hannah	2	587
HELP! TJ	by TJ	4	511
Entering Formula - Cannot select cell as it is hidden by formula Jim	by Jim	0	792
Missing Record in Table Lookup Jim	by Jim	0	505
Using Sumproduct when some of the values are null SanCarlosCyclist	by SanCarlosCyclist	5	1,648
find cmkwolf	by FSt1	1	397
Vlookup possibly ? Steve	by Pete_UK	3	495
Looking for Text strings Scats	by Scats	3	542
Segrigation of different datas from one colum Roy Thomas[_2_]	by ker_01	1	447
Excell Spreedsheets Jack Wheeler	by Tony	1	487
Indirect and Sheet Name Rob	by Rob	4	2,515
mark up arKwelder	by David Biddulph[_2_]	3	576
Select 'Sort By' column by simply typing heading letter dsavant	by Roger Govier[_8_]	1	824
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,215
Pivot Table - Calculated Field Mike C	by Roger Govier[_8_]	2	915
Row Height Adds Blank Space at End of Text Meg	by Meg	0	1,096
Calculate Number of Days worked in Each Month by Project froggygremblin	by froggygremblin	2	1,494
SELECT SUM(h) WHERE e = 'eBay Payment Sent' yawnmoth	by T. Valko	4	535
Redistribution of values after reaching maximum DG	by DG	4	1,070
adding figures that match 2 true and 1 false if statement conditio UKMAN	by Eduardo	5	610
count number of dates in range Sunflower[_3_]	by Francis	2	958
Excel not pasting the formula or reference Lindsey	by Luke M[_4_]	1	2,350
Date Formatting DaveMoore	by Daryl S	2	505
Sumproduct? Hannah	by Glenn	1	414
Too many rows highlighted RLD	by Mike H	1	629
Data Validation drop-down width, with named range source (XL03 and ker_01	by T. Valko	4	2,406
Date Calculation problem petedacook	by petedacook	3	771
In new Office 2007 EXCEL, can more the 8 IF statements be used? MORRIPJ	by Mike H	1	750
Data Validation List - Can I have multiple ranges displayed? Jim	by Jim	4	1,878
Data Connection Wizard Richard Horn[_2_]	by Richard Horn[_2_]	0	573
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,334
Matching two sets of data? Zuo	by Zuo	5	608
file names Mr Widget	by Ashish Mathur[_2_]	3	675
find all instances of a search item and put result in a single cel Art	by Ashish Mathur[_2_]	5	983
Automating a Worksheet hankb	by Max	6	522
Calculating Resolution Rates Rhonda Urbanczyk	by Rhonda Urbanczyk[_2_]	4	650
"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!! gamn	by Bernard Liengme[_2_]	5	563
Justify across selection bfloyd	by Ziggy	1	650
Removing Special Characters Cathy Landry	by Cathy Landry	2	1,914
macro shortcut help ericaamousseau	by tompl	1	507
Vlookup, IF, concantenate, Right -- can all these be in one formu SRH@Boise	by T. Valko	6	1,048
counting function with weekdays only LSG	by T. Valko	5	532
SUMIFS using a text rage Ziggy	by Ziggy	0	814
SUMIFS using a text rage Ziggy	by Ziggy	0	603
Date Format DaveMoore	by T. Valko	1	517
Column Average Given 2 Criteria AAA1986	by T. Valko	4	615