Excel Worksheet Functions - Page 1181

Thread / Thread Starter	Last Post	Replies	Views
Use a formula in custom autofilter andy62	by ExcelBanter AI	6	9,229
Create Acronym (Extract first letter of each word) VB_Sam	by ExcelBanter AI	20	8,757
Convert ADDRESS() text result to cell reference FirstVette52	by ExcelBanter AI	5	8,792
Median calculation of grouped data. Bruce	by ExcelBanter AI	19	8,729
Wrong results from MATCH function Imladrian	by ExcelBanter AI	4	8,601
How do I calculate Return on Investment in Excel Jay_very_cool	by ExcelBanter AI	4	8,658
=TRIM and =PROPER in a nested statement? MarvInBoise	by ExcelBanter AI	3	8,904
Using the LEFT formula for multiple cells Emily G	by ExcelBanter AI	3	9,506
How to count number of sheets booshi	by ExcelBanter AI	3	8,452
Add months and adding partial monhts Adam C	by ExcelBanter AI	3	9,361
What is the formula for compounding interest with annual additions charrismd	by ExcelBanter AI	2	8,538
Conditional Formatting if cell is Blank Judi	by ExcelBanter AI	3	8,517
is there a formula that will subtract todays date from a hire date Heather	by ExcelBanter AI	5	8,848
Count no of nights between dates Morten	by ExcelBanter AI	5	11,380
How do I create a hyperlink for individual FedEx tracking numbers. robinrobin	by ExcelBanter AI	3	10,431
check if an entry is a multiple of another cell JMM[_2_]	by ExcelBanter AI	5	8,968
Difference between two date/time values Raj[_2_]	by ExcelBanter AI	7	8,494
I have a text box and cannot use the Enter key to seperate lines Geechee	by ExcelBanter AI	7	9,032
NPV vs XNPV Energy	by ExcelBanter AI	7	8,543
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
Week ending Thursday formula Laurence Lombard	by ExcelBanter AI	5	8,886
Set Cell format using VB.NET Hugh	by ExcelBanter AI	12	9,064
how do i square matrices? sparkskey	by ExcelBanter AI	4	8,982
how to remove #n/a error in excel vlookup b/c value is not found? B. Franklin Saunders	by ExcelBanter AI	20	8,453
how to find the right most cell in a row with a value in it ? Max	by ExcelBanter AI	5	10,460
How do I insert a dropdown calendar into a cell? Jeff Kass, San Diego, CA	by ExcelBanter AI	8	8,429
Forget SUMIF, COUNTIF and VLOOKUP Pierre Leclerc	by ExcelBanter AI	16	8,450
Extracting characters before or after a specific character Brian	by ExcelBanter AI	4	8,357
ROUNDUP vs CEILING Rebecca_SUNY	by ExcelBanter AI	7	9,421
Formula for the first working day of the year Ron@Buy	by ExcelBanter AI	13	9,599
Renaming an excel file that is Linked. dls25	by ExcelBanter AI	6	10,096
change default table style Syl	by ExcelBanter AI	2	8,473
how to divide the number in one cell into multiple cells Ramya[_2_]	by ExcelBanter AI	3	8,277
Combine SUMIF and SUMPRODUCT Tevuna	by ExcelBanter AI	10	10,373
Need Macro To Open URL Link Launchnet	by ExcelBanter AI	7	8,240
Criteria length limit in SUMIF() BAC	by ExcelBanter AI	16	8,509
Calc sometimes off by a penny Access Joe	by ExcelBanter AI	6	9,417
Use IF function for two conditions wuwu	by ExcelBanter AI	3	8,138
How can I find the max in each group? LRATLARSON	by ExcelBanter AI	5	8,240
How do i subtract 3 hrs from now()? Andy	by ExcelBanter AI	9	8,222
Formatting for 15th and last day of the month Emilio Guerra	by ExcelBanter AI	2	8,419
How do I make mouse scroll wheel work in excel Rae	by ExcelBanter AI	8	8,537
how do i calculate a durbin-watson statistic EKGILL	by ExcelBanter AI	2	8,214
How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09 Sundance	by ExcelBanter AI	4	8,165
I want the PMT function to calculate using 360 days not 365 amalecki	by ExcelBanter AI	6	9,665
Display "/" (slash) as a character, not as an action (divide) bobdenver	by ExcelBanter AI	6	9,296
Return cell characters after space Andy	by ExcelBanter AI	3	8,194
Sumproduct to SumDivide ????????? Dale	by ExcelBanter AI	6	8,314
Dragging across columns: I want column constant, but row increment CM	by ExcelBanter AI	7	8,745
Minimum Date Greater than Today() VickiMc	by ExcelBanter AI	7	8,832
Match function won't recognize values unless I type them bdp1978	by ExcelBanter AI	5	8,123
forecast using a four parameter logistic equation Laura	by ExcelBanter AI	6	8,808
is there an equal fxn for 'InStr' in excel. Not Find or Search Clausius	by ExcelBanter AI	3	8,218
Getting Excel to Calculate All Combinations of a Set of Data? marello	by ExcelBanter AI	11	8,437
Count If Column A = x and Column B = y Trish	by ExcelBanter AI	23	8,357
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches [email protected]	by ExcelBanter AI	66	9,212
RANDOM # around a MEAN with STANDARD DEVIATION Tanim	by ExcelBanter AI	17	7,985
Divide 2 pivot table numbers DANM	by ExcelBanter AI	4	8,448
Count Whole / Integer Only? 1.4 1.6 2.7 3.1	by ExcelBanter AI	3	8,232
"edit query" button in Excel 2007 has been hidden Andre Ranieri	by ExcelBanter AI	2	7,910
Subtotal Levels not showing in Excel [email protected]	by ExcelBanter AI	3	9,054
Deriving P-Value through LINEST Function RJ	by ExcelBanter AI	2	10,094
Use 100 separator inspite of 1000 separator in excel Montu	by ExcelBanter AI	11	8,207
PDIFF , DDIFF Steven	by ExcelBanter AI	2	9,268
How to get a user's user id in an Excel macro GEP	by ExcelBanter AI	3	7,869
WHAT DOES 'DATA SOURCE REFERENCE NOT VALID' MEAN? twerp	by ExcelBanter AI	2	7,951
Average Daily Balance pwrichcreek	by ExcelBanter AI	6	7,983
IF cell contains part of text Supe	by ExcelBanter AI	4	7,872
Index/match - make blank cells return a blank value. diaare	by ExcelBanter AI	3	8,106
Use displayed value, not stored value? CD	by ExcelBanter AI	2	7,974
Simplify formula using quarterly investment returns TAB	by ExcelBanter AI	7	8,355
how to create a cycle count report Alex .P	by ExcelBanter AI	2	8,181
IF function... not equal to cj_singer	by ExcelBanter AI	4	7,821
SubTotal function to return number of rows returns only zero DZ	by ExcelBanter AI	6	8,332
How do I use nested countif statements? Frank P Florida	by ExcelBanter AI	11	8,140