Excel Worksheet Functions - Page 132

Thread / Thread Starter	Last Post	Replies	Views
conditional formatting refferencing another cell Sudipto	by Jacob Skaria	3	436
Enable Macro Alert Box Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	9	1,125
Conditional Formatting Pat Z.	by Elardus	5	521
Need help with DGET function Bob	by Ashish Mathur[_2_]	7	578
Find Sum of Values corresponding to each value type Evans	by Jacob Skaria	1	467
Copying cells from one sheet to another Andrew	by Jacob Skaria	4	698
Need help in showing future purchases over a period of time and atset intervals hejnoid	by hejnoid	2	419
nested "If" fuction Jacob Skaria	by Jacob Skaria	0	333
How do I use formulas using dynamic names DannyP	by Ashish Mathur[_2_]	1	515
How to change cell background color as part of the If statement? Jim H	by L. Howard Kittle	2	3,211
#VALUE using SUMPRODUCT function Brooks W.	by Bob Phillips[_3_]	3	537
Increments less than one in format control box for spinner T. Valko	by T. Valko	0	1,207
nested "If" fuction Sean Timmons	by Sean Timmons	0	419
When I link blank cell in one sheet registers as 0 for averaging DickS	by Pete_UK	3	766
Sumproduct with mulitple criteria containing equals and or's Mike	by Mike	5	645
Excel 2003 - open work book useage agreement mbotfield	by Mike H	3	558
create "IF" formula ? Brent05Redfire	by T. Valko	3	352
COS H (Trigonometry) Shortstopper00	by Sam Wilson	6	819
Worksheet functions plot and #NA's Morten Hvidberg-Knudsen	by David Biddulph[_2_]	3	392
Building Dynamic SUMIF statement Nancy Taylor	by Nancy Taylor[_2_]	17	1,051
COUNTIF - USING WITH TIME VALUE RANGES Kazman	by Jacob Skaria	2	2,100
Auto Capitalising an active cell NoodNutt	by NoodNutt	4	465
Worksheet setting error... Lakshmi Murthy	by Lakshmi Murthy	0	1,816
Conditional Formatting with COUNTIF Rovermog	by Bob Phillips[_3_]	2	568
Runtime 9 error Check. Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	2	427
LOOKUP function Arfa	by Jacob Skaria	4	430
COUNTIF with a range of time values Kazman	by T. Valko	2	1,079
vLookup a portion of a no. in a cell kattay	by T. Valko	3	815
The clear filter from a a heading cell is grey out Mark	by Mark	2	3,946
Countif earlfj	by Bernd P	2	364
validate # of decimal MauraC	by JoeU2004	6	564
#DIV/0 ERRORS IN PIVOT TABLES Bel@RFoods	by Bel@RFoods	0	1,099
Location Oriented Formula Loadmaster	by Pete_UK	1	460
Row Height Adjustment on data Imported into excel Lisa	by Gord Dibben	1	569
I have the following issue with COUNTIF Fab	by FSt1	2	453
How can I copy multiple formulas between workbooks at once? Hank	by Don Guillett	1	576
2002 Hyperlink issues AlexW	by AlexW	2	327
SUMPRODUCT with INDIRECT Nancy Taylor[_2_]	by Nancy Taylor[_2_]	4	693
Generating different numbers of rows depending on data davedownunder	by davedownunder	0	454
Return a value based on 2 or more columns of information Becca.T.	by Luke M	2	362
MERGE 3 columns into 1 all text Suzie	by Luke M	3	1,360
averaging a column of letter grades into a numeric GPA David Aukerman[_2_]	by David Aukerman[_2_]	3	3,155
Formatting numbers highbloodpressure1949	by Eduardo	1	529
How to pop out individual data from cluster of data GINN	by Gord Dibben	3	450
PAGE VIEWS GrantsDiva	by Gord Dibben	2	403
inserted comment not displays in the cell it displays on top row S.Kumar	by Gord Dibben	1	429
retrieve duplicate information from two reports to create new rep. Marie A	by Marie A	0	454
Sort each line horizontally and separately nils	by Gord Dibben	2	1,147
Automatically move text from one document to another BB	by Don Guillett	1	550
Formula with dates in COLOR loulou	by loulou	3	404
If then request bpc	by Pete_UK	1	430
Conditional formatting based on max in range of other columns Steve	by Steve	2	671
Calculating Kay	by Kay	0	343
Create formula to; sum the lowest 10 cells in a column PCat	by T. Valko	3	510
highlighting cells with formulas Michael Angelo[_2_]	by Don Guillett	3	894
remove fill in text from a cell from an unpopulated fill-in cell Deb[_3_]	by Pete_UK	1	549
How can I show up and down arrows when a value changes? Julie	by Eduardo	1	2,546
In Cell Formula to mimic text to columns. InsomniacFolder	by InsomniacFolder	2	594
Spreed cost usig integral numbers (whole numbers) nils	by Eduardo	1	383
Add criteria to sumproduct Greater than or equal to Diddy	by Diddy	5	6,105
Sorting data with a formula PeteJ	by Bernd P	4	483
Sheets have different size in typing Lars	by Jacob Skaria	1	366
Function with unknown quantities? maudeq	by Thanks	1	406
Convert text string to IP address Mike	by Ron Rosenfeld	3	1,478
place array at calculated position davedownunder	by Jacob Skaria	2	431
How can i do this??? wilko[_2_]	by T. Valko	1	343
Function with unknown quantities? maudeq	by T. Valko	1	528
Page layout problems after moving worksheet BonBonSpeecher	by BonBonSpeecher	0	373
does Excel 07 allow User Defined functions? doc_grandma	by David Biddulph[_2_]	1	515
When Does Excel Do The Linking? luvwknd	by luvwknd	1	372
How to calculate with formula results after formatting with =TEXT VickiMc	by Fred Smith[_4_]	3	465
How to replace a zero with "Not Available" The Needy[_2_]	by JoeU2004	6	489
How to work out 3 different % Sam	by Mike H	1	376
INDEX AND MATCHING FUNCTIONS Jeanette	by Mike H	5	426
Conditional Formating and Recalc Thanks	by Thanks	2	491