Excel Worksheet Functions - Page 64

Thread / Thread Starter	Last Post	Replies	Views
Removing ''VALUES'' Mark D[_2_]	by Ziggy	5	629
Use vlookup within offset? berniean	by T. Valko	4	1,459
SUMPRODUCT multiple criteria (with a twist) GD	by Ranjith Rajaratnam	13	2,855
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	502
group/ungroup protected sheets? RLD	by Gord Dibben	1	2,298
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,084
Nesting Lookup Functions eionjess	by Ziggy	4	789
VLookup with Search for in String Benjamin	by Ziggy	4	2,202
SUMPRODUCT help Mark D[_2_]	by Fred Smith[_4_]	3	481
Repost - Functions on filtered data LiAD	by LiAD	0	579
Array formula to find date Amylou	by Amylou	0	669
Print Preview Different than What I see in the Excel File Kashmira	by Kashmira	0	1,667
Macros AlwaysQuestions	by ericaamousseau	8	518
Formula Needed for lowest three values in a Column frankjh19701	by frankjh19701	12	1,235
Formula for multiple countifs J.Scargill[_2_]	by J.Scargill[_2_]	4	812
Multiple IF function Jecker	by Jecker	7	654
counting based on two conditions in excel 2003 Anand	by Bob Phillips[_4_]	4	624
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,000
Sumproduct, but errors in column ker_01	by Bob Phillips[_4_]	6	2,178
IF - more than seven arguments Hannah	by Hannah	2	588
HELP! TJ	by TJ	4	519
Entering Formula - Cannot select cell as it is hidden by formula Jim	by Jim	0	794
Missing Record in Table Lookup Jim	by Jim	0	507
Using Sumproduct when some of the values are null SanCarlosCyclist	by SanCarlosCyclist	5	1,649
find cmkwolf	by FSt1	1	397
Vlookup possibly ? Steve	by Pete_UK	3	496
Looking for Text strings Scats	by Scats	3	547
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,516
mark up arKwelder	by David Biddulph[_2_]	3	577
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,216
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,071
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	963
Excel not pasting the formula or reference Lindsey	by Luke M[_4_]	1	2,351
Date Formatting DaveMoore	by Daryl S	2	508
Sumproduct? Hannah	by Glenn	1	416
Too many rows highlighted RLD	by Mike H	1	630
Data Validation drop-down width, with named range source (XL03 and ker_01	by T. Valko	4	2,414
Date Calculation problem petedacook	by petedacook	3	776
In new Office 2007 EXCEL, can more the 8 IF statements be used? MORRIPJ	by Mike H	1	751
Data Validation List - Can I have multiple ranges displayed? Jim	by Jim	4	1,881
Data Connection Wizard Richard Horn[_2_]	by Richard Horn[_2_]	0	574
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	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	987
Automating a Worksheet hankb	by Max	6	522
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	564
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	509
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	815
SUMIFS using a text rage Ziggy	by Ziggy	0	605
Date Format DaveMoore	by T. Valko	1	519
Column Average Given 2 Criteria AAA1986	by T. Valko	4	618