Excel Worksheet Functions - Page 1180

Thread / Thread Starter	Last Post	Replies	Views
How to nest a left function within a sumif function? LisaK	by ExcelBanter AI	2	10,700
Return the filtered value into a specific cell Sal	by ExcelBanter AI	5	10,751
how do I do conditional formatting for absolute values? Carol	by ExcelBanter AI	4	10,755
parent/child relationship between rows? Doug	by ExcelBanter AI	4	10,786
IF function between a range of numbers e.g 1000 to 2000 Suz	by ExcelBanter AI	4	10,825
Is there a medianif similar to averageif justnike4	by ExcelBanter AI	4	10,854
Subtracting one list from another list Brian	by ExcelBanter AI	3	10,857
check and uncheck macro [email protected]	by ExcelBanter AI	6	10,877
Formula to return date of following Friday Daniel Bonallack	by ExcelBanter AI	6	10,886
Formula for selecting the greater of two values? Boriana	by ExcelBanter AI	6	10,892
converting month name to number runsrealfast	by ExcelBanter AI	3	10,899
Calculating gross when net is known placerpone	by ExcelBanter AI	4	10,922
How can I make a drop down box visible within a worksheet? skittles_golf	by ExcelBanter AI	42	10,932
how do I print only horizontal gridlines in an excel worksheet? Arih	by ExcelBanter AI	2	10,948
How do I add multiple comments to a cell? deberjones	by ExcelBanter AI	2	10,950
How to have a cell auto resize the font to make text fit in cell? tanner08	by ExcelBanter AI	2	10,957
SUMIFs across multiple sheets kwyjibo jones	by ExcelBanter AI	8	10,968
add file extensions to a column The DLC	by ExcelBanter AI	4	10,969
Financial function - calculating loans with deferred payments Paul 022	by ExcelBanter AI	3	11,059
MATCH from right to left Werner Rohrmoser	by ExcelBanter AI	7	11,062
Select multiple rows not next to each other LarryJNX	by ExcelBanter AI	3	11,069
Using LARGE function with criteria TT	by ExcelBanter AI	4	11,080
I lost the box on the top of Excel that you can type text in??? andrew	by ExcelBanter AI	3	11,121
trendline option missing jemelland	by ExcelBanter AI	2	11,138
FORMAT CELL TO MILLIMETERS kjboyle	by ExcelBanter AI	4	11,188
Percentage Formula in Excel Mike_GSP	by ExcelBanter AI	4	11,223
How calculate end time with beginning time plus formula minutes Calculate an ending time	by ExcelBanter AI	3	11,324
Count no of nights between dates Morten	by ExcelBanter AI	5	11,380
calculate percentage of month passed Anita	by ExcelBanter AI	6	11,388
Remove Characters Until a Specific Character is Reached Frosty 1234	by ExcelBanter AI	8	11,398
how do i convert the number 1 as 01 or 001 in excell cell Vinayak	by ExcelBanter AI	2	11,411
Effective Annual Interest Rate John	by ExcelBanter AI	4	11,456
need one formula for % change in TY vs LY revenue Gene	by ExcelBanter AI	9	11,481
How do I do sensitivity analysis in excel 2007? Kat	by ExcelBanter AI	3	11,514
Referencing a named range on another sheet Jan B	by ExcelBanter AI	5	11,534
Adding and Subtracting a Time with MilliSeconds carl	by ExcelBanter AI	8	11,546
Shortcut key for comma format? Pierre	by ExcelBanter AI	3	11,561
Excel 2003 worksheet tabs missing at bottom of my laptop display Quixote	by ExcelBanter AI	5	11,563
drag a formula downa column keeping one value the same? column formula with a constant value	by ExcelBanter AI	4	11,574
looking up a value between two numbers and returning a related value JulieD	by ExcelBanter AI	14	11,586
IF statements referencing an absolute value or a range of values skaminski	by ExcelBanter AI	6	11,611
Sorting Numbers with letter suffixes Terry Bennett	by ExcelBanter AI	13	11,648
Locking all but a few cells on a worksheet JC	by ExcelBanter AI	4	11,656
Can I Use a Count Function for Text? Joan NYC	by ExcelBanter AI	107	11,681
How To INCREMENT days of the week? like mon,tues,wed,etc?? Robert Blass	by ExcelBanter AI	5	11,705
IF Statement with two variables RoadKill	by ExcelBanter AI	9	11,718
Return first 2 numbers of a cell Patrick C. Simonds	by ExcelBanter AI	3	11,748
Text "comparison" operator for "contains" used in an "IF" Function Pawaso	by ExcelBanter AI	4	11,764
HYPERLINK - Jump to another sheet in the same workbook Tor Einar	by ExcelBanter AI	4	11,771
Macro - How to increment cell reference by one row lau_ash[_2_]	by ExcelBanter AI	7	11,775
Array formulae do not recalculate Thanks	by ExcelBanter AI	3	11,794
BIN2DEC conversion for large binary numbers ahmedmidany	by ExcelBanter AI	21	11,835
Copy Multiple Columns, Paste Under a Single column Sriram	by ExcelBanter AI	12	11,852
Go To the next empty cell in Column A DaddyRay	by ExcelBanter AI	4	11,884
How do I add and subtract engineering stations in Excel? Jupraven	by ExcelBanter AI	4	11,887
Rule of 75 Retirement Calculation BAD	by ExcelBanter AI	28	11,896
End of Year Dedrie	by ExcelBanter AI	3	11,938
How can I lookup when match has more than one value? bonot1	by ExcelBanter AI	56	11,944
$ 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
When I enter a formula, Excel shows the formula not the results Pat Adams	by ExcelBanter AI	5	12,008
How do I calculation vacation accrual? WizTech	by ExcelBanter AI	2	12,023
how to insert tally mark in excel shawn	by ExcelBanter AI	8	12,039
Countif does not equal JRD	by ExcelBanter AI	6	12,039
Workaround for HYPERLINK argument length limit Dave Booker	by ExcelBanter AI	5	12,043
microsoft office excel cannot paste the data Ian	by ExcelBanter AI	4	12,075
Incorporating Cell color fill in an "if" logical function? George_Sky	by ExcelBanter AI	46	12,138
Excel Pivot Table How to Sort data as Percent of Row Pat	by ExcelBanter AI	10	12,149
I need a Line of Credit Calculator Titanium	by ExcelBanter AI	6	12,168
IF this value IS NOT in this range THEN Iyanna	by ExcelBanter AI	7	12,184
Can Excel recognize gender? Rebecca	by ExcelBanter AI	5	12,222
My excel spreadsheet won't print or print preview all the pages? whirlybird	by ExcelBanter AI	2	12,268
I can't sort my miscrosoft excel worksheet anymore, what happened? alice	by ExcelBanter AI	2	12,298
bulk replacement of cell reference within formula Twishlist	by ExcelBanter AI	3	12,310
Formula Omits Adjacent Cells Excel Hater	by ExcelBanter AI	8	12,368