Excel Worksheet Functions - Page 1177

Thread / Thread Starter	Last Post	Replies	Views
Deleting values less than 100 PointerMan	by ExcelBanter AI	3	7,809
how do I convert date format yyyymmdd to mm/dd/yyyy Datahead	by ExcelBanter AI	3	7,812
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT DENBRO	by ExcelBanter AI	12	7,817
Top half of covariance matrix aaronmsl	by ExcelBanter AI	2	7,819
IF function... not equal to cj_singer	by ExcelBanter AI	4	7,821
Test of Multiple Conditions in an IF statement Joe[_13_]	by ExcelBanter AI	4	7,830
How do I round numbers to the nearest multiple of 10 or 5? Wasatch	by ExcelBanter AI	5	7,831
Insert Page Number in a cell Iffi	by ExcelBanter AI	3	7,843
MODE function for text entries Will	by ExcelBanter AI	4	7,848
annualize sales for remainder of year Kelli	by ExcelBanter AI	4	7,852
How to get a user's user id in an Excel macro GEP	by ExcelBanter AI	3	7,869
IF cell contains part of text Supe	by ExcelBanter AI	4	7,872
"edit query" button in Excel 2007 has been hidden Andre Ranieri	by ExcelBanter AI	2	7,910
Using Hlookup and If Statments Simultaneously Vlookup and If[_2_]	by ExcelBanter AI	3	7,914
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	7,933
WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN? twerp	by ExcelBanter AI	2	7,951
Take first word out of cell and put it in a new cell LM	by ExcelBanter AI	6	7,973
Use displayed value, not stored value? CD	by ExcelBanter AI	2	7,974
Average Daily Balance pwrichcreek	by ExcelBanter AI	6	7,984
RANDOM # around a MEAN with STANDARD DEVIATION Tanim	by ExcelBanter AI	17	7,985
Calculate total interest earned on a loan and monthly payment Matt Stanley	by ExcelBanter AI	4	8,004
when I protect a worksheet, user cannot use check boxes tgodrich	by ExcelBanter AI	5	8,024
Shift Differential TimeSheet Formulas Sophia	by ExcelBanter AI	10	8,028
animated text in excel Vijay_India	by ExcelBanter AI	9	8,043
applying rounding formula to entire worksheet mateo	by ExcelBanter AI	17	8,046
Counting number of pay period dates between 2 numbers janplan	by ExcelBanter AI	18	8,048
How do I find how many of a certain day are in a given month Paris2459	by T. Valko	6	8,076
How do I get a index% of two numbers when they are negative or pos mrbernh	by ExcelBanter AI	2	8,094
Format date in header Sammie	by ExcelBanter AI	5	8,098
Index/match - make blank cells return a blank value. diaare	by ExcelBanter AI	3	8,106
Using Symbols in Drop Down Lists Sumeet Benawra	by ExcelBanter AI	3	8,118
Match function won't recognize values unless I type them bdp1978	by ExcelBanter AI	5	8,123
Extract numerator from fraction tf	by ExcelBanter AI	10	8,125
Use IF function for two conditions wuwu	by ExcelBanter AI	3	8,138
How do I use nested countif statements? Frank P Florida	by ExcelBanter AI	11	8,140
How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09 Sundance	by ExcelBanter AI	4	8,166
creating tabs with sub tabs Murrell54	by ExcelBanter AI	3	8,174
how to create a cycle count report Alex .P	by ExcelBanter AI	2	8,182
Return cell characters after space Andy	by ExcelBanter AI	3	8,194
Use 100 separator inspite of 1000 separator in excel Montu	by ExcelBanter AI	11	8,209
how do i calculate a durbin-watson statistic EKGILL	by ExcelBanter AI	2	8,214
is there an equal fxn for 'InStr' in excel. Not Find or Search Clausius	by ExcelBanter AI	3	8,218
How do i subtract 3 hrs from now()? Andy	by ExcelBanter AI	9	8,222
Count Whole / Integer Only? 1.4 1.6 2.7 3.1	by ExcelBanter AI	3	8,238
What kind of formula would I use for an annual amount for rent? maria	by ExcelBanter AI	8	8,238
Need Macro To Open URL Link Launchnet	by ExcelBanter AI	7	8,240
How can I find the max in each group? LRATLARSON	by ExcelBanter AI	5	8,241
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	8,260
Circumventing the 255 character header/footer limit Cato Larsen	by ExcelBanter AI	9	8,266
how to divide the number in one cell into multiple cells Ramya[_2_]	by ExcelBanter AI	3	8,277
Maximum number of cells for 'SUM' ? Groybs	by ExcelBanter AI	8	8,293
Sumproduct to SumDivide ????????? Dale	by ExcelBanter AI	6	8,315
SubTotal function to return number of rows returns only zero DZ	by ExcelBanter AI	6	8,332
Count If Column A = x and Column B = y Trish	by ExcelBanter AI	23	8,357
Extracting characters before or after a specific character Brian	by ExcelBanter AI	4	8,358
Simplify formula using quarterly investment returns TAB	by ExcelBanter AI	7	8,358
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	8,362
Formatting for 15th and last day of the month Emilio Guerra	by ExcelBanter AI	2	8,421
How do I insert a dropdown calendar into a cell? Jeff Kass, San Diego, CA	by ExcelBanter AI	8	8,433
Getting Excel to Calculate All Combinations of a Set of Data? marello	by ExcelBanter AI	11	8,440
Percentage Variation - when values are zero LinLin	by ExcelBanter AI	8	8,443
Forget SUMIF, COUNTIF and VLOOKUP Pierre Leclerc	by ExcelBanter AI	16	8,451
Divide 2 pivot table numbers DANM	by ExcelBanter AI	4	8,452
How to count number of sheets booshi	by ExcelBanter AI	3	8,453
how to remove #n/a error in excel vlookup b/c value is not found? B. Franklin Saunders	by ExcelBanter AI	20	8,454
How to remove the file link from the formula? Jignesh Gandhi	by ExcelBanter AI	4	8,461
change default table style Syl	by ExcelBanter AI	2	8,473
Query returned more data than will fit on a worksheet Carrie	by ExcelBanter AI	6	8,492
Difference between two date/time values Raj[_2_]	by ExcelBanter AI	7	8,494
Criteria length limit in SUMIF() BAC	by ExcelBanter AI	16	8,509
Conditional Formatting if cell is Blank Judi	by ExcelBanter AI	3	8,517
Sum Cell Values of one column based on Another Cell Value in a different column kristenb via OfficeKB.com	by ExcelBanter AI	5	8,520
What is the formula for compounding interest with annual additions charrismd	by ExcelBanter AI	2	8,538
How do I make mouse scroll wheel work in excel Rae	by ExcelBanter AI	8	8,539
NPV vs XNPV Energy	by ExcelBanter AI	7	8,543