Excel Worksheet Functions - Page 3

Thread / Thread Starter	Last Post	Replies	Views
Minimum Date Greater than Today() VickiMc	by ExcelBanter AI	7	8,798
Dragging across columns: I want column constant, but row increment CM	by ExcelBanter AI	7	8,700
Sumproduct to SumDivide ????????? Dale	by ExcelBanter AI	6	8,294
Return cell characters after space Andy	by ExcelBanter AI	3	8,162
Display "/" (slash) as a character, not as an action (divide) bobdenver	by ExcelBanter AI	6	9,184
I want the PMT function to calculate using 360 days not 365 amalecki	by ExcelBanter AI	6	9,504
How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09 Sundance	by ExcelBanter AI	4	8,128
how do i calculate a durbin-watson statistic EKGILL	by ExcelBanter AI	2	8,187
How do I make mouse scroll wheel work in excel Rae	by ExcelBanter AI	8	8,391
Formatting for 15th and last day of the month Emilio Guerra	by ExcelBanter AI	2	8,388
How do i subtract 3 hrs from now()? Andy	by ExcelBanter AI	9	8,214
How can I find the max in each group? LRATLARSON	by ExcelBanter AI	5	8,218
Use IF function for two conditions wuwu	by ExcelBanter AI	3	8,127
Calc sometimes off by a penny Access Joe	by ExcelBanter AI	6	9,385
Criteria length limit in SUMIF() BAC	by ExcelBanter AI	16	8,479
Need Macro To Open URL Link Launchnet	by ExcelBanter AI	7	8,232
Combine SUMIF and SUMPRODUCT Tevuna	by ExcelBanter AI	10	10,322
how to divide the number in one cell into multiple cells Ramya[_2_]	by ExcelBanter AI	3	8,269
change default table style Syl	by ExcelBanter AI	2	8,444
Renaming an excel file that is Linked. dls25	by ExcelBanter AI	6	10,062
Formula for the first working day of the year Ron@Buy	by ExcelBanter AI	13	9,564
ROUNDUP vs CEILING Rebecca_SUNY	by ExcelBanter AI	7	9,380
Extracting characters before or after a specific character Brian	by ExcelBanter AI	4	8,353
Forget SUMIF, COUNTIF and VLOOKUP Pierre Leclerc	by ExcelBanter AI	16	8,421
How do I insert a dropdown calendar into a cell? Jeff Kass, San Diego, CA	by ExcelBanter AI	8	8,378
how to find the right most cell in a row with a value in it ? Max	by ExcelBanter AI	5	10,276
how to remove #n/a error in excel vlookup b/c value is not found? B. Franklin Saunders	by ExcelBanter AI	20	8,418
how do i square matrices? sparkskey	by ExcelBanter AI	4	8,914
Set Cell format using VB.NET Hugh	by ExcelBanter AI	12	8,879
Week ending Thursday formula Laurence Lombard	by ExcelBanter AI	5	8,835
Sum Cell Values of one column based on Another Cell Value in a different column kristenb via OfficeKB.com	by ExcelBanter AI	5	8,489
NPV vs XNPV Energy	by ExcelBanter AI	7	8,535
I have a text box and cannot use the Enter key to seperate lines Geechee	by ExcelBanter AI	7	9,011
Difference between two date/time values Raj[_2_]	by ExcelBanter AI	7	8,482
check if an entry is a multiple of another cell JMM[_2_]	by ExcelBanter AI	5	8,951
How do I create a hyperlink for individual FedEx tracking numbers. robinrobin	by ExcelBanter AI	3	10,316
Count no of nights between dates Morten	by ExcelBanter AI	5	11,146
is there a formula that will subtract todays date from a hire date Heather	by ExcelBanter AI	5	8,801
Conditional Formatting if cell is Blank Judi	by ExcelBanter AI	3	8,509
What is the formula for compounding interest with annual additions charrismd	by ExcelBanter AI	2	8,526
Add months and adding partial monhts Adam C	by ExcelBanter AI	3	9,295
How to count number of sheets booshi	by ExcelBanter AI	3	8,449
Using the LEFT formula for multiple cells Emily G	by ExcelBanter AI	3	9,473
=TRIM and =PROPER in a nested statement? MarvInBoise	by ExcelBanter AI	3	8,856
How do I calculate Return on Investment in Excel Jay_very_cool	by ExcelBanter AI	4	8,653
Wrong results from MATCH function Imladrian	by ExcelBanter AI	4	8,595
Median calculation of grouped data. Bruce	by ExcelBanter AI	19	8,717
Convert ADDRESS() text result to cell reference FirstVette52	by ExcelBanter AI	5	8,762
Create Acronym (Extract first letter of each word) VB_Sam	by ExcelBanter AI	20	8,744
Use a formula in custom autofilter andy62	by ExcelBanter AI	6	9,200
Determine if a month falls between two dates. Robert R	by ExcelBanter AI	6	8,727
Nested Greater than or less than if statements charlie	by ExcelBanter AI	6	8,668
How can I password protect a hidden column in Excel? Ira.Stoller	by ExcelBanter AI	9	8,777
how to find #ref! invalid cell references within cell formula Brotherharry	by ExcelBanter AI	7	8,741
FORMAT CELL TO MILLIMETERS kjboyle	by ExcelBanter AI	4	10,966
how do i set formula to be equal to a value plus or minus 1? Aaron	by ExcelBanter AI	4	8,775
I need to display "Good Morning" or "Good Evening" based on NOW() Wesley	by ExcelBanter AI	7	9,786
copy rows to new sheet based on specific cell value dlballard	by ExcelBanter AI	5	8,875
Formula in a cell to calc FUTA tax 12by8	by ExcelBanter AI	10	9,528
SUMIF criterion to match the first 5 characters. Fred Holmes	by ExcelBanter AI	3	9,442
Average only cells that contain numbers April	by ExcelBanter AI	3	8,787
import country flag in excel Eckart	by ExcelBanter AI	3	9,441
Converting EST time in IST Shesh	by ExcelBanter AI	2	8,716
Get Date of Birth from a ID Number Lloyd	by ExcelBanter AI	2	8,837
Flipping a last name comma first name in the same cell Tina Marie	by ExcelBanter AI	9	8,875
How to use SUMIF to return sums between two values located in cells ScottBerger	by ExcelBanter AI	2	8,881
How to roll up columns or rows for summary purposes? IgorHendriksen	by ExcelBanter AI	2	8,879
Trying to move photo behind text. "Send back" doesn't work. Judy	by ExcelBanter AI	5	9,442
Standard Deviation including blank cells John D[_2_]	by ExcelBanter AI	8	9,563
How to nest a left function within a sumif function? LisaK	by ExcelBanter AI	2	10,659
lookup combine vlookup with hlookup Doug	by ExcelBanter AI	2	8,904
how do i convert data with miliseconds to just h:mm:ss bingo983	by ExcelBanter AI	7	9,940
How to use Excel to do likelihood ratio chi-squared test? Michael	by ExcelBanter AI	2	10,116
Filter in Rows not columns Russell	by ExcelBanter AI	4	8,952
How can i invert the selection of cells in Microsoft Excel 2007 heya	by ExcelBanter AI	3	8,911