Excel Worksheet Functions - Page 1182

Thread / Thread Starter	Last Post	Replies	Views
How do I round numbers to the nearest multiple of 10 or 5? Wasatch	by ExcelBanter AI	5	7,827
Filtering on upper/lowercase letters Chris Benton	by ExcelBanter AI	3	10,206
Calculate total interest earned on a loan and monthly payment Matt Stanley	by ExcelBanter AI	4	7,995
Test of Multiple Conditions in an IF statement Joe[_13_]	by ExcelBanter AI	4	7,816
Using Vlookup with validation Brian	by ExcelBanter AI	4	7,759
what is the difference between Now() and Today() Mary	by ExcelBanter AI	6	7,737
Maximum number of cells for 'SUM' ? Groybs	by ExcelBanter AI	8	8,265
MODE function for text entries Will	by ExcelBanter AI	4	7,842
finding maximum, minimum in a range consists both Positive and Negative numbers Praveen	by ExcelBanter AI	3	7,744
Using Hlookup and If Statments Simultaneously Vlookup and If[_2_]	by ExcelBanter AI	3	7,885
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT DENBRO	by ExcelBanter AI	12	7,804
annualize sales for remainder of year Kelli	by ExcelBanter AI	4	7,843
Replace Comma's with Dash [email protected]	by ExcelBanter AI	3	8,561
how to lookup if value exists in a range of data? S.elhalaby	by ExcelBanter AI	3	7,702
Generate random numbers 1-100 without any repeats? ExcelFan	by ExcelBanter AI	4	7,739
Percentage Variation - when values are zero LinLin	by ExcelBanter AI	8	8,425
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	8,343
Counting number of pay period dates between 2 numbers janplan	by ExcelBanter AI	18	8,043
Excel worksheet tabs in a vertical arrangement on left side. corlem	by ExcelBanter AI	3	7,697
Using Symbols in Drop Down Lists Sumeet Benawra	by ExcelBanter AI	3	8,101
underscore in functions westronwynde	by ExcelBanter AI	4	8,561
How do i increase the height of the worksheet tab in Excel? DailyExcelUser	by ExcelBanter AI	9	8,574
Query returned more data than will fit on a worksheet Carrie	by ExcelBanter AI	6	8,475
how do I change the date format from yyyymmdd to mm/dd/yyyy Charlene	by ExcelBanter AI	5	7,696
SUMPRODUCT Returning 0 or wrong totals Rbirdie	by ExcelBanter AI	12	8,584
how to convert numbers to barcode in excel sheet velan	by ExcelBanter AI	2	7,634
What kind of formula would I use for an annual amount for rent? maria	by ExcelBanter AI	8	8,226
removing green triangle in cell Shooter	by ExcelBanter AI	4	7,564
creating tabs with sub tabs Murrell54	by ExcelBanter AI	3	8,159
Separate address numbers from street name Walt Moeller	by ExcelBanter AI	5	7,717
selecting every other data point in a column Joe Troutman	by ExcelBanter AI	4	7,585
How do I copy a VLOOKUP into a column and keep a constant array? Bobby6901	by ExcelBanter AI	4	7,654
Use InStr function in formula? Lee Hunter	by ExcelBanter AI	8	7,662
Insert Page Number in a cell Iffi	by ExcelBanter AI	3	7,820
MID function from right to left nsv	by ExcelBanter AI	4	7,510
Combine Two Arrays Into One. Tough. ryguy7272	by ExcelBanter AI	4	7,770
return a character at a certain position in a string of text Miranda	by ExcelBanter AI	3	7,604
Excel Formulas "Not Greater than" Trace	by ExcelBanter AI	4	7,591
How to set up countdown timer to countdown days to a specific day Jenny	by ExcelBanter AI	3	7,508
HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE? katie	by ExcelBanter AI	2	7,492
What does this formula mean [$-F400]h:mm:ssAM/PM Glenn	by ExcelBanter AI	3	7,682
Shift Differential TimeSheet Formulas Sophia	by ExcelBanter AI	10	8,018
when I protect a worksheet, user cannot use check boxes tgodrich	by ExcelBanter AI	5	7,996
Turn off auto sequence in fill down? Pierre	by ExcelBanter AI	6	7,649
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC	by ExcelBanter AI	2	7,524
how can I increase nested function 'IF' in EXCEL upto 10 levels pandurrr	by ExcelBanter AI	8	7,564
remove characters on both sides enrico via OfficeKB.com	by ExcelBanter AI	6	7,799
Excel file too big even when I delete all cells [email protected]	by ExcelBanter AI	14	7,618
Returning value of active cell Sergio	by ExcelBanter AI	3	7,499
Calculating days sales outstanding Tim Green	by ExcelBanter AI	5	7,756
Format date in header Sammie	by ExcelBanter AI	5	8,085
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,708
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	7,916
How to remove the file link from the formula? Jignesh Gandhi	by ExcelBanter AI	4	8,436
How to stop formulas from incrementing when you copy and paste? Kirkwill	by ExcelBanter AI	2	7,479
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,504
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,477
How can I combine two formulas Left/Mid/Right + Substitute? SCrowley	by ExcelBanter AI	8	7,711
how do I convert date format yyyymmdd to mm/dd/yyyy Datahead	by ExcelBanter AI	3	7,759
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows Michael Marshall	by ExcelBanter AI	11	7,539
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,563
Excel A3 paper size ???? Igor	by ExcelBanter AI	5	7,504
Make #N/A blank if no value is returned Babs in Ohio	by ExcelBanter AI	12	7,438
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,494
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	8,226
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,428
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,408
Calculate difference between current date & prior S	by ExcelBanter AI	4	7,379
VLOOKUP returns a 0 and I want a blank KimB	by ExcelBanter AI	7	7,425
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,404
Reverse Order of Data Set Bekah1st	by ExcelBanter AI	4	7,415
First Day of the month Jen_T	by ExcelBanter AI	4	7,396
Copying first three characters of text in a cell Kris	by ExcelBanter AI	4	7,376
vlookup on pivot table results = #N/A Louis	by ExcelBanter AI	5	7,406
Can you AVERAGE IF and not null? ( 1 2) Spottkitty	by ExcelBanter AI	52	8,563