Excel Worksheet Functions - Page 3

Thread / Thread Starter	Last Post	Replies	Views
creating tabs with sub tabs Murrell54	by ExcelBanter AI	3	7,938
removing green triangle in cell Shooter	by ExcelBanter AI	4	7,508
What kind of formula would I use for an annual amount for rent? maria	by ExcelBanter AI	8	7,989
how to convert numbers to barcode in excel sheet velan	by ExcelBanter AI	2	7,555
SUMPRODUCT Returning 0 or wrong totals Rbirdie	by ExcelBanter AI	12	8,243
how do I change the date format from yyyymmdd to mm/dd/yyyy Charlene	by ExcelBanter AI	5	7,590
Query returned more data than will fit on a worksheet Carrie	by ExcelBanter AI	6	7,956
How do i increase the height of the worksheet tab in Excel? DailyExcelUser	by ExcelBanter AI	9	8,207
underscore in functions westronwynde	by ExcelBanter AI	4	8,053
Using Symbols in Drop Down Lists Sumeet Benawra	by ExcelBanter AI	3	7,663
Excel worksheet tabs in a vertical arrangement on left side. corlem	by ExcelBanter AI	3	7,607
Counting number of pay period dates between 2 numbers janplan	by ExcelBanter AI	18	7,914
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	7,986
Percentage Variation - when values are zero LinLin	by ExcelBanter AI	8	8,148
Generate random numbers 1-100 without any repeats? ExcelFan	by ExcelBanter AI	4	7,662
how to lookup if value exists in a range of data? S.elhalaby	by ExcelBanter AI	3	7,621
Replace Comma's with Dash [email protected]	by ExcelBanter AI	3	8,213
annualize sales for remainder of year Kelli	by ExcelBanter AI	4	7,743
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT DENBRO	by ExcelBanter AI	12	7,746
Using Hlookup and If Statments Simultaneously Vlookup and If[_2_]	by ExcelBanter AI	3	7,805
finding maximum, minimum in a range consists both Positive and Negative numbers Praveen	by ExcelBanter AI	3	7,672
MODE function for text entries Will	by ExcelBanter AI	4	7,746
Maximum number of cells for 'SUM' ? Groybs	by ExcelBanter AI	8	7,993
what is the difference between Now() and Today() Mary	by ExcelBanter AI	6	7,664
Using Vlookup with validation Brian	by ExcelBanter AI	4	7,694
Test of Multiple Conditions in an IF statement Joe[_13_]	by ExcelBanter AI	4	7,726
Calculate total interest earned on a loan and monthly payment Matt Stanley	by ExcelBanter AI	4	7,726
Filtering on upper/lowercase letters Chris Benton	by ExcelBanter AI	3	8,854
How do I round numbers to the nearest multiple of 10 or 5? Wasatch	by ExcelBanter AI	5	7,751
How do I use nested countif statements? Frank P Florida	by ExcelBanter AI	11	7,800
SubTotal function to return number of rows returns only zero DZ	by ExcelBanter AI	6	8,115
IF function... not equal to cj_singer	by ExcelBanter AI	4	7,753
how to create a cycle count report Alex .P	by ExcelBanter AI	2	7,987
Simplify formula using quarterly investment returns TAB	by ExcelBanter AI	7	8,104
Use displayed value, not stored value? CD	by ExcelBanter AI	2	7,871
Index/match - make blank cells return a blank value. diaare	by ExcelBanter AI	3	7,938
IF cell contains part of text Supe	by ExcelBanter AI	4	7,808
Average Daily Balance pwrichcreek	by ExcelBanter AI	6	7,920
WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN? twerp	by ExcelBanter AI	2	7,847
How to get a user's user id in an Excel macro GEP	by ExcelBanter AI	3	7,783
PDIFF , DDIFF Steven	by ExcelBanter AI	2	8,568
Use 100 separator inspite of 1000 separator in excel Montu	by ExcelBanter AI	11	7,966
Deriving P-Value through LINEST Function RJ	by ExcelBanter AI	2	8,996
Subtotal Levels not showing in Excel [email protected]	by ExcelBanter AI	3	8,404
"edit query" button in Excel 2007 has been hidden Andre Ranieri	by ExcelBanter AI	2	7,872
Count Whole / Integer Only? 1.4 1.6 2.7 3.1	by ExcelBanter AI	3	8,082
Divide 2 pivot table numbers DANM	by ExcelBanter AI	4	8,212
RANDOM # around a MEAN with STANDARD DEVIATION Tanim	by ExcelBanter AI	17	7,939
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	8,504
Count If Column A = x and Column B = y Trish	by ExcelBanter AI	23	8,167
Getting Excel to Calculate All Combinations of a Set of Data? marello	by ExcelBanter AI	11	8,013
is there an equal fxn for 'InStr' in excel. Not Find or Search Clausius	by ExcelBanter AI	3	7,908
forecast using a four parameter logistic equation Laura	by ExcelBanter AI	6	8,523
Match function won't recognize values unless I type them bdp1978	by ExcelBanter AI	5	8,056
Minimum Date Greater than Today() VickiMc	by ExcelBanter AI	7	8,517
Dragging across columns: I want column constant, but row increment CM	by ExcelBanter AI	7	8,436
Sumproduct to SumDivide ????????? Dale	by ExcelBanter AI	6	8,136
Return cell characters after space Andy	by ExcelBanter AI	3	8,084
Display "/" (slash) as a character, not as an action (divide) bobdenver	by ExcelBanter AI	6	8,708
I want the PMT function to calculate using 360 days not 365 amalecki	by ExcelBanter AI	6	8,929
How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09 Sundance	by ExcelBanter AI	4	8,054
how do i calculate a durbin-watson statistic EKGILL	by ExcelBanter AI	2	8,102
How do I make mouse scroll wheel work in excel Rae	by ExcelBanter AI	8	8,224
Formatting for 15th and last day of the month Emilio Guerra	by ExcelBanter AI	2	8,270
How do i subtract 3 hrs from now()? Andy	by ExcelBanter AI	9	8,171
How can I find the max in each group? LRATLARSON	by ExcelBanter AI	5	8,146
Use IF function for two conditions wuwu	by ExcelBanter AI	3	8,050
Calc sometimes off by a penny Access Joe	by ExcelBanter AI	6	8,945
Criteria length limit in SUMIF() BAC	by ExcelBanter AI	16	8,375
Need Macro To Open URL Link Launchnet	by ExcelBanter AI	7	8,140
Combine SUMIF and SUMPRODUCT Tevuna	by ExcelBanter AI	10	9,326
how to divide the number in one cell into multiple cells Ramya[_2_]	by ExcelBanter AI	3	8,224
change default table style Syl	by ExcelBanter AI	2	8,361
Renaming an excel file that is Linked. dls25	by ExcelBanter AI	6	9,369
Formula for the first working day of the year Ron@Buy	by ExcelBanter AI	13	8,931