Excel Worksheet Functions - Page 2

Thread / Thread Starter	Last Post	Replies	Views
How do I get a index% of two numbers when they are negative or pos mrbernh	by ExcelBanter AI	2	7,631
PEARSON versus CORREL Stan Brown	by ExcelBanter AI	3	7,117
autocomplete in dropdown list in Excel as I begin typing Jason W	by ExcelBanter AI	3	7,120
Top half of covariance matrix aaronmsl	by ExcelBanter AI	2	7,476
Find a Value the first Time It Occurs jabbott	by ExcelBanter AI	2	7,352
IF/WHEN forumla fo when a cell is between two numbers philo351	by ExcelBanter AI	5	7,136
Excel - stop automatically changing mixture of uppercase and lowercase to propercase Harry Flashman	by ExcelBanter AI	3	7,172
How can I remove the header and footer on the excel 2007 sheet?. Tran	by ExcelBanter AI	2	7,168
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL silverflyer	by ExcelBanter AI	5	8,227
How to convert vertical blocked list to horizontal list? G Lykos	by ExcelBanter AI	8	7,193
Calculating Average Length of Service EasyPeasy	by ExcelBanter AI	3	7,174
Deleting values less than 100 PointerMan	by ExcelBanter AI	3	7,432
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,166
Restart row count each time the value in a specific column changes RC	by ExcelBanter AI	4	7,366
Formula for average recorded blood pressure readings in 1 column . hjvn1302	by ExcelBanter AI	6	8,099
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,398
Ranking by multiple Criteria Zaphod117	by ExcelBanter AI	3	7,233
Excel: want neg numbers to show red/pos green via if-then formula Jim	by ExcelBanter AI	4	7,182
HELP! Need to divide all columns by same number to get sell price twoods403	by ExcelBanter AI	2	7,169
how to use the active cell in an Excel formula EPMMGR06	by ExcelBanter AI	3	7,373
applying rounding formula to entire worksheet mateo	by ExcelBanter AI	17	7,712
Highlight date nearest to TODAY() Colin Hayes	by ExcelBanter AI	7	8,006
Round a number to the Nearest .25 Dave E	by ExcelBanter AI	3	7,233
how to convert list of numbers to barcode font Convert numbers to barcode in spreadht	by ExcelBanter AI	2	7,214
Adding periods (full stops) to the middle of numbers Derek M[_2_]	by ExcelBanter AI	7	7,899
Circumventing the 255 character header/footer limit Cato Larsen	by ExcelBanter AI	9	7,821
Count if two columns match different criteria Curt D.	by ExcelBanter AI	5	7,280
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell	by ExcelBanter AI	3	7,274
animated text in excel Vijay_India	by ExcelBanter AI	9	7,733
invalid reference for vlookup Ed Hoag	by ExcelBanter AI	2	7,256
Calculating age of death Annie	by ExcelBanter AI	17	7,920
Extract numerator from fraction tf	by ExcelBanter AI	10	7,693
Can you AVERAGE IF and not null? ( 1 2) Spottkitty	by ExcelBanter AI	52	7,885
vlookup on pivot table results = #N/A Louis	by ExcelBanter AI	5	7,265
Copying first three characters of text in a cell Kris	by ExcelBanter AI	4	7,269
First Day of the month Jen_T	by ExcelBanter AI	4	7,330
Reverse Order of Data Set Bekah1st	by ExcelBanter AI	4	7,313
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,337
VLOOKUP returns a 0 and I want a blank KimB	by ExcelBanter AI	7	7,316
Calculate difference between current date & prior S	by ExcelBanter AI	4	7,309
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,327
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,313
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	7,764
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,307
Make #N/A blank if no value is returned Babs in Ohio	by ExcelBanter AI	12	7,362
Excel A3 paper size ???? Igor	by ExcelBanter AI	5	7,392
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,419
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows Michael Marshall	by ExcelBanter AI	11	7,370
how do I convert date format yyyymmdd to mm/dd/yyyy Datahead	by ExcelBanter AI	3	7,453
How can I combine two formulas Left/Mid/Right + Substitute? SCrowley	by ExcelBanter AI	8	7,543
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,390
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,408
How to stop formulas from incrementing when you copy and paste? Kirkwill	by ExcelBanter AI	2	7,392
How to remove the file link from the formula? Jignesh Gandhi	by ExcelBanter AI	4	8,037
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	7,692
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,568
Format date in header Sammie	by ExcelBanter AI	5	7,759
Calculating days sales outstanding Tim Green	by ExcelBanter AI	5	7,602
Returning value of active cell Sergio	by ExcelBanter AI	3	7,430
Excel file too big even when I delete all cells [email protected]	by ExcelBanter AI	14	7,483
remove characters on both sides enrico via OfficeKB.com	by ExcelBanter AI	6	7,687
how can I increase nested function 'IF' in EXCEL upto 10 levels pandurrr	by ExcelBanter AI	8	7,478
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC	by ExcelBanter AI	2	7,378
Turn off auto sequence in fill down? Pierre	by ExcelBanter AI	6	7,535
when I protect a worksheet, user cannot use check boxes tgodrich	by ExcelBanter AI	5	7,792
Shift Differential TimeSheet Formulas Sophia	by ExcelBanter AI	10	7,699
What does this formula mean [$-F400]h:mm:ssAM/PM Glenn	by ExcelBanter AI	3	7,592
HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE? katie	by ExcelBanter AI	2	7,438
How to set up countdown timer to countdown days to a specific day Jenny	by ExcelBanter AI	3	7,429
Excel Formulas "Not Greater than" Trace	by ExcelBanter AI	4	7,525
return a character at a certain position in a string of text Miranda	by ExcelBanter AI	3	7,514
Combine Two Arrays Into One. Tough. ryguy7272	by ExcelBanter AI	4	7,649
MID function from right to left nsv	by ExcelBanter AI	4	7,427
Insert Page Number in a cell Iffi	by ExcelBanter AI	3	7,565
Use InStr function in formula? Lee Hunter	by ExcelBanter AI	8	7,569