Excel Worksheet Functions - Page 1176

Thread / Thread Starter	Last Post	Replies	Views
PEARSON versus CORREL Stan Brown	by ExcelBanter AI	3	7,237
modified following business day convention Don	by Ron Rosenfeld	1	7,239
IF/WHEN forumla fo when a cell is between two numbers philo351	by ExcelBanter AI	5	7,270
counting how many times a certain month appears MM	by ExcelBanter AI	5	7,271
Merging cells in a Protected Sheet Protect Sheet but be able to merge cells[_2_]	by Shane Devenshire[_2_]	3	7,274
if cell falls within range of number (i.e. 2500 to 4999) Susan	by ExcelBanter AI	3	7,282
How can I remove the header and footer on the excel 2007 sheet?. Tran	by ExcelBanter AI	2	7,291
Excel - stop automatically changing mixture of uppercase and lowercase to propercase Harry Flashman	by ExcelBanter AI	3	7,291
HELP! Need to divide all columns by same number to get sell price twoods403	by ExcelBanter AI	2	7,300
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,304
Why can't I use the MONTH function within the SUMIFS statement? djhunt77	by ExcelBanter AI	6	7,304
How to convert vertical blocked list to horizontal list? G Lykos	by ExcelBanter AI	8	7,354
Ranking by multiple Criteria Zaphod117	by ExcelBanter AI	3	7,365
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell	by ExcelBanter AI	3	7,379
Calculate difference between current date & prior S	by ExcelBanter AI	4	7,384
invalid reference for vlookup Ed Hoag	by ExcelBanter AI	2	7,390
Round a number to the Nearest .25 Dave E	by ExcelBanter AI	3	7,391
Copying first three characters of text in a cell Kris	by ExcelBanter AI	4	7,400
First Day of the month Jen_T	by ExcelBanter AI	4	7,400
Edit Links - cannot change source Code Numpty	by ExcelBanter AI	5	7,401
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,409
vlookup on pivot table results = #N/A Louis	by ExcelBanter AI	5	7,410
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,413
calculate the difference between negative and positive values watty	by ExcelBanter AI	7	7,415
Count if two columns match different criteria Curt D.	by ExcelBanter AI	5	7,419
Reverse Order of Data Set Bekah1st	by ExcelBanter AI	4	7,424
VLOOKUP returns a 0 and I want a blank KimB	by ExcelBanter AI	7	7,435
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,437
Make #N/A blank if no value is returned Babs in Ohio	by ExcelBanter AI	12	7,451
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,485
How to stop formulas from incrementing when you copy and paste? Kirkwill	by ExcelBanter AI	2	7,487
Excel: want neg numbers to show red/pos green via if-then formula Jim	by ExcelBanter AI	4	7,492
HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE? katie	by ExcelBanter AI	2	7,501
Returning value of active cell Sergio	by ExcelBanter AI	3	7,503
How to set up countdown timer to countdown days to a specific day Jenny	by ExcelBanter AI	3	7,511
Excel A3 paper size ???? Igor	by ExcelBanter AI	5	7,512
MID function from right to left nsv	by ExcelBanter AI	4	7,515
Calculating Average Length of Service EasyPeasy	by ExcelBanter AI	3	7,518
Editing text after concatenate Fozeye	by ExcelBanter AI	3	7,521
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,525
how to convert list of numbers to barcode font Convert numbers to barcode in spreadht	by ExcelBanter AI	2	7,526
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,529
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC	by ExcelBanter AI	2	7,540
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows Michael Marshall	by ExcelBanter AI	11	7,557
removing green triangle in cell Shooter	by ExcelBanter AI	4	7,566
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,570
how can I increase nested function 'IF' in EXCEL upto 10 levels pandurrr	by ExcelBanter AI	8	7,570
selecting every other data point in a column Joe Troutman	by ExcelBanter AI	4	7,588
Excel Formulas "Not Greater than" Trace	by ExcelBanter AI	4	7,597
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,607
Restart row count each time the value in a specific column changes RC	by ExcelBanter AI	4	7,611
return a character at a certain position in a string of text Miranda	by ExcelBanter AI	3	7,611
Find a Value the first Time It Occurs jabbott	by ExcelBanter AI	2	7,620
Excel file too big even when I delete all cells [email protected]	by ExcelBanter AI	14	7,644
How do I copy a VLOOKUP into a column and keep a constant array? Bobby6901	by ExcelBanter AI	4	7,657
how to convert numbers to barcode in excel sheet velan	by ExcelBanter AI	2	7,659
Turn off auto sequence in fill down? Pierre	by ExcelBanter AI	6	7,668
Use InStr function in formula? Lee Hunter	by ExcelBanter AI	8	7,677
Using formulas to count tick boxes or radio buttons Frank Sheeran	by T. Valko	5	7,690
What does this formula mean [$-F400]h:mm:ssAM/PM Glenn	by ExcelBanter AI	3	7,693
how do I change the date format from yyyymmdd to mm/dd/yyyy Charlene	by ExcelBanter AI	5	7,701
Excel worksheet tabs in a vertical arrangement on left side. corlem	by ExcelBanter AI	3	7,701
how to lookup if value exists in a range of data? S.elhalaby	by ExcelBanter AI	3	7,709
how to use the active cell in an Excel formula EPMMGR06	by ExcelBanter AI	3	7,713
How can I combine two formulas Left/Mid/Right + Substitute? SCrowley	by ExcelBanter AI	8	7,724
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,726
Separate address numbers from street name Walt Moeller	by ExcelBanter AI	5	7,729
Concatenate path and file string for external reference Michael[_4_]	by ExcelBanter AI	5	7,743
what is the difference between Now() and Today() Mary	by ExcelBanter AI	6	7,744
Generate random numbers 1-100 without any repeats? ExcelFan	by ExcelBanter AI	4	7,746
finding maximum, minimum in a range consists both Positive and Negative numbers Praveen	by ExcelBanter AI	3	7,752
Using Vlookup with validation Brian	by ExcelBanter AI	4	7,763
Calculating days sales outstanding Tim Green	by ExcelBanter AI	5	7,780
Combine Two Arrays Into One. Tough. ryguy7272	by ExcelBanter AI	4	7,798
remove characters on both sides enrico via OfficeKB.com	by ExcelBanter AI	6	7,805