Excel Worksheet Functions - Page 5

Thread / Thread Starter	Last Post	Replies	Views
Filtering on upper/lowercase letters Chris Benton	by ExcelBanter AI	3	10,191
How can I change the formula for multiple cells at once? marquisv2001	by ExcelBanter AI	5	10,185
index,match - how to avoid same lookup when duplicates present nick	by ExcelBanter AI	12	10,167
how do i winsorize data in excel Samira Pimentel	by ExcelBanter AI	2	10,161
How to use Excel to do likelihood ratio chi-squared test? Michael	by ExcelBanter AI	2	10,139
Weekly Returns Robbins	by ExcelBanter AI	14	10,137
make multiple copies of a sheet in a new workbook galeanne	by ExcelBanter AI	4	10,087
Auto Sum, how do you turn it off?? JY	by ExcelBanter AI	4	10,069
Renaming an excel file that is Linked. dls25	by ExcelBanter AI	6	10,068
Converting decimal fractions of minutes to seconds ronnie-g	by ExcelBanter AI	13	10,028
Looking for excel function to convert hex to Ascii SuperUke	by ExcelBanter AI	2	9,997
Deriving P-Value through LINEST Function RJ	by ExcelBanter AI	2	9,989
NZ function equivalent in Excel jg	by ExcelBanter AI	7	9,981
how do i convert data with miliseconds to just h:mm:ss bingo983	by ExcelBanter AI	7	9,949
restricted values that can be entered mweber	by ExcelBanter AI	4	9,908
How can I give text (A,B...) a number value in Excel (A=1, B=2..) Pete	by ExcelBanter AI	4	9,903
How do I find a % difference between two numbers (comparing 2005 . Officer Steve	by ExcelBanter AI	6	9,867
How do I set up a "Random Number" button in Excel? jnoriega	by ExcelBanter AI	2	9,860
what do the brackets { } mean around a formula? mark	by ExcelBanter AI	2	9,841
IF cell contains certain text return value EÃ¡n[_2_]	by ExcelBanter AI	11	9,836
I need to display "Good Morning" or "Good Evening" based on NOW() Wesley	by ExcelBanter AI	7	9,812
PERCENTILE with an IF Clause Zeelotes	by ExcelBanter AI	3	9,796
How to get the plus/minus at the top when grouping beac	by ExcelBanter AI	4	9,772
360-day Year Based Payment & Amortization Calculations? Kelley from NC	by ExcelBanter AI	2	9,762
EXCEL function;find string in entire column & return cell referenc Audit Compliance Man	by ExcelBanter AI	2	9,736
Turn a four digit number into pounds & pence Kolsballs	by ExcelBanter AI	6	9,734
random alphanumeric string [email protected]	by ExcelBanter AI	4	9,722
IS THERE A DAILY MEDICATION DOSAGE LOG TEMPLATE ? AHEAZY	by ExcelBanter AI	2	9,720
Function to determine if AM or PM gtslabs	by ExcelBanter AI	3	9,714
Calculate value at the end of nth year using CAGR Fenil Shah[_2_]	by ExcelBanter AI	5	9,711
Setting intercept to zero with SLOPE/STEYX/etc [email protected]	by ExcelBanter AI	4	9,706
What formula is used for subtracting a range of different cells f. tim	by ExcelBanter AI	3	9,658
Sum values if date is before today James	by ExcelBanter AI	4	9,636
Is there a Division funtion in Excel? Seaflower	by ExcelBanter AI	4	9,633
I want the PMT function to calculate using 360 days not 365 amalecki	by ExcelBanter AI	6	9,631
Excel - Convert int value secs past midnight into time 53100=2:45 Zuly	by ExcelBanter AI	2	9,615
Arabic Numbers Mohamed Attia	by ExcelBanter AI	10	9,604
Trying to calculate average call length pilates_jocelyn	by ExcelBanter AI	7	9,593
Formula for the first working day of the year Ron@Buy	by ExcelBanter AI	13	9,582
Standard Deviation including blank cells John D[_2_]	by ExcelBanter AI	8	9,580
Where can I find a simple paying in and out with Totals sheet Les Edwards	by ExcelBanter AI	2	9,563
Trying to move photo behind text. "Send back" doesn't work. Judy	by ExcelBanter AI	5	9,562
count all text values except a certain one justjill111	by ExcelBanter AI	6	9,553
Formula in a cell to calc FUTA tax 12by8	by ExcelBanter AI	10	9,537
How do I caluclate an Annual Percentage Rate in Excel? Lisa M	by ExcelBanter AI	32	9,514
Greater than AND Less than Time Q Seanie	by ExcelBanter AI	3	9,493
Using the LEFT formula for multiple cells Emily G	by ExcelBanter AI	3	9,482
anova post-hoc analysis: tukey test Ross	by ExcelBanter AI	6	9,474
Conditional formating to highlight dates 30, 60, and 90 days out? Splatme	by ExcelBanter AI	8	9,457
import country flag in excel Eckart	by ExcelBanter AI	3	9,452
How do I compute annual rate of return in Excel? vg	by ExcelBanter AI	5	9,450
SUMIF criterion to match the first 5 characters. Fred Holmes	by ExcelBanter AI	3	9,444
Logical test IF a decimal was typed in a cell jheath.bc	by ExcelBanter AI	8	9,425
Convert 1.1B to 1,100,000.00 SteveM	by ExcelBanter AI	6	9,410
ROUNDUP vs CEILING Rebecca_SUNY	by ExcelBanter AI	7	9,395
Calc sometimes off by a penny Access Joe	by ExcelBanter AI	6	9,392
Add months and adding partial monhts Adam C	by ExcelBanter AI	3	9,327
My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing ! Joanne	by ExcelBanter AI	3	9,311
CountIf Condition based on lookup in a list of values Eric E	by ExcelBanter AI	6	9,297
NonLinear R-squared (R2) Biocellguy	by ExcelBanter AI	3	9,284
Assigning a number value to text SoupNazi	by ExcelBanter AI	6	9,246
more arguments have been specified for this function than are allo pm	by ExcelBanter AI	3	9,245
Despite formula I use (for example SUM) result is always zero. Anida	by ExcelBanter AI	6	9,224
Display "/" (slash) as a character, not as an action (divide) bobdenver	by ExcelBanter AI	6	9,223
Is the first character a number or letter bactfarmer	by ExcelBanter AI	13	9,212
Use a formula in custom autofilter andy62	by ExcelBanter AI	6	9,207
PDIFF , DDIFF Steven	by ExcelBanter AI	2	9,206
How do I subtract 1 hour from one cell and input it another? Steven	by ExcelBanter AI	6	9,188
Do not allow negative numbers in cell JNW	by ExcelBanter AI	5	9,176
Why do Excel cells not calculate until I hit "save" Bill R	by ExcelBanter AI	3	9,165
How to insert infinity symbol in excel? Zhead	by ExcelBanter AI	7	9,156
Pages in a worksheet linked, how to unlink?? Meenie	by ExcelBanter AI	2	9,153
Custom Number Format to abbreviate to Millions Pierre	by ExcelBanter AI	4	9,138
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches ( 1 2) [email protected]	by ExcelBanter AI	66	9,113
Advanced Filtering is Unavailable Beau	by ExcelBanter AI	4	9,090