Excel Worksheet Functions - Page 503

Thread / Thread Starter	Last Post	Replies	Views
How to use a variable for a range Jeff Lowenstein	by JMB	1	540
Vlookup using variable path name for range value Jeff Lowenstein	by Peo Sjoblom	1	2,115
Problems using a variable as a Table_Array in VLOOKUP Jeff Lowenstein	by Biff	1	758
using sumproduct on subtotals meeting certain conditions Jeff Manning	by Jeff Manning	0	428
Avoiding #Value errors when referencing DB Tables Jeff Metcalf	by Jeff Metcalf	2	433
multifuntion formula jeff moore via OfficeKB.com	by JulieD	1	523
Comparing Lists of text using colors or by other means Jeff M[_2_]	by Squeaky	1	465
No save function if Jeff Owen	by Jeff Owen	7	1,048
Formula results in font color change Jeff P	by Frank Kabel	2	2,518
2-Dim Lookup Jeff Spiccoli	by Jeff Spiccoli	6	786
When using & and a date-formatted cell in a formula I lose the for Jeff Stouse	by Pete_UK	2	645
Excel should have a QUARTER formula for DATE calculations Jeff Stubing	by JMB	5	4,554
Formula for Sequencing Totals Jeff T	by Aladin Akyurek	13	1,436
I need help with the IF Statement Jeff Thomas	by Sandy Mann	5	420
vlookup Jeff W	by Bob Bridges	2	473
need formula to return data from one column after comparing 2 othe Jeff W	by Max	3	460
Displaying row information in another file Jeff Weinberg	by Pete_UK	1	493
Autofilter grayed out - why? Jeff Weinberg	by Gord Dibben	2	1,484
sumproduct forumla, but I want difference instead of sum Jeff Wheeler	by Barb Reinhardt	2	468
Counting unique entries in a field Jeff Whitesel	by JMB	5	610
sumif() using range name Jeff Wimer	by Bob Phillips	1	754
formula that will reference another worksheets info. same book Jeff Wood	by GuyHD	4	562
Sum a range of cells starting from an offset date list from TODAY() [email protected]	by daddylonglegs	3	758
average in excle [email protected]	by Dave Thomas	10	862
yield function jeff4860	by Ron Rosenfeld	1	684
2 Conditions + Sum of a colum matching those conditions Jeffa	by Jeffa	5	846
Sumproduct, multiple conditions.. but I also want to "minus" somet Jeffa	by Roger Govier	4	579
Feeding data from one spreadsheet to another. Jeffa	by Jeffa	5	1,739
Lookup on multiple criteria and max jeffbert	by Teethless mama	2	915
Round to up to a threshold jeffbert	by jeffbert	6	1,129
Weeks of Supply Function jeffbert	by Jim Cone	1	2,531
Cell Combining Question JeffC	by JeffC	3	373
vlookup Function Help Needed jeffc	by jeffc	2	559
Define variable range input for SUM() function JeffC	by T. Valko	4	1,687
Use cell to determine column in formula JeffC	by Jacob Skaria	2	437
Count Names in One Col if 2nd Col Isn't Blank jeffc	by Bob Phillips	9	456
Compare one Column to a Second Column Formula Help Needed jeffc	by Bob Phillips	1	544
Hide #DIV/0! jeffc4442	by Harlan Grove	4	1,140
repeating data in column to empty cells below without overwriting jeffchina	by Max	1	1,102
enter date(A) and have (B) total to current day? jeffcol777	by Bob Phillips	3	442
"enter key" problem jeffc[_2_]	by Teethless mama	1	317
å¦‚ä½•åŠ*ç¸½ç®—å‡ºsigma(1åˆ°n) jefferson	by Bob Bridges[_2_]	1	1,810
Sort, Copy, Paste..without Autofilter..Anyone??? jeffg	by Arvi Laanemets	1	540
Conditional formatting with more than 3 conditions. jeffg	by jeffg	0	464
4 condition conditional formatting jeffg	by jeffg	2	612
Need help searching another sheet and retrieving a value JeffH	by Biff	1	363
Can an if then formula be done for this? JeffinSC	by Anne Troy	1	345
I get error messages in Excel cells once I save a file JeffJake	by Gord Dibben	1	691
Merging two data tables together using Lookup function JeffK	by JeffK	1	449
Sumif JeffK	by David Biddulph[_2_]	5	405
Table Lookup JeffK	by JeffK	3	316
Date Range JeffK	by Jacob Skaria	2	416
Lookup JeffK	by JeffK	3	367
Vlookup JeffK	by JeffK	5	442
Value in Next Row JeffK	by JeffK	3	3,239
table lookup JeffK	by JeffK	5	322
calculating the sum of different categories over a given time peri JeffK	by Shane Devenshire[_2_]	4	440
Headings of columns now have numbers, need to change them to lette JeffL	by David Biddulph[_2_]	3	498
How do I only send 1 worksheet of a file in an e-mail? JeffL	by Luke M	1	486
sumif issues jeffm70	by joeu2004[_2_]	2	730
Calling procedure when leaving cell jeffP	by jeffP	5	533
Case Sensitive w/ IF jeffP	by Dave Peterson	11	1,087
How Do I Query a Named Range JeffP->	by JeffP->	2	819
Query Named Range Return Single Column Value JeffP->	by Bernie Deitrick	5	1,228
wnt to look up fr a vlue in a clmn nd get the avg of the row Jeffrey	by Max	7	642
Select 3/4 digit numbers from text jeffrey	by Ron Rosenfeld[_2_]	2	576
sum everything but errors Jeffrey	by Jeffrey	5	1,055
Row references jeffrey	by Ron Rosenfeld[_2_]	1	660
What formulae to derive? Jeffrey	by Don Guillett	1	427
Trying to transfer info from one worksheet to another jeffrey	by jeffrey	0	345
Transfering info from main worksheet to multiple worksheets jeffrey	by jeffrey	0	643
Data association Jeffrey	by Max	5	709
Fill coloring for Past Dates in a worksheet jeffrey	by JP[_4_]	1	372
wrong year Jeffrey	by Max	1	515
Derive a formule for finding the average Jeffrey	by Don Guillett	3	1,305