Excel Worksheet Functions - Page 246

Thread / Thread Starter	Last Post	Replies	Views
Microsoft Press book - Data Analysis and Business Modeling David	by David	2	431
irr, xirr, npv frustrations Zachary Chan	by Zachary Chan	4	1,426
An array and countif based on criteria in each column Rochelle B	by Peo Sjoblom	1	477
I need to create an array formula combined with a countif Rochelle B	by Rochelle B	5	430
sum from many worksheets cjjoo	by Norman Jones	2	396
creating formula using if function juvena	by [email protected]	2	353
Calculate Interest Rate when payment changes! huntermcg	by huntermcg	2	938
lower case to upper case Louise	by Louise	3	367
Match Index cjjoo	by Bob Phillips	3	1,111
is there a conflict between afxdisp.h and atlbase.h Dicaprio	by Dicaprio	0	486
conditional formula in every third row and last row. ramana	by ramana	2	327
If Function Help Please! Roger F S	by Roger F S	0	305
How to automatically number an index column Phil	by DOR	13	1,758
multiple selections in a sumif functions Frank	by William Horton	2	392
Lookup Array Formula aldsv	by aldsv	4	555
rounding off month Bob Phillips	by William Horton	2	1,174
Pivot table problem... BeSmart	by Debra Dalgleish	1	458
Sheet Reference Alectrical	by Anne Troy	3	468
CountIf Jim	by Peo Sjoblom	2	310
If I don't have MS equation installed in my MS excel how should I sharat	by Anne Troy	1	410
Automatic List Grab? William Horton	by John Michl	1	274
Conditional formula date tghcogo	by tghcogo	0	347
Sorting a Concatenated Range Greg	by Dave Peterson	2	336
Conditional formula date Ron Rosenfeld	by Ron Rosenfeld	1	497
Automatic List Grab? Dave Peterson	by Dave Peterson	0	339
Can I change the font/shading of a cell by moving the mouse over i Husker87	by Dave Peterson	1	402
Count If Jim	by Jim	2	292
How do I sort the data in 8 columns by two of the columns? Sorting	by Bob Umlas	1	854
Can you link an excel spreadsheet to an outlook calendar rkellie	by rkellie	0	1,040
Issues with saving text file Shane Malden	by Shane Malden	0	744
Formula Tony Muspratt	by Tony Muspratt	0	334
Commission formula jaywerth	by Peo Sjoblom	1	586
Indirect reference (again?) Hundikoer	by Hundikoer	6	458
Unique records of matching pairs pmarques	by pmarques	0	488
lookup formula Marcus	by Marcus	3	601
formula(excel) to skip cells having - number and add + one anthonylaw	by Bruno Campanini	1	575
Picking one column of info scott45	by scott45	0	381
How can I sum every third cell in a row in Excel Ken	by Bruno Campanini	4	999
formula in excel to skip cells having - number and add only + anthonylaw	by Paul B	3	826
using =COUNTIF to count two text values John in Surrey	by Trevor Shuttleworth	1	744
How do I specify more than one argument for the SUMIF function? Paul Chalmers	by L Mendoza	3	1,098
Delete Row Macro - if cell $5000 Danny	by Chip Pearson	1	469
Multiple Criteria using countif calmo	by Bob Phillips	6	780
Intervals as logical statements xnadeau	by Bob Phillips	3	441
last four digits of a social security number elli	by Zack Barresse	2	2,167
How do I sequentially number every third page of my workbook? TNDeb	by Zack Barresse	1	573
how to run a macro when a calculation equals a certin number Kevin Jones	by Kevin Jones	0	780
Sumproduct if column begins with text webee33	by Bob Phillips	2	921
Split data from one cell to two separate cells Michele	by Graham Haughs	2	1,828
how to run a macro when a calculation equals a certin number Kevin Jones	by Gary''s Student	1	1,091
compare info in 4 worksheets and highlight fields that are the sam Ellen	by Vacation's Over	3	639
Summing hours Driver	by John Michl	1	375
calculation tjh	by tjh	0	471
Sort Columns in Protected Worksheet, etc. EDSTAFF	by EDSTAFF	0	590
How do center headings across columns in excel ASL	by RagDyer	1	420
Templates double helix	by Anne Troy	1	653
formula to transpose oberon.black	by RagDyer	2	1,378
subtract year and divide crystal	by Anne Troy	7	774
Newbie - Need help with zipcode format- no options for cell lburg801	by lburg801	6	471
Calculate number based on percentage [email protected]	by excelking54	12	2,175
Conditional Fromatting and Formulas Mark C via OfficeKB.com	by Biff	5	449
Problem occur in sum function while deleting the rows Ellis Yu	by Ellis Yu	0	599
Auto Record Transfer (2) Freshman	by Anne Troy	7	505
Excel IRR calculation thudi	by Fred Smith	1	464
Which lookup should I use? SB	by SB	3	406
rounding off month William Horton	by simha	1	291
cell address of occurence of a vlookup formula [email protected]	by [email protected]	5	752
REPLACE Function Scott	by Arvi Laanemets	4	432
average numbers in sequence bill gras	by Stefi	11	930
conditional formating?? cjjoo	by paul	3	434
HOW TO EXTEND A NAMED RANGE ramana	by ramana	5	1,143
List Box Selections Jez	by Bob Phillips	1	497
Move between worksheets SM	by wormdazzler	3	530
offset? match index? sumif? 2way look-up? cjjoo	by cjjoo	2	884
Formatting Columns wg100	by wg100	3	393