Excel Worksheet Functions - Page 246

Thread / Thread Starter	Last Post	Replies	Views
Microsoft Press book - Data Analysis and Business Modeling David	by David	2	432
irr, xirr, npv frustrations Zachary Chan	by Zachary Chan	4	1,431
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	940
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,760
multiple selections in a sumif functions Frank	by William Horton	2	396
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	462
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	351
Sorting a Concatenated Range Greg	by Dave Peterson	2	341
Conditional formula date Ron Rosenfeld	by Ron Rosenfeld	1	500
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	404
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,042
Issues with saving text file Shane Malden	by Shane Malden	0	745
Formula Tony Muspratt	by Tony Muspratt	0	338
Commission formula jaywerth	by Peo Sjoblom	1	590
Indirect reference (again?) Hundikoer	by Hundikoer	6	462
Unique records of matching pairs pmarques	by pmarques	0	489
lookup formula Marcus	by Marcus	3	605
formula(excel) to skip cells having - number and add + one anthonylaw	by Bruno Campanini	1	579
Picking one column of info scott45	by scott45	0	386
How can I sum every third cell in a row in Excel Ken	by Bruno Campanini	4	1,004
formula in excel to skip cells having - number and add only + anthonylaw	by Paul B	3	830
using =COUNTIF to count two text values John in Surrey	by Trevor Shuttleworth	1	748
How do I specify more than one argument for the SUMIF function? Paul Chalmers	by L Mendoza	3	1,107
Delete Row Macro - if cell $5000 Danny	by Chip Pearson	1	473
Multiple Criteria using countif calmo	by Bob Phillips	6	781
Intervals as logical statements xnadeau	by Bob Phillips	3	446
last four digits of a social security number elli	by Zack Barresse	2	2,168
How do I sequentially number every third page of my workbook? TNDeb	by Zack Barresse	1	578
how to run a macro when a calculation equals a certin number Kevin Jones	by Kevin Jones	0	781
Sumproduct if column begins with text webee33	by Bob Phillips	2	923
Split data from one cell to two separate cells Michele	by Graham Haughs	2	1,830
how to run a macro when a calculation equals a certin number Kevin Jones	by Gary''s Student	1	1,095
compare info in 4 worksheets and highlight fields that are the sam Ellen	by Vacation's Over	3	641
Summing hours Driver	by John Michl	1	375
calculation tjh	by tjh	0	475
Sort Columns in Protected Worksheet, etc. EDSTAFF	by EDSTAFF	0	595
How do center headings across columns in excel ASL	by RagDyer	1	423
Templates double helix	by Anne Troy	1	661
formula to transpose oberon.black	by RagDyer	2	1,390
subtract year and divide crystal	by Anne Troy	7	774
Newbie - Need help with zipcode format- no options for cell lburg801	by lburg801	6	473
Calculate number based on percentage [email protected]	by excelking54	12	2,177
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	506
Excel IRR calculation thudi	by Fred Smith	1	470
Which lookup should I use? SB	by SB	3	418
rounding off month William Horton	by simha	1	291
cell address of occurence of a vlookup formula [email protected]	by [email protected]	5	753
REPLACE Function Scott	by Arvi Laanemets	4	436
average numbers in sequence bill gras	by Stefi	11	930
conditional formating?? cjjoo	by paul	3	436
HOW TO EXTEND A NAMED RANGE ramana	by ramana	5	1,147
List Box Selections Jez	by Bob Phillips	1	499
Move between worksheets SM	by wormdazzler	3	530
offset? match index? sumif? 2way look-up? cjjoo	by cjjoo	2	888
Formatting Columns wg100	by wg100	3	409