Excel Worksheet Functions - Page 6

Thread / Thread Starter	Last Post	Replies	Views
How to use Ara and ARP fucntions on Ms Excel? ANJAN	by ExcelBanter AI	7	12,421
Locking all but a few cells on a worksheet JC	by ExcelBanter AI	4	11,650
Go To the next empty cell in Column A DaddyRay	by ExcelBanter AI	4	11,866
End of Year Dedrie	by ExcelBanter AI	3	11,922
HYPERLINK - Jump to another sheet in the same workbook Tor Einar	by ExcelBanter AI	4	11,761
Geometric Standard Deviation Sandman	by ExcelBanter AI	12	13,118
Delta E(cmc) formula Michelle7890	by ExcelBanter AI	11	13,209
Formula Omits Adjacent Cells Excel Hater	by ExcelBanter AI	8	12,281
When I enter a formula, Excel shows the formula not the results Pat Adams	by ExcelBanter AI	5	11,989
How do i convert kg to tonnes in excel? dave1234	by ExcelBanter AI	3	16,358
how to split data where line breaks are the delimiter Jackie Pearce	by ExcelBanter AI	5	11,979
$ for VLOOKUP functions Suzannah	by ExcelBanter AI	4	11,943
find and replace nonzero values with 1 Amylacc	by ExcelBanter AI	4	13,186
How do I mask a Social Security Number ###-##-nnnn? Ed H[_2_]	by ExcelBanter AI	3	13,662
Countif does not equal JRD	by ExcelBanter AI	6	12,029
How do I calculation vacation accrual? WizTech	by ExcelBanter AI	2	12,018
microsoft office excel cannot paste the data Ian	by ExcelBanter AI	4	12,030
My excel spreadsheet won't print or print preview all the pages? whirlybird	by ExcelBanter AI	2	12,186
I can't sort my miscrosoft excel worksheet anymore, what happened? alice	by ExcelBanter AI	2	12,206
Find the Date of the Next Friday Thomas M.	by ExcelBanter AI	13	13,216
extend the range of cells for a drop down list Marge	by ExcelBanter AI	9	12,339
How can I make a column "float" as I scroll horizontally? DarkStone1979	by ExcelBanter AI	5	12,785
Need formula to calculate subtotal before sales tax HLR2007	by ExcelBanter AI	5	12,871
IF this value IS NOT in this range THEN Iyanna	by ExcelBanter AI	7	12,166
inverse weighted average Dan Cotts[_2_]	by ExcelBanter AI	3	13,836
HOW TO SET UP REMINDERS IN EXCEL? Janelle	by ExcelBanter AI	2	13,153
create formula to add 15 minutes to previous time value Bruce	by ExcelBanter AI	2	12,337
Vba - Save but don't close Sandy	by ExcelBanter AI	4	13,069
Calculating Sortino Ration (Downside Deviation) TimH	by ExcelBanter AI	8	12,428
Calculate hours worked minus a half hour for lunch Danedel	by ExcelBanter AI	4	13,556
need a formula to convert pounds to tons( 2000) lbs per ton Liverpool Loo	by ExcelBanter AI	5	14,596
Count and Sum data in same Pivot table [email protected]	by ExcelBanter AI	7	13,030
Normalizing Excel data across rows Greenstorm	by ExcelBanter AI	3	12,591
Why put a plus sign after = sign in a formula kMan	by ExcelBanter AI	3	12,430
IRR / MIRR and Perpetuity Jeff	by ExcelBanter AI	8	12,707
Calculate 60 days from Start Date - including weekends Missy	by ExcelBanter AI	6	12,639
How can I count items in a filtered list? ( 1 2) Counting filtered data.	by ExcelBanter AI	44	13,672
formula to a minimum value of zero if a negative number Jay M 0425	by ExcelBanter AI	3	12,585
Do nothing if False! Simi Singh	by ExcelBanter AI	8	14,927
How enter time DURATIONS mm:ss (not clock times), then sum? Roger D	by ExcelBanter AI	4	12,645
Copy only letters, not numbers Connie Martin	by ExcelBanter AI	9	13,766
Rate vs. IRR Phin Lars	by ExcelBanter AI	2	14,543
convert bond price to decimal including + novice	by ExcelBanter AI	10	16,147
Excel: Change Direction of Group/Outline Function Ray Carter	by ExcelBanter AI	5	13,225
Excel X for Mac - show formulas Jim Carlton JMS	by ExcelBanter AI	4	12,839
How do I find/replace data in selected cells only Mike_3333	by ExcelBanter AI	7	13,025
How do I run a regression on data that is not numerical? NG	by ExcelBanter AI	4	14,820
PMT: Daily interest compounding; monthly payment rkhughes	by ExcelBanter AI	10	14,566
Can Excel automatically insert current date in a cell? AdrianXing	by ExcelBanter AI	25	13,205
CAN VLOOKUP SEARCH AN ENTIRE WORKSHEET INSTEAD OF RANGE OF CELLS BROCK8292	by ExcelBanter AI	4	13,056
my paste special function won't let me copy formulas squintana	by ExcelBanter AI	4	13,074
how do I print edge to edge with absolutely NO margins Girl4chuckie	by ExcelBanter AI	3	16,483
Changing Numerators but not Denominators BTM	by ExcelBanter AI	3	15,785
Find position number of third space Steve Stad	by ExcelBanter AI	7	13,169
My formula is =Sum(E38). How can I add text to the formula? Marie	by ExcelBanter AI	5	13,476
I need to divide multiple cells by a single control cell in order. LRM	by ExcelBanter AI	3	13,265
View the code in a add-in sh0t2bts	by ExcelBanter AI	9	14,325
count function not working, keeps displaying 0 dnm	by ExcelBanter AI	5	15,359
How to I calculate 180 days from any date? Jackie	by ExcelBanter AI	2	15,076
How do I round time down to the nearest half hour? KatJ	by ExcelBanter AI	4	13,422
merge cells button doesn't work Mark F	by ExcelBanter AI	5	13,436
what is the formual for calculating running pace? tonym	by ExcelBanter AI	5	17,168
Highest total of any three consecutive numbers in a range. [email protected]	by ExcelBanter AI	13	14,393
Shaded cells won't print shaded Linda C	by ExcelBanter AI	4	14,642
how do I create a formula to convert kilograms to pounds Bob	by ExcelBanter AI	6	13,832
Calculate How Long Funds Will Last ridgerunner	by ExcelBanter AI	7	15,646
Interpolate in table lookup proinwv	by ExcelBanter AI	18	14,231
how do I use the inverse sine (sin -1) function in Excel 2007? Priyanthi Silva	by ExcelBanter AI	2	13,980
I need to calculate a Geometric mean Biff	by ExcelBanter AI	8	14,245
triangular distribution Yaarit	by ExcelBanter AI	4	14,609
How to filter merged cells to get more than the first row Scruffy89	by ExcelBanter AI	2	14,131
Adding bytes, gigabytes, and megabytes in Excel NetTech	by ExcelBanter AI	4	14,419
Bond premium amortization using the constant yield method lmahaffey	by ExcelBanter AI	2	14,255
How do I calculate a weighted median? ac	by ExcelBanter AI	7	16,386
how do I cross out something in a cell to keep it visible rose angel	by ExcelBanter AI	4	14,406