Excel Worksheet Functions - Page 2

Thread / Thread Starter	Last Post	Replies	Views
Calculating days sales outstanding Tim Green	by ExcelBanter AI	5	7,743
Returning value of active cell Sergio	by ExcelBanter AI	3	7,496
Excel file too big even when I delete all cells [email protected]	by ExcelBanter AI	14	7,601
remove characters on both sides enrico via OfficeKB.com	by ExcelBanter AI	6	7,792
how can I increase nested function 'IF' in EXCEL upto 10 levels pandurrr	by ExcelBanter AI	8	7,561
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC	by ExcelBanter AI	2	7,508
Turn off auto sequence in fill down? Pierre	by ExcelBanter AI	6	7,644
when I protect a worksheet, user cannot use check boxes tgodrich	by ExcelBanter AI	5	7,988
Shift Differential TimeSheet Formulas Sophia	by ExcelBanter AI	10	8,010
What does this formula mean [$-F400]h:mm:ssAM/PM Glenn	by ExcelBanter AI	3	7,677
HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE? katie	by ExcelBanter AI	2	7,491
How to set up countdown timer to countdown days to a specific day Jenny	by ExcelBanter AI	3	7,507
Excel Formulas "Not Greater than" Trace	by ExcelBanter AI	4	7,589
return a character at a certain position in a string of text Miranda	by ExcelBanter AI	3	7,602
Combine Two Arrays Into One. Tough. ryguy7272	by ExcelBanter AI	4	7,765
MID function from right to left nsv	by ExcelBanter AI	4	7,499
Insert Page Number in a cell Iffi	by ExcelBanter AI	3	7,784
Use InStr function in formula? Lee Hunter	by ExcelBanter AI	8	7,643
How do I copy a VLOOKUP into a column and keep a constant array? Bobby6901	by ExcelBanter AI	4	7,650
selecting every other data point in a column Joe Troutman	by ExcelBanter AI	4	7,585
Separate address numbers from street name Walt Moeller	by ExcelBanter AI	5	7,712
creating tabs with sub tabs Murrell54	by ExcelBanter AI	3	8,145
removing green triangle in cell Shooter	by ExcelBanter AI	4	7,559
What kind of formula would I use for an annual amount for rent? maria	by ExcelBanter AI	8	8,218
how to convert numbers to barcode in excel sheet velan	by ExcelBanter AI	2	7,626
SUMPRODUCT Returning 0 or wrong totals Rbirdie	by ExcelBanter AI	12	8,551
how do I change the date format from yyyymmdd to mm/dd/yyyy Charlene	by ExcelBanter AI	5	7,690
Query returned more data than will fit on a worksheet Carrie	by ExcelBanter AI	6	8,467
How do i increase the height of the worksheet tab in Excel? DailyExcelUser	by ExcelBanter AI	9	8,547
underscore in functions westronwynde	by ExcelBanter AI	4	8,498
Using Symbols in Drop Down Lists Sumeet Benawra	by ExcelBanter AI	3	8,045
Excel worksheet tabs in a vertical arrangement on left side. corlem	by ExcelBanter AI	3	7,687
Counting number of pay period dates between 2 numbers janplan	by ExcelBanter AI	18	8,041
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	8,327
Percentage Variation - when values are zero LinLin	by ExcelBanter AI	8	8,422
Generate random numbers 1-100 without any repeats? ExcelFan	by ExcelBanter AI	4	7,733
how to lookup if value exists in a range of data? S.elhalaby	by ExcelBanter AI	3	7,701
Replace Comma's with Dash [email protected]	by ExcelBanter AI	3	8,545
annualize sales for remainder of year Kelli	by ExcelBanter AI	4	7,842
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT DENBRO	by ExcelBanter AI	12	7,802
Using Hlookup and If Statments Simultaneously Vlookup and If[_2_]	by ExcelBanter AI	3	7,876
finding maximum, minimum in a range consists both Positive and Negative numbers Praveen	by ExcelBanter AI	3	7,740
MODE function for text entries Will	by ExcelBanter AI	4	7,839
Maximum number of cells for 'SUM' ? Groybs	by ExcelBanter AI	8	8,249
what is the difference between Now() and Today() Mary	by ExcelBanter AI	6	7,736
Using Vlookup with validation Brian	by ExcelBanter AI	4	7,759
Test of Multiple Conditions in an IF statement Joe[_13_]	by ExcelBanter AI	4	7,802
Calculate total interest earned on a loan and monthly payment Matt Stanley	by ExcelBanter AI	4	7,947
Filtering on upper/lowercase letters Chris Benton	by ExcelBanter AI	3	10,187
How do I round numbers to the nearest multiple of 10 or 5? Wasatch	by ExcelBanter AI	5	7,816
How do I use nested countif statements? Frank P Florida	by ExcelBanter AI	11	8,064
SubTotal function to return number of rows returns only zero DZ	by ExcelBanter AI	6	8,305
IF function... not equal to cj_singer	by ExcelBanter AI	4	7,815
how to create a cycle count report Alex .P	by ExcelBanter AI	2	8,168
Simplify formula using quarterly investment returns TAB	by ExcelBanter AI	7	8,341
Use displayed value, not stored value? CD	by ExcelBanter AI	2	7,962
Index/match - make blank cells return a blank value. diaare	by ExcelBanter AI	3	8,098
IF cell contains part of text Supe	by ExcelBanter AI	4	7,869
Average Daily Balance pwrichcreek	by ExcelBanter AI	6	7,972
WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN? twerp	by ExcelBanter AI	2	7,937
How to get a user's user id in an Excel macro GEP	by ExcelBanter AI	3	7,862
PDIFF , DDIFF Steven	by ExcelBanter AI	2	9,206
Use 100 separator inspite of 1000 separator in excel Montu	by ExcelBanter AI	11	8,179
Deriving P-Value through LINEST Function RJ	by ExcelBanter AI	2	9,988
Subtotal Levels not showing in Excel [email protected]	by ExcelBanter AI	3	9,023
"edit query" button in Excel 2007 has been hidden Andre Ranieri	by ExcelBanter AI	2	7,908
Count Whole / Integer Only? 1.4 1.6 2.7 3.1	by ExcelBanter AI	3	8,222
Divide 2 pivot table numbers DANM	by ExcelBanter AI	4	8,392
RANDOM # around a MEAN with STANDARD DEVIATION Tanim	by ExcelBanter AI	17	7,977
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches ( 1 2) [email protected]	by ExcelBanter AI	66	9,103
Count If Column A = x and Column B = y Trish	by ExcelBanter AI	23	8,330
Getting Excel to Calculate All Combinations of a Set of Data? marello	by ExcelBanter AI	11	8,307
is there an equal fxn for 'InStr' in excel. Not Find or Search Clausius	by ExcelBanter AI	3	8,151
forecast using a four parameter logistic equation Laura	by ExcelBanter AI	6	8,787
Match function won't recognize values unless I type them bdp1978	by ExcelBanter AI	5	8,116