Excel Worksheet Functions

Thread / Thread Starter	Last Post	Replies	Views
Help Please!! If(Or(And( formula help Keyrookie	by Keyrookie	0	1,927
Take first word out of cell and put it in a new cell LM	by ExcelBanter AI	6	8,249
Using The Average Function if a cell has NA carl	by ExcelBanter AI	6	7,388
how to return mulitple corresponding values MetricsShiva	by ExcelBanter AI	70	9,882
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow	by ExcelBanter AI	7	7,435
Edit Links - cannot change source Code Numpty	by ExcelBanter AI	5	7,718
Concatenate path and file string for external reference Michael[_4_]	by ExcelBanter AI	5	8,016
if cell falls within range of number (i.e. 2500 to 4999) Susan	by ExcelBanter AI	3	7,534
how do i calculate inverse tan? Emma	by ExcelBanter AI	6	7,412
return multiple rows of data based on criteria steve_sr2	by ExcelBanter AI	8	7,503
Why can't I use the MONTH function within the SUMIFS statement? djhunt77	by ExcelBanter AI	6	7,566
Increasing payment in future value formula? AXPJESTER	by ExcelBanter AI	5	8,853
Average formula where blank cells are counted as zeros krwelling	by ExcelBanter AI	5	7,473
FREQUENCY with multiple criteria PCLIVE	by ExcelBanter AI	7	8,867
Editing text after concatenate Fozeye	by ExcelBanter AI	3	7,832
calculate the difference between negative and positive values watty	by ExcelBanter AI	7	7,687
Converting annual rate of return to quarterly equivalent? Carl LaFong	by ExcelBanter AI	4	7,435
counting how many times a certain month appears MM	by ExcelBanter AI	5	7,543
How do I get a index% of two numbers when they are negative or pos mrbernh	by ExcelBanter AI	2	8,461
PEARSON versus CORREL Stan Brown	by ExcelBanter AI	3	7,478
autocomplete in dropdown list in Excel as I begin typing Jason W	by ExcelBanter AI	3	7,460
Top half of covariance matrix aaronmsl	by ExcelBanter AI	2	8,137
Find a Value the first Time It Occurs jabbott	by ExcelBanter AI	2	7,888
IF/WHEN forumla fo when a cell is between two numbers philo351	by ExcelBanter AI	5	7,544
Excel - stop automatically changing mixture of uppercase and lowercase to propercase Harry Flashman	by ExcelBanter AI	3	7,542
How can I remove the header and footer on the excel 2007 sheet?. Tran	by ExcelBanter AI	2	7,525
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL silverflyer	by ExcelBanter AI	5	9,566
How to convert vertical blocked list to horizontal list? G Lykos	by ExcelBanter AI	8	7,597
Calculating Average Length of Service EasyPeasy	by ExcelBanter AI	3	7,797
Deleting values less than 100 PointerMan	by ExcelBanter AI	3	8,147
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,548
Restart row count each time the value in a specific column changes RC	by ExcelBanter AI	4	7,860
Formula for average recorded blood pressure readings in 1 column . hjvn1302	by ExcelBanter AI	6	9,269
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,892
Ranking by multiple Criteria Zaphod117	by ExcelBanter AI	3	7,583
Excel: want neg numbers to show red/pos green via if-then formula Jim	by ExcelBanter AI	4	7,730
HELP! Need to divide all columns by same number to get sell price twoods403	by ExcelBanter AI	2	7,558
how to use the active cell in an Excel formula EPMMGR06	by ExcelBanter AI	3	7,976
applying rounding formula to entire worksheet mateo	by ExcelBanter AI	17	8,365
Highlight date nearest to TODAY() Colin Hayes	by ExcelBanter AI	7	9,245
Round a number to the Nearest .25 Dave E	by ExcelBanter AI	3	7,644
how to convert list of numbers to barcode font Convert numbers to barcode in spreadht	by ExcelBanter AI	2	7,795
Adding periods (full stops) to the middle of numbers Derek M[_2_]	by ExcelBanter AI	7	9,019
Circumventing the 255 character header/footer limit Cato Larsen	by ExcelBanter AI	9	8,623
Count if two columns match different criteria Curt D.	by ExcelBanter AI	5	7,656
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell	by ExcelBanter AI	3	7,617
animated text in excel Vijay_India	by ExcelBanter AI	9	8,322
invalid reference for vlookup Ed Hoag	by ExcelBanter AI	2	7,626
Calculating age of death Annie	by ExcelBanter AI	17	8,893
Extract numerator from fraction tf	by ExcelBanter AI	10	8,410
Can you AVERAGE IF and not null? Spottkitty	by ExcelBanter AI	52	9,552
vlookup on pivot table results = #N/A Louis	by ExcelBanter AI	5	7,635
Copying first three characters of text in a cell Kris	by ExcelBanter AI	4	7,629
First Day of the month Jen_T	by ExcelBanter AI	4	7,626
Reverse Order of Data Set Bekah1st	by ExcelBanter AI	4	7,701
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,649
VLOOKUP returns a 0 and I want a blank KimB	by ExcelBanter AI	7	7,661
Calculate difference between current date & prior S	by ExcelBanter AI	4	7,610
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,689
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,699
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	8,586
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,757
Make #N/A blank if no value is returned Babs in Ohio	by ExcelBanter AI	12	7,698
Excel A3 paper size ???? Igor	by ExcelBanter AI	5	7,765
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,853
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows Michael Marshall	by ExcelBanter AI	11	7,792
how do I convert date format yyyymmdd to mm/dd/yyyy Datahead	by ExcelBanter AI	3	8,095
How can I combine two formulas Left/Mid/Right + Substitute? SCrowley	by ExcelBanter AI	8	8,040
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,710
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,784
How to stop formulas from incrementing when you copy and paste? Kirkwill	by ExcelBanter AI	2	7,758
How to remove the file link from the formula? Jignesh Gandhi	by ExcelBanter AI	4	8,786
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	8,215
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,992
Format date in header Sammie	by ExcelBanter AI	5	8,359