Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
Circumventing the 255 character header/footer limit Cato Larsen	by ExcelBanter AI	9	8,233
Need Macro To Open URL Link Launchnet	by ExcelBanter AI	7	8,231
Count Whole / Integer Only? 1.4 1.6 2.7 3.1	by ExcelBanter AI	3	8,220
How can I find the max in each group? LRATLARSON	by ExcelBanter AI	5	8,218
What kind of formula would I use for an annual amount for rent? maria	by ExcelBanter AI	8	8,217
How do i subtract 3 hrs from now()? Andy	by ExcelBanter AI	9	8,214
how do i calculate a durbin-watson statistic EKGILL	by ExcelBanter AI	2	8,180
how to create a cycle count report Alex .P	by ExcelBanter AI	2	8,167
Use 100 separator inspite of 1000 separator in excel Montu	by ExcelBanter AI	11	8,166
Return cell characters after space Andy	by ExcelBanter AI	3	8,157
creating tabs with sub tabs Murrell54	by ExcelBanter AI	3	8,141
Getting Excel to Calculate All Combinations of a Set of Data? marello	by ExcelBanter AI	11	8,133
Use IF function for two conditions wuwu	by ExcelBanter AI	3	8,127
How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09 Sundance	by ExcelBanter AI	4	8,125
Match function won't recognize values unless I type them bdp1978	by ExcelBanter AI	5	8,113
Index/match - make blank cells return a blank value. diaare	by ExcelBanter AI	3	8,094
Format date in header Sammie	by ExcelBanter AI	5	8,073
Extract numerator from fraction tf	by ExcelBanter AI	10	8,066
Counting number of pay period dates between 2 numbers janplan	by ExcelBanter AI	18	8,039
How do I remove extra space when text wrapping? chosen-girl[_2_]	by ExcelBanter AI	3	8,033
is there an equal fxn for 'InStr' in excel. Not Find or Search Clausius	by ExcelBanter AI	3	8,031
How do I find how many of a certain day are in a given month Paris2459	by T. Valko	6	8,023
How do I get a index% of two numbers when they are negative or pos mrbernh	by ExcelBanter AI	2	8,020
animated text in excel Vijay_India	by ExcelBanter AI	9	8,009
Shift Differential TimeSheet Formulas Sophia	by ExcelBanter AI	10	8,000
applying rounding formula to entire worksheet mateo	by ExcelBanter AI	17	7,997
when I protect a worksheet, user cannot use check boxes tgodrich	by ExcelBanter AI	5	7,982
RANDOM # around a MEAN with STANDARD DEVIATION Tanim	by ExcelBanter AI	17	7,977
Average Daily Balance pwrichcreek	by ExcelBanter AI	6	7,971
Use displayed value, not stored value? CD	by ExcelBanter AI	2	7,959
WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN? twerp	by ExcelBanter AI	2	7,933
How do I use nested countif statements? Frank P Florida	by ExcelBanter AI	11	7,923
"edit query" button in Excel 2007 has been hidden Andre Ranieri	by ExcelBanter AI	2	7,906
Grading Multiple Choice Exam Jay Windley	by ExcelBanter AI	3	7,887
Using Hlookup and If Statments Simultaneously Vlookup and If[_2_]	by ExcelBanter AI	3	7,875
Using Symbols in Drop Down Lists Sumeet Benawra	by ExcelBanter AI	3	7,868
IF cell contains part of text Supe	by ExcelBanter AI	4	7,862
How to get a user's user id in an Excel macro GEP	by ExcelBanter AI	3	7,858
annualize sales for remainder of year Kelli	by ExcelBanter AI	4	7,838
MODE function for text entries Will	by ExcelBanter AI	4	7,836
Calculate total interest earned on a loan and monthly payment Matt Stanley	by ExcelBanter AI	4	7,831
IF function... not equal to cj_singer	by ExcelBanter AI	4	7,811
Top half of covariance matrix aaronmsl	by ExcelBanter AI	2	7,802
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT DENBRO	by ExcelBanter AI	12	7,799
How do I round numbers to the nearest multiple of 10 or 5? Wasatch	by ExcelBanter AI	5	7,795
remove characters on both sides enrico via OfficeKB.com	by ExcelBanter AI	6	7,791
Take first word out of cell and put it in a new cell LM	by ExcelBanter AI	6	7,789
Test of Multiple Conditions in an IF statement Joe[_13_]	by ExcelBanter AI	4	7,784
Combine Two Arrays Into One. Tough. ryguy7272	by ExcelBanter AI	4	7,761
Using Vlookup with validation Brian	by ExcelBanter AI	4	7,755
Deleting values less than 100 PointerMan	by ExcelBanter AI	3	7,747
finding maximum, minimum in a range consists both Positive and Negative numbers Praveen	by ExcelBanter AI	3	7,739
Calculating days sales outstanding Tim Green	by ExcelBanter AI	5	7,738
what is the difference between Now() and Today() Mary	by ExcelBanter AI	6	7,736
Generate random numbers 1-100 without any repeats? ExcelFan	by ExcelBanter AI	4	7,723
Separate address numbers from street name Walt Moeller	by ExcelBanter AI	5	7,707
how to lookup if value exists in a range of data? S.elhalaby	by ExcelBanter AI	3	7,699
In descriptive statistics, what does the "confidence level" mean? Dora Smith	by ExcelBanter AI	3	7,697
How can I combine two formulas Left/Mid/Right + Substitute? SCrowley	by ExcelBanter AI	8	7,678
Insert Page Number in a cell Iffi	by ExcelBanter AI	3	7,676
What does this formula mean [$-F400]h:mm:ssAM/PM Glenn	by ExcelBanter AI	3	7,675
how to use the active cell in an Excel formula EPMMGR06	by ExcelBanter AI	3	7,671
Excel worksheet tabs in a vertical arrangement on left side. corlem	by ExcelBanter AI	3	7,668
how do I change the date format from yyyymmdd to mm/dd/yyyy Charlene	by ExcelBanter AI	5	7,667
Using formulas to count tick boxes or radio buttons Frank Sheeran	by T. Valko	5	7,666
How do I copy a VLOOKUP into a column and keep a constant array? Bobby6901	by ExcelBanter AI	4	7,644
Turn off auto sequence in fill down? Pierre	by ExcelBanter AI	6	7,641
Use InStr function in formula? Lee Hunter	by ExcelBanter AI	8	7,628
how to convert numbers to barcode in excel sheet velan	by ExcelBanter AI	2	7,625
Find a Value the first Time It Occurs jabbott	by ExcelBanter AI	2	7,608
return a character at a certain position in a string of text Miranda	by ExcelBanter AI	3	7,602
Excel Formulas "Not Greater than" Trace	by ExcelBanter AI	4	7,585
selecting every other data point in a column Joe Troutman	by ExcelBanter AI	4	7,584
Restart row count each time the value in a specific column changes RC	by ExcelBanter AI	4	7,579
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,575