Excel Worksheet Functions

Thread / Thread Starter	Last Post	Replies	Views
Help Please!! If(Or(And( formula help Keyrookie	by Keyrookie	0	1,580
Take first word out of cell and put it in a new cell LM	by ExcelBanter AI	6	8,070
Using The Average Function if a cell has NA carl	by ExcelBanter AI	6	7,214
how to return mulitple corresponding values ( 1 2) MetricsShiva	by ExcelBanter AI	70	9,450
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow	by ExcelBanter AI	7	7,253
Edit Links - cannot change source Code Numpty	by ExcelBanter AI	5	7,529
Concatenate path and file string for external reference Michael[_4_]	by ExcelBanter AI	5	7,831
if cell falls within range of number (i.e. 2500 to 4999) Susan	by ExcelBanter AI	3	7,346
how do i calculate inverse tan? Emma	by ExcelBanter AI	6	7,227
return multiple rows of data based on criteria steve_sr2	by ExcelBanter AI	8	7,318
Why can't I use the MONTH function within the SUMIFS statement? djhunt77	by ExcelBanter AI	6	7,375
Increasing payment in future value formula? AXPJESTER	by ExcelBanter AI	5	8,659
Average formula where blank cells are counted as zeros krwelling	by ExcelBanter AI	5	7,280
FREQUENCY with multiple criteria PCLIVE	by ExcelBanter AI	7	8,680
Editing text after concatenate Fozeye	by ExcelBanter AI	3	7,643
calculate the difference between negative and positive values watty	by ExcelBanter AI	7	7,494
Converting annual rate of return to quarterly equivalent? Carl LaFong	by ExcelBanter AI	4	7,253
counting how many times a certain month appears MM	by ExcelBanter AI	5	7,346
How do I get a index% of two numbers when they are negative or pos mrbernh	by ExcelBanter AI	2	8,260
PEARSON versus CORREL Stan Brown	by ExcelBanter AI	3	7,291
autocomplete in dropdown list in Excel as I begin typing Jason W	by ExcelBanter AI	3	7,277
Top half of covariance matrix aaronmsl	by ExcelBanter AI	2	7,940
Find a Value the first Time It Occurs jabbott	by ExcelBanter AI	2	7,696
IF/WHEN forumla fo when a cell is between two numbers philo351	by ExcelBanter AI	5	7,364
Excel - stop automatically changing mixture of uppercase and lowercase to propercase Harry Flashman	by ExcelBanter AI	3	7,351
How can I remove the header and footer on the excel 2007 sheet?. Tran	by ExcelBanter AI	2	7,338
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL silverflyer	by ExcelBanter AI	5	9,359
How to convert vertical blocked list to horizontal list? G Lykos	by ExcelBanter AI	8	7,413
Calculating Average Length of Service EasyPeasy	by ExcelBanter AI	3	7,614
Deleting values less than 100 PointerMan	by ExcelBanter AI	3	7,951
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,368
Restart row count each time the value in a specific column changes RC	by ExcelBanter AI	4	7,674
Formula for average recorded blood pressure readings in 1 column . hjvn1302	by ExcelBanter AI	6	9,070
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,703
Ranking by multiple Criteria Zaphod117	by ExcelBanter AI	3	7,401
Excel: want neg numbers to show red/pos green via if-then formula Jim	by ExcelBanter AI	4	7,539
HELP! Need to divide all columns by same number to get sell price twoods403	by ExcelBanter AI	2	7,376
how to use the active cell in an Excel formula EPMMGR06	by ExcelBanter AI	3	7,791
applying rounding formula to entire worksheet mateo	by ExcelBanter AI	17	8,163
Highlight date nearest to TODAY() Colin Hayes	by ExcelBanter AI	7	9,048
Round a number to the Nearest .25 Dave E	by ExcelBanter AI	3	7,455
how to convert list of numbers to barcode font Convert numbers to barcode in spreadht	by ExcelBanter AI	2	7,601
Adding periods (full stops) to the middle of numbers Derek M[_2_]	by ExcelBanter AI	7	8,833
Circumventing the 255 character header/footer limit Cato Larsen	by ExcelBanter AI	9	8,427
Count if two columns match different criteria Curt D.	by ExcelBanter AI	5	7,470
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell	by ExcelBanter AI	3	7,434
animated text in excel Vijay_India	by ExcelBanter AI	9	8,140
invalid reference for vlookup Ed Hoag	by ExcelBanter AI	2	7,440
Calculating age of death Annie	by ExcelBanter AI	17	8,704
Extract numerator from fraction tf	by ExcelBanter AI	10	8,227
Can you AVERAGE IF and not null? ( 1 2) Spottkitty	by ExcelBanter AI	52	9,104
vlookup on pivot table results = #N/A Louis	by ExcelBanter AI	5	7,450
Copying first three characters of text in a cell Kris	by ExcelBanter AI	4	7,447
First Day of the month Jen_T	by ExcelBanter AI	4	7,439
Reverse Order of Data Set Bekah1st	by ExcelBanter AI	4	7,512
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,469
VLOOKUP returns a 0 and I want a blank KimB	by ExcelBanter AI	7	7,479
Calculate difference between current date & prior S	by ExcelBanter AI	4	7,424
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,502
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,511
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	8,400
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,570
Make #N/A blank if no value is returned Babs in Ohio	by ExcelBanter AI	12	7,509
Excel A3 paper size ???? Igor	by ExcelBanter AI	5	7,575
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,648
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows Michael Marshall	by ExcelBanter AI	11	7,603
how do I convert date format yyyymmdd to mm/dd/yyyy Datahead	by ExcelBanter AI	3	7,898
How can I combine two formulas Left/Mid/Right + Substitute? SCrowley	by ExcelBanter AI	8	7,849
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,518
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,591
How to stop formulas from incrementing when you copy and paste? Kirkwill	by ExcelBanter AI	2	7,571
How to remove the file link from the formula? Jignesh Gandhi	by ExcelBanter AI	4	8,591
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	8,024
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,804
Format date in header Sammie	by ExcelBanter AI	5	8,166