Excel Worksheet Functions - Page 132

Thread / Thread Starter	Last Post	Replies	Views
conditional formatting refferencing another cell Sudipto	by Jacob Skaria	3	452
Enable Macro Alert Box Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	9	1,137
Conditional Formatting Pat Z.	by Elardus	5	530
Need help with DGET function Bob	by Ashish Mathur[_2_]	7	586
Find Sum of Values corresponding to each value type Evans	by Jacob Skaria	1	477
Copying cells from one sheet to another Andrew	by Jacob Skaria	4	704
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	343
How do I use formulas using dynamic names DannyP	by Ashish Mathur[_2_]	1	521
How to change cell background color as part of the If statement? Jim H	by L. Howard Kittle	2	3,218
#VALUE using SUMPRODUCT function Brooks W.	by Bob Phillips[_3_]	3	550
Increments less than one in format control box for spinner T. Valko	by T. Valko	0	1,212
nested "If" fuction Sean Timmons	by Sean Timmons	0	429
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	646
Excel 2003 - open work book useage agreement mbotfield	by Mike H	3	558
create "IF" formula ? Brent05Redfire	by T. Valko	3	362
COS H (Trigonometry) Shortstopper00	by Sam Wilson	6	820
Worksheet functions plot and #NA's Morten Hvidberg-Knudsen	by David Biddulph[_2_]	3	404
Building Dynamic SUMIF statement Nancy Taylor	by Nancy Taylor[_2_]	17	1,062
COUNTIF - USING WITH TIME VALUE RANGES Kazman	by Jacob Skaria	2	2,107
Auto Capitalising an active cell NoodNutt	by NoodNutt	4	465
Worksheet setting error... Lakshmi Murthy	by Lakshmi Murthy	0	1,819
Conditional Formatting with COUNTIF Rovermog	by Bob Phillips[_3_]	2	578
Runtime 9 error Check. Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	2	443
LOOKUP function Arfa	by Jacob Skaria	4	441
COUNTIF with a range of time values Kazman	by T. Valko	2	1,087
vLookup a portion of a no. in a cell kattay	by T. Valko	3	818
The clear filter from a a heading cell is grey out Mark	by Mark	2	3,947
Countif earlfj	by Bernd P	2	371
validate # of decimal MauraC	by JoeU2004	6	577
#DIV/0 ERRORS IN PIVOT TABLES Bel@RFoods	by Bel@RFoods	0	1,110
Location Oriented Formula Loadmaster	by Pete_UK	1	471
Row Height Adjustment on data Imported into excel Lisa	by Gord Dibben	1	582
I have the following issue with COUNTIF Fab	by FSt1	2	464
How can I copy multiple formulas between workbooks at once? Hank	by Don Guillett	1	589
2002 Hyperlink issues AlexW	by AlexW	2	337
SUMPRODUCT with INDIRECT Nancy Taylor[_2_]	by Nancy Taylor[_2_]	4	694
Generating different numbers of rows depending on data davedownunder	by davedownunder	0	464
Return a value based on 2 or more columns of information Becca.T.	by Luke M	2	373
MERGE 3 columns into 1 all text Suzie	by Luke M	3	1,371
averaging a column of letter grades into a numeric GPA David Aukerman[_2_]	by David Aukerman[_2_]	3	3,157
Formatting numbers highbloodpressure1949	by Eduardo	1	536
How to pop out individual data from cluster of data GINN	by Gord Dibben	3	462
PAGE VIEWS GrantsDiva	by Gord Dibben	2	406
inserted comment not displays in the cell it displays on top row S.Kumar	by Gord Dibben	1	444
retrieve duplicate information from two reports to create new rep. Marie A	by Marie A	0	466
Sort each line horizontally and separately nils	by Gord Dibben	2	1,156
Automatically move text from one document to another BB	by Don Guillett	1	557
Formula with dates in COLOR loulou	by loulou	3	414
If then request bpc	by Pete_UK	1	441
Conditional formatting based on max in range of other columns Steve	by Steve	2	675
Calculating Kay	by Kay	0	352
Create formula to; sum the lowest 10 cells in a column PCat	by T. Valko	3	521
highlighting cells with formulas Michael Angelo[_2_]	by Don Guillett	3	897
remove fill in text from a cell from an unpopulated fill-in cell Deb[_3_]	by Pete_UK	1	560
How can I show up and down arrows when a value changes? Julie	by Eduardo	1	2,554
In Cell Formula to mimic text to columns. InsomniacFolder	by InsomniacFolder	2	609
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,115
Sorting data with a formula PeteJ	by Bernd P	4	496
Sheets have different size in typing Lars	by Jacob Skaria	1	378
Function with unknown quantities? maudeq	by Thanks	1	418
Convert text string to IP address Mike	by Ron Rosenfeld	3	1,489
place array at calculated position davedownunder	by Jacob Skaria	2	444
How can i do this??? wilko[_2_]	by T. Valko	1	351
Function with unknown quantities? maudeq	by T. Valko	1	538
Page layout problems after moving worksheet BonBonSpeecher	by BonBonSpeecher	0	383
does Excel 07 allow User Defined functions? doc_grandma	by David Biddulph[_2_]	1	527
When Does Excel Do The Linking? luvwknd	by luvwknd	1	383
How to calculate with formula results after formatting with =TEXT VickiMc	by Fred Smith[_4_]	3	479
How to replace a zero with "Not Available" The Needy[_2_]	by JoeU2004	6	498
How to work out 3 different % Sam	by Mike H	1	385
INDEX AND MATCHING FUNCTIONS Jeanette	by Mike H	5	440
Conditional Formating and Recalc Thanks	by Thanks	2	502