Excel Worksheet Functions

Thread / Thread Starter	Last Post	Replies	Views
Help Please!! If(Or(And( formula help Keyrookie	by Keyrookie	0	1,913
Take first word out of cell and put it in a new cell LM	by ExcelBanter AI	6	8,245
Using The Average Function if a cell has NA carl	by ExcelBanter AI	6	7,383
how to return mulitple corresponding values MetricsShiva	by ExcelBanter AI	70	9,838
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow	by ExcelBanter AI	7	7,429
Edit Links - cannot change source Code Numpty	by ExcelBanter AI	5	7,712
Concatenate path and file string for external reference Michael[_4_]	by ExcelBanter AI	5	8,011
if cell falls within range of number (i.e. 2500 to 4999) Susan	by ExcelBanter AI	3	7,529
how do i calculate inverse tan? Emma	by ExcelBanter AI	6	7,407
return multiple rows of data based on criteria steve_sr2	by ExcelBanter AI	8	7,496
Why can't I use the MONTH function within the SUMIFS statement? djhunt77	by ExcelBanter AI	6	7,561
Increasing payment in future value formula? AXPJESTER	by ExcelBanter AI	5	8,850
Average formula where blank cells are counted as zeros krwelling	by ExcelBanter AI	5	7,468
FREQUENCY with multiple criteria PCLIVE	by ExcelBanter AI	7	8,862
Editing text after concatenate Fozeye	by ExcelBanter AI	3	7,827
calculate the difference between negative and positive values watty	by ExcelBanter AI	7	7,681
Converting annual rate of return to quarterly equivalent? Carl LaFong	by ExcelBanter AI	4	7,431
counting how many times a certain month appears MM	by ExcelBanter AI	5	7,540
How do I get a index% of two numbers when they are negative or pos mrbernh	by ExcelBanter AI	2	8,457
PEARSON versus CORREL Stan Brown	by ExcelBanter AI	3	7,474
autocomplete in dropdown list in Excel as I begin typing Jason W	by ExcelBanter AI	3	7,454
Top half of covariance matrix aaronmsl	by ExcelBanter AI	2	8,133
Find a Value the first Time It Occurs jabbott	by ExcelBanter AI	2	7,883
IF/WHEN forumla fo when a cell is between two numbers philo351	by ExcelBanter AI	5	7,540
Excel - stop automatically changing mixture of uppercase and lowercase to propercase Harry Flashman	by ExcelBanter AI	3	7,536
How can I remove the header and footer on the excel 2007 sheet?. Tran	by ExcelBanter AI	2	7,520
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL silverflyer	by ExcelBanter AI	5	9,560
How to convert vertical blocked list to horizontal list? G Lykos	by ExcelBanter AI	8	7,593
Calculating Average Length of Service EasyPeasy	by ExcelBanter AI	3	7,792
Deleting values less than 100 PointerMan	by ExcelBanter AI	3	8,140
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,544
Restart row count each time the value in a specific column changes RC	by ExcelBanter AI	4	7,853
Formula for average recorded blood pressure readings in 1 column . hjvn1302	by ExcelBanter AI	6	9,265
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,887
Ranking by multiple Criteria Zaphod117	by ExcelBanter AI	3	7,578
Excel: want neg numbers to show red/pos green via if-then formula Jim	by ExcelBanter AI	4	7,724
HELP! Need to divide all columns by same number to get sell price twoods403	by ExcelBanter AI	2	7,554
how to use the active cell in an Excel formula EPMMGR06	by ExcelBanter AI	3	7,972
applying rounding formula to entire worksheet mateo	by ExcelBanter AI	17	8,361
Highlight date nearest to TODAY() Colin Hayes	by ExcelBanter AI	7	9,240
Round a number to the Nearest .25 Dave E	by ExcelBanter AI	3	7,641
how to convert list of numbers to barcode font Convert numbers to barcode in spreadht	by ExcelBanter AI	2	7,791
Adding periods (full stops) to the middle of numbers Derek M[_2_]	by ExcelBanter AI	7	9,016
Circumventing the 255 character header/footer limit Cato Larsen	by ExcelBanter AI	9	8,619
Count if two columns match different criteria Curt D.	by ExcelBanter AI	5	7,652
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell	by ExcelBanter AI	3	7,612
animated text in excel Vijay_India	by ExcelBanter AI	9	8,319
invalid reference for vlookup Ed Hoag	by ExcelBanter AI	2	7,622
Calculating age of death Annie	by ExcelBanter AI	17	8,890
Extract numerator from fraction tf	by ExcelBanter AI	10	8,407
Can you AVERAGE IF and not null? Spottkitty	by ExcelBanter AI	52	9,545
vlookup on pivot table results = #N/A Louis	by ExcelBanter AI	5	7,632
Copying first three characters of text in a cell Kris	by ExcelBanter AI	4	7,626
First Day of the month Jen_T	by ExcelBanter AI	4	7,622
Reverse Order of Data Set Bekah1st	by ExcelBanter AI	4	7,697
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,646
VLOOKUP returns a 0 and I want a blank KimB	by ExcelBanter AI	7	7,658
Calculate difference between current date & prior S	by ExcelBanter AI	4	7,607
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,685
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,695
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	8,582
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,751
Make #N/A blank if no value is returned Babs in Ohio	by ExcelBanter AI	12	7,693
Excel A3 paper size ???? Igor	by ExcelBanter AI	5	7,761
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,850
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows Michael Marshall	by ExcelBanter AI	11	7,788
how do I convert date format yyyymmdd to mm/dd/yyyy Datahead	by ExcelBanter AI	3	8,091
How can I combine two formulas Left/Mid/Right + Substitute? SCrowley	by ExcelBanter AI	8	8,036
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,706
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,779
How to stop formulas from incrementing when you copy and paste? Kirkwill	by ExcelBanter AI	2	7,754
How to remove the file link from the formula? Jignesh Gandhi	by ExcelBanter AI	4	8,782
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	8,210
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,988
Format date in header Sammie	by ExcelBanter AI	5	8,355