Excel Worksheet Functions - Page 544

Thread / Thread Starter	Last Post	Replies	Views
Lookup 2 columns of data, perform, match, output results John	by John	2	732
Using Countif with autofillter John	by ryguy7272	1	401
Using Countif with autofillter John	by John	4	400
multivariate regression John	by Jerry W. Lewis	1	739
convert 500.00 to Five Hundred John 22	by Andy Wiggins	2	392
changing numbers from positive to negative in a sheet John A.	by Bernard Liengme	3	486
sumtotal as per date range John Abetong	by Bob Phillips	4	609
get data in a list table John Abetong	by John Abetong	6	330
very nice........... john adam	by john adam	0	752
Conditional Formatting Help John Adly	by Brian Morris	1	350
Saving sheet data to another sheet automatically John Aikin	by Per Jessen	7	608
Tab Names john anderson	by Max	4	360
data not viewable after installing Java JRE version 1.5.0_06 John Andrews	by John Andrews	0	589
Editing spreadsheets in emails John at Work	by John at Work[_2_]	2	413
replying with attachements John at Work[_2_]	by Peo Sjoblom[_2_]	4	368
Work sheets tab names only replace part ot the present name John Augustein	by Rick Rothstein	2	554
How do I set a start and expiration date using IF function John A[_2_]	by Eduardo	2	714
cell a "bj" cell b "1.00, need to sum cell b1:b117 if a = "bj" john b	by Sheeloo[_3_]	3	494
Help Needed! Using complex IF function John Ball	by joeu2004[_2_]	3	988
How do you use a dropdown menu to enter data in mult. cells exce? John Baylis	by John Baylis[_2_]	4	522
DSum problems John Beccaro	by JBoulton	3	649
How to incorporate cell data in a worksheet header John Bennett	by David D	1	367
Array addressing question... I think John Bennett[_2_]	by Bob Phillips[_4_]	1	394
Nested array functions? John Beyer	by Biff	2	782
Formula for sum of alternate cells John Blackwell	by [email protected]	14	3,592
New rows at the end of a worksheet don't sort with the worksheet John Bloor	by CLR	1	387
How do I get a total adding cells from other sheets for a roll-up John Boy	by Gord Dibben	1	438
Can I have a running total which begins again at 0 when dte chgs? John Boy	by John Boy	0	538
find number in a row John Britto	by Bob Phillips	2	340
dates and if statement work on one sheet, not on another John Brown	by Dave Peterson	3	416
SPELL IN REVERSE ORDER John Bundy	by Dave F	1	758
Populating one worksheet with all lines from other worksheets John Bundy	by John Bundy	0	563
formula to caluclate the # of years and months between two dates John Bundy	by John Bundy	0	514
I would like to sort a work sheet based upon user input value,(dat John Bundy	by John Bundy	0	513
Macro Formula for Max value John Bundy	by John Bundy	0	711
Formula Help John Bundy	by John Bundy	0	518
If formula i think? John Bundy	by John Bundy	0	291
If formula i think? John Bundy	by John Bundy	0	308
Removing last character in a cell John Bundy	by John Bundy	0	473
link to a cell's contents John Bundy	by bluezcruizer	1	563
Trying to Find the Correct Answer-But not using Vlookup Function John Bundy	by caldog	1	537
Trying to Find the Correct Answer-But not using Vlookup Function John Bundy	by John Bundy	0	443
excel how to take choice of 75 rows - create form of 10 selectons John B[_2_]	by Toppers	2	424
I want to jump to a worksheet from a contents sheet John C	by Ian P	2	1,340
I need the percentage of objects used in a drop-down box John C	by Shane Devenshire	2	401
Conditional Underline John C	by bpeltzer	5	679
.FontSize conditionally John C	by Gord Dibben	6	454
multiple functions in a single cell John C.	by Mike H	3	1,047
calculating the future value of an investment in excel John C.	by jermsalerms	4	715
ISBLANK Formula Help Request John C. Harris, MPA	by John C. Harris, MPA	4	839
ADDING TIMES John C. Harris, MPA	by Bob Phillips	5	402
Averaging Blank Cells John Calder	by Dave Peterson	4	519
INDEX function John Case	by Max	3	435
Finding a value based on a running sum John Casey	by Lori	4	334
help with INDEX function John Case[_2_]	by T. Valko	5	346
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,291
Extracting data inexcell 2003 John cheshire lad	by David Biddulph[_2_]	8	511
improve formula offset and indirect John Contact	by Biff	1	732
Variable ranges John Contact	by Biff	1	455
Finding cells that contain references to other workbooks John Cunha	by John Cunha[_2_]	2	501
breakpoint calculation John C[_2_]	by John C[_2_]	0	974
#N/A Error unexplained John C[_2_]	by Duke Carey	1	660
find a sequence John C[_2_]	by John C[_2_]	0	373
Conditional Format Cells to Change Color when used in formula of aDIFFERENT CELL John C[_7_]	by John C[_7_]	0	596
Control Toolbox John Data	by Bob Phillips	3	588
PMT Function John Davies	by Morrigan	4	413
popup message if certain criteria met in formula result John Davies	by John Davies	0	932
count number of occurances of a word in a range John Davies	by Ron Coderre	3	1,020
EXCEL John Davies	by John Data	8	428
Getting a Count John Deakins	by Tania	2	357
Align matching cells of two different columns John Desselle	by John Desselle	2	2,648
generate serial number john douglass	by john douglass	0	1,284
When using Autofilter on Excel, how do I ignore 1st 1 or 2 rows John Driscoll	by Pete	2	536
Office 2010 beta exel John Duffield	by Mike Middleton	1	630
Conditional Copy from one worksheet to another John Duich	by JLatham	1	1,006