Excel Worksheet Functions - Page 1120

Thread / Thread Starter	Last Post	Replies	Views
Date Formatting DaveMoore	by Daryl S	2	486
Excel not pasting the formula or reference Lindsey	by Luke M[_4_]	1	2,343
count number of dates in range Sunflower[_3_]	by Francis	2	950
adding figures that match 2 true and 1 false if statement conditio UKMAN	by Eduardo	5	597
Redistribution of values after reaching maximum DG	by DG	4	1,058
SELECT SUM(h) WHERE e = 'eBay Payment Sent' yawnmoth	by T. Valko	4	529
Calculate Number of Days worked in Each Month by Project froggygremblin	by froggygremblin	2	1,487
Row Height Adds Blank Space at End of Text Meg	by Meg	0	1,084
Pivot Table - Calculated Field Mike C	by Roger Govier[_8_]	2	883
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 Refresh Eric	by Eric	5	1,405
Downward column climate	by climate	1	448
Select 'Sort By' column by simply typing heading letter dsavant	by Roger Govier[_8_]	1	818
mark up arKwelder	by David Biddulph[_2_]	3	572
Indirect and Sheet Name Rob	by Rob	4	2,503
Excell Spreedsheets Jack Wheeler	by Tony	1	477
Segrigation of different datas from one colum Roy Thomas[_2_]	by ker_01	1	434
Looking for Text strings Scats	by Scats	3	511
Vlookup possibly ? Steve	by Pete_UK	3	490
find cmkwolf	by FSt1	1	389
Using Sumproduct when some of the values are null SanCarlosCyclist	by SanCarlosCyclist	5	1,638
Missing Record in Table Lookup Jim	by Jim	0	495
Entering Formula - Cannot select cell as it is hidden by formula Jim	by Jim	0	778
HELP! TJ	by TJ	4	496
IF - more than seven arguments Hannah	by Hannah	2	576
Sumproduct, but errors in column ker_01	by Bob Phillips[_4_]	6	2,167
How can I count values in multiple non-consecutive cells? Kevin M.[_2_]	by Bob Phillips[_4_]	1	992
General Calculator MIKEY	by Gary''s Student	1	467
counting based on two conditions in excel 2003 Anand	by Bob Phillips[_4_]	4	610
Multiple IF function Jecker	by Jecker	7	640
Formula for multiple countifs J.Scargill[_2_]	by J.Scargill[_2_]	4	796
Formula Needed for lowest three values in a Column frankjh19701	by frankjh19701	12	1,221
Macros AlwaysQuestions	by ericaamousseau	8	514
Print Preview Different than What I see in the Excel File Kashmira	by Kashmira	0	1,658
Array formula to find date Amylou	by Amylou	0	656
Repost - Functions on filtered data LiAD	by LiAD	0	562
SUMPRODUCT help Mark D[_2_]	by Fred Smith[_4_]	3	473
VLookup with Search for in String Benjamin	by Ziggy	4	2,199
Nesting Lookup Functions eionjess	by Ziggy	4	782
Jpeg links opening in Explorer instead of Picture Manager stripedfrog via OfficeKB.com	by stripedfrog via OfficeKB.com	0	1,070
Excel 2007 - Autocomplete Alpha List Jannoth	by Gord Dibben	4	1,626
group/ungroup protected sheets? RLD	by Gord Dibben	1	2,289
Excel data from spreadsheet to database Ricki Miles	by Gord Dibben	1	483
Filling formulas with specific cell references remaining the same quinxorin	by quinxorin	2	519
Combining data nitengale	by Eduardo	1	426
Last number in a column shows in the total/summay line cell Jen S[_2_]	by Ziggy	3	682
adding result of "if" statement.. Xiamen	by Ziggy	3	427
SUMPRODUCT multiple criteria (with a twist) GD	by Ranjith Rajaratnam	13	2,844
Use vlookup within offset? berniean	by T. Valko	4	1,445
Removing ''VALUES'' Mark D[_2_]	by Ziggy	5	617
testing range of cells for part of cell content Daniel	by T. Valko	5	861
data not carrying over from access to excel JoeM[_3_]	by JoeM[_3_]	0	443
Sumproduct with Multiple Criteria JeffTO	by T. Valko	2	408
Complicated IF statement - desperately need some help Mark D[_2_]	by Ziggy	4	444
Formula Question Tony	by Tony	4	481
Collecting data from Excel form Ricki Miles	by Ricki Miles	2	960
excel dates king2385	by Fred Smith[_4_]	1	495
sorting data Hellomoto	by Ashish Mathur[_2_]	2	551
convert vertical to horizontal Mona	by Ashish Mathur[_2_]	6	3,572
reference cell from advanced filter Nathan	by Ashish Mathur[_2_]	3	1,179
Functions on filtered data LiAD	by Ashish Mathur[_2_]	1	737
How can I use a pivot table as source for a second table? Rene	by Ashish Mathur[_2_]	2	1,223
Calculate the number of days to exclude Sunday & Holidays LSG	by T. Valko	6	3,064
Drag Mouse and Add-up MojavMic	by FSt1	1	673
Updating Consecutive Cells in a Range Stilltrader47	by ozgrid.com	1	625
can't use append xml results. Its always grayed out dz	by dz	0	656
feet and inches to meters scott	by David Biddulph[_2_]	4	1,843
Round Vladek	by Vladek	4	527
Calculating greatest number in a range Laura[_4_]	by Laura[_4_]	2	634
Calculating percent of times a value is in a column and total # clbritt76	by Mike H	2	2,748
hOW TO CREATE A BOOKMARK IN EXCEL+ Padre310	by Padre310	0	1,455
Last cell with data in a range iamjbunni	by Ziggy	7	1,150
How to carry Excel balance on 1 w/s to another? SamZ	by John[_22_]	1	1,733
Trying to match 1 value to multiple columns sjoseph371	by Herbert Seidenberg	10	1,209
List the last amount that is state PSL	by T. Valko	2	599