Excel Worksheet Functions - Page 602

Thread / Thread Starter	Last Post	Replies	Views
Get value equal to final point of chart trendline [=Trend( )] ? ker_01	by Bernie Deitrick	1	1,681
Identify which column 'Large' finds a match in ker_01	by T. Valko	6	434
Sumproduct, but errors in column ker_01	by Bob Phillips[_4_]	6	2,167
Data Validation drop-down width, with named range source (XL03 and ker_01	by T. Valko	4	2,392
Sumproduct but only first time corresponding value is seen e.g. un ker_01	by T. Valko	1	653
using indirect to return a named range? ker_01	by ker_01	1	1,234
Multiple data validation criteria? ker_01	by ker_01	0	1,067
Concatenate N cells (where N is a worksheet value) ker_01	by MyVeryOwnSelf[_2_]	3	977
Embed a 'match' statement in sumproduct? ker_01	by ker_01	3	660
returning text; alternative to sumproduct/sumif? ker_01	by Ashish Mathur[_2_]	4	599
Difference between these two formulas? ker_01	by ker_01	5	487
Simpler way to pull a cell value from a group based on 2 factors? ker_01	by smartin	1	320
XL07 create data validation list containing the names of each shee ker_01	by ker_01	0	422
#DIVI/0 issue Kesbutler	by Luke M	1	610
SumIf statement: incrementing Kesbutler	by Kesbutler	2	435
create a forumla based on date Kesbutler	by David Biddulph[_2_]	7	500
How do I color a cell based on cell text Kesbutler	by Gary''s Student	1	638
Display dates from an Excel spreadsheet in a calendar? kescheu	by kescheu	0	768
help on lookup functions Kesqsay	by Ian	1	471
Excel and propogating data Kessie	by Arvi Laanemets	6	728
Tab Key kessler	by Gord Dibben	1	359
Pivot table: Custom "Summarize by" functions kestasjk	by Roger Govier	1	538
write a formula to sum cells on different pages of the same workb. Kestle	by Frank Kabel	1	773
Sum & Lookup function kestrel	by Aladin Akyurek	5	423
Inserting variables within file names kestrel	by Bob Phillips	3	425
Removing the last two digits of a cell kestrel	by Kevin Vaughn	3	609
the value of Text? Kestrel1492	by Kestrel1492	4	337
Convert text to dates Ket	by Arvi Laanemets	5	1,261
Data Filter and AutoSum Ket	by broro183	4	936
Replace double spaces with Hard return Ket	by John Michl	3	553
SUMIF?? Ket	by Ket	4	358
Auditing Ket	by Ket	0	390
SUMIF/SUMPRODUCT?? Ket	by Ken Hudson	2	479
Exporting Data Ket	by Ket	0	539
Data Export Ket	by Duke Carey	1	513
Cell Protection Issue Ket	by Debra Dalgleish	1	573
SUMIF?? Ket	by Don Guillett	2	399
Printing?? Ket	by Ket	0	435
Hyperlinks Ket	by HiArt	1	393
Adding Cells Ket	by JulieD	6	613
Excel 2003 V's Excel 2000? Ket	by Ket	2	1,097
Duplication in Column Ket	by Bob Phillips	2	424
Tab in a cell? Ket	by XC	2	437
Simple Format Question Ket	by Peo Sjoblom	1	492
VB Required?? Ket	by Matt Lunn	3	472
Data Validation Ket	by DM Unseen	1	338
LOOKUP?? Ket	by Aladin Akyurek	7	445
3D Workbook?? Ket	by RagDyeR	3	454
SUMPRODUCT??? Ket	by Myrna Larson	3	473
Locking a table Ket	by Ian	3	285
Pivot Table Auto Update Data Source? Ket	by Debra Dalgleish	1	2,431
how do i display numbers in lacs ketan	by Bob Phillips	3	448
How do i use the If function to Lookup in a chart kethrydrake	by T. Valko	1	312
Error when trying to insert columns: "Nonblanc cells" ketil	by Gaurav[_3_]	1	415
Count functions with multiple conditions/ranges kEV	by kEV	3	365
how do i auto update cell values after pasting linked references kev	by kev	0	805
How do i get sheet 2 to show a specific section of sheet 1?Please Kev	by Duke Carey	4	486
Cross Reference Vertical and Horizontal for Data Kev - Radio Man	by Kev - Radio Man	4	1,231
View Message when Mouse Hovers over Cell. (Not the Comments Feild) Kev - Radio Man	by Kev - Radio Man	2	1,690
Problems with links to another workbook Kev G	by Duke Carey	3	419
Counting and Suming based on multiple criteria Kev270	by Bob Phillips	1	474
Can logical formulas be used to build accounts receivable workshe. Kev270	by Peo Sjoblom	2	732
Finding questions I have posted kevan	by Pete_UK	5	603
combining IF OR Functions kevan	by Shane Devenshire	4	1,381
Countif Function?? Kevan	by T. Valko	3	518
How do I add items within the last 12 months? Kevbro7189	by Ron Rosenfeld	3	511
use cell address kevcar40	by Don Guillett[_2_]	1	559
find a sum from a list of numbers Keven	by Richard Neville	1	604
math problem Keven	by Steph	2	406
Simplify a large nesting string to use in Excel 2003 Keven89	by Shane Devenshire[_2_]	1	390
User Defined Function and VLookUP Kevin	by Kevin	11	1,150
Weighted Averages? Kevin	by Bernard Liengme[_3_]	5	638
I have a column of many many numbers how can i split them up auto Kevin	by Pete_UK	1	379
Cost increase rate Kevin	by Kevin	3	517
CELL("filename") doesn't work on shortcut workbook link? Kevin	by Kevin	12	1,812