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,597
How do I run a regression on data that is not numerical? NG	by ExcelBanter AI	4	14,837
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,351
convert bond price to decimal including + novice	by ExcelBanter AI	10	16,211
Rate vs. IRR Phin Lars	by ExcelBanter AI	2	14,609
Copy only letters, not numbers Connie Martin	by ExcelBanter AI	9	13,875
How enter time DURATIONS mm:ss (not clock times), then sum? Roger D	by ExcelBanter AI	4	12,695
Do nothing if False! Simi Singh	by ExcelBanter AI	8	14,961
formula to a minimum value of zero if a negative number Jay M 0425	by ExcelBanter AI	3	12,600
How can I count items in a filtered list? ( 1 2) Counting filtered data.	by ExcelBanter AI	44	13,774
Calculate 60 days from Start Date - including weekends Missy	by ExcelBanter AI	6	12,671
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,457
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,064
need a formula to convert pounds to tons( 2000) lbs per ton Liverpool Loo	by ExcelBanter AI	5	14,685
Calculate hours worked minus a half hour for lunch Danedel	by ExcelBanter AI	4	13,645
Calculating Sortino Ration (Downside Deviation) TimH	by ExcelBanter AI	8	12,456
Vba - Save but don't close Sandy	by ExcelBanter AI	4	13,117
create formula to add 15 minutes to previous time value Bruce	by ExcelBanter AI	2	12,424
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,909
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,827
extend the range of cells for a drop down list Marge	by ExcelBanter AI	9	12,456
Find the Date of the Next Friday Thomas M.	by ExcelBanter AI	13	13,255
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,266
microsoft office excel cannot paste the data Ian	by ExcelBanter AI	4	12,070
How do I calculation vacation accrual? WizTech	by ExcelBanter AI	2	12,022
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,217
$ 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,981
How do i convert kg to tonnes in excel? dave1234	by ExcelBanter AI	3	16,509
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,770
End of Year Dedrie	by ExcelBanter AI	3	11,935
Go To the next empty cell in Column A DaddyRay	by ExcelBanter AI	4	11,878
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,849
Array formulae do not recalculate Thanks	by ExcelBanter AI	3	11,789
'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,580
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,608
Effective Annual Interest Rate John	by ExcelBanter AI	4	11,454
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,022
Average Symbol Workbook	by ExcelBanter AI	9	15,295
I need a Line of Credit Calculator Titanium	by ExcelBanter AI	6	12,166
Shortcut key for comma format? Pierre	by ExcelBanter AI	3	11,557
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