Excel Worksheet Functions - Page 1178

Thread / Thread Starter	Last Post	Replies	Views
CAN VLOOKUP SEARCH AN ENTIRE WORKSHEET INSTEAD OF RANGE OF CELLS BROCK8292	by ExcelBanter AI	4	13,062
Can Excel automatically insert current date in a cell? AdrianXing	by ExcelBanter AI	25	13,225
PMT: Daily interest compounding; monthly payment rkhughes	by ExcelBanter AI	10	14,598
How do I run a regression on data that is not numerical? NG	by ExcelBanter AI	4	14,838
How do I find/replace data in selected cells only Mike_3333	by ExcelBanter AI	7	13,027
Excel X for Mac - show formulas Jim Carlton JMS	by ExcelBanter AI	4	12,863
Excel: Change Direction of Group/Outline Function Ray Carter	by ExcelBanter AI	5	13,353
convert bond price to decimal including + novice	by ExcelBanter AI	10	16,211
Rate vs. IRR Phin Lars	by ExcelBanter AI	2	14,610
Copy only letters, not numbers Connie Martin	by ExcelBanter AI	9	13,876
How enter time DURATIONS mm:ss (not clock times), then sum? Roger D	by ExcelBanter AI	4	12,698
Do nothing if False! Simi Singh	by ExcelBanter AI	8	14,966
formula to a minimum value of zero if a negative number Jay M 0425	by ExcelBanter AI	3	12,601
How can I count items in a filtered list? Counting filtered data.	by ExcelBanter AI	44	13,776
Calculate 60 days from Start Date - including weekends Missy	by ExcelBanter AI	6	12,672
IRR / MIRR and Perpetuity Jeff	by ExcelBanter AI	8	12,714
Why put a plus sign after = sign in a formula kMan	by ExcelBanter AI	3	12,458
Normalizing Excel data across rows Greenstorm	by ExcelBanter AI	3	12,660
Count and Sum data in same Pivot table [email protected]	by ExcelBanter AI	7	13,066
need a formula to convert pounds to tons( 2000) lbs per ton Liverpool Loo	by ExcelBanter AI	5	14,696
Calculate hours worked minus a half hour for lunch Danedel	by ExcelBanter AI	4	13,646
Calculating Sortino Ration (Downside Deviation) TimH	by ExcelBanter AI	8	12,456
Vba - Save but don't close Sandy	by ExcelBanter AI	4	13,120
create formula to add 15 minutes to previous time value Bruce	by ExcelBanter AI	2	12,425
HOW TO SET UP REMINDERS IN EXCEL? Janelle	by ExcelBanter AI	2	13,253
inverse weighted average Dan Cotts[_2_]	by ExcelBanter AI	3	13,914
IF this value IS NOT in this range THEN Iyanna	by ExcelBanter AI	7	12,184
Need formula to calculate subtotal before sales tax HLR2007	by ExcelBanter AI	5	12,974
How can I make a column "float" as I scroll horizontally? DarkStone1979	by ExcelBanter AI	5	12,828
extend the range of cells for a drop down list Marge	by ExcelBanter AI	9	12,457
Find the Date of the Next Friday Thomas M.	by ExcelBanter AI	13	13,256
I can't sort my miscrosoft excel worksheet anymore, what happened? alice	by ExcelBanter AI	2	12,298
My excel spreadsheet won't print or print preview all the pages? whirlybird	by ExcelBanter AI	2	12,267
microsoft office excel cannot paste the data Ian	by ExcelBanter AI	4	12,072
How do I calculation vacation accrual? WizTech	by ExcelBanter AI	2	12,023
Countif does not equal JRD	by ExcelBanter AI	6	12,039
How do I mask a Social Security Number ###-##-nnnn? Ed H[_2_]	by ExcelBanter AI	3	13,694
find and replace nonzero values with 1 Amylacc	by ExcelBanter AI	4	13,225
$ for VLOOKUP functions Suzannah	by ExcelBanter AI	4	11,954
how to split data where line breaks are the delimiter Jackie Pearce	by ExcelBanter AI	5	11,982
How do i convert kg to tonnes in excel? dave1234	by ExcelBanter AI	3	16,520
When I enter a formula, Excel shows the formula not the results Pat Adams	by ExcelBanter AI	5	12,008
Formula Omits Adjacent Cells Excel Hater	by ExcelBanter AI	8	12,368
Delta E(cmc) formula Michelle7890	by ExcelBanter AI	11	13,259
Geometric Standard Deviation Sandman	by ExcelBanter AI	12	13,154
HYPERLINK - Jump to another sheet in the same workbook Tor Einar	by ExcelBanter AI	4	11,771
End of Year Dedrie	by ExcelBanter AI	3	11,938
Go To the next empty cell in Column A DaddyRay	by ExcelBanter AI	4	11,879
Locking all but a few cells on a worksheet JC	by ExcelBanter AI	4	11,656
How to use Ara and ARP fucntions on Ms Excel? ANJAN	by ExcelBanter AI	7	12,441
Return first 2 numbers of a cell Patrick C. Simonds	by ExcelBanter AI	3	11,739
how to insert a special character (arrow) in IF statement HA@Work	by ExcelBanter AI	4	12,973
BIN2DEC conversion for large binary numbers ahmedmidany	by ExcelBanter AI	21	11,835
Text "comparison" operator for "contains" used in an "IF" Function Pawaso	by ExcelBanter AI	4	11,763
Copy Multiple Columns, Paste Under a Single column Sriram	by ExcelBanter AI	12	11,852
Array formulae do not recalculate Thanks	by ExcelBanter AI	3	11,794
'TABLE' array function JB2010	by ExcelBanter AI	5	12,555
How do I add an equals sign to a cell that already has numbers in George	by ExcelBanter AI	9	12,428
Referencing a named range on another sheet Jan B	by ExcelBanter AI	5	11,534
how do I calculate staffing ratios Xfiles325	by ExcelBanter AI	5	12,414
looking up a value between two numbers and returning a related value JulieD	by ExcelBanter AI	14	11,583
How do I do sensitivity analysis in excel 2007? Kat	by ExcelBanter AI	3	11,514
bulk replacement of cell reference within formula Twishlist	by ExcelBanter AI	3	12,308
Excel 2003 worksheet tabs missing at bottom of my laptop display Quixote	by ExcelBanter AI	5	11,563
IF statements referencing an absolute value or a range of values skaminski	by ExcelBanter AI	6	11,610
Effective Annual Interest Rate John	by ExcelBanter AI	4	11,455
IF Statement with two variables RoadKill	by ExcelBanter AI	9	11,717
drag a formula downa column keeping one value the same? column formula with a constant value	by ExcelBanter AI	4	11,574
Remove Characters Until a Specific Character is Reached Frosty 1234	by ExcelBanter AI	8	11,398
how to insert tally mark in excel shawn	by ExcelBanter AI	8	12,025
Average Symbol Workbook	by ExcelBanter AI	9	15,295
I need a Line of Credit Calculator Titanium	by ExcelBanter AI	6	12,167
Shortcut key for comma format? Pierre	by ExcelBanter AI	3	11,558
Sorting Numbers with letter suffixes Terry Bennett	by ExcelBanter AI	13	11,648
Excel Pivot Table How to Sort data as Percent of Row Pat	by ExcelBanter AI	10	12,149