Excel Worksheet Functions - Page 5

Thread / Thread Starter	Last Post	Replies	Views
Filtering on upper/lowercase letters Chris Benton	by ExcelBanter AI	3	10,236
How to use Excel to do likelihood ratio chi-squared test? Michael	by ExcelBanter AI	2	10,207
How can I change the formula for multiple cells at once? marquisv2001	by ExcelBanter AI	5	10,199
how do i winsorize data in excel Samira Pimentel	by ExcelBanter AI	2	10,181
index,match - how to avoid same lookup when duplicates present nick	by ExcelBanter AI	12	10,174
Weekly Returns Robbins	by ExcelBanter AI	14	10,146
Auto Sum, how do you turn it off?? JY	by ExcelBanter AI	4	10,124
make multiple copies of a sheet in a new workbook galeanne	by ExcelBanter AI	4	10,116
Deriving P-Value through LINEST Function RJ	by ExcelBanter AI	2	10,099
Renaming an excel file that is Linked. dls25	by ExcelBanter AI	6	10,096
Converting decimal fractions of minutes to seconds ronnie-g	by ExcelBanter AI	13	10,094
NZ function equivalent in Excel jg	by ExcelBanter AI	7	10,025
Looking for excel function to convert hex to Ascii SuperUke	by ExcelBanter AI	2	10,006
how do i convert data with miliseconds to just h:mm:ss bingo983	by ExcelBanter AI	7	9,967
restricted values that can be entered mweber	by ExcelBanter AI	4	9,924
How can I give text (A,B...) a number value in Excel (A=1, B=2..) Pete	by ExcelBanter AI	4	9,918
How do I find a % difference between two numbers (comparing 2005 . Officer Steve	by ExcelBanter AI	6	9,893
How do I set up a "Random Number" button in Excel? jnoriega	by ExcelBanter AI	2	9,887
what do the brackets { } mean around a formula? mark	by ExcelBanter AI	2	9,851
IF cell contains certain text return value EÃ¡n[_2_]	by ExcelBanter AI	11	9,845
I need to display "Good Morning" or "Good Evening" based on NOW() Wesley	by ExcelBanter AI	7	9,840
PERCENTILE with an IF Clause Zeelotes	by ExcelBanter AI	3	9,803
How to get the plus/minus at the top when grouping beac	by ExcelBanter AI	4	9,779
360-day Year Based Payment & Amortization Calculations? Kelley from NC	by ExcelBanter AI	2	9,769
Turn a four digit number into pounds & pence Kolsballs	by ExcelBanter AI	6	9,759
EXCEL function;find string in entire column & return cell referenc Audit Compliance Man	by ExcelBanter AI	2	9,752
random alphanumeric string [email protected]	by ExcelBanter AI	4	9,732
IS THERE A DAILY MEDICATION DOSAGE LOG TEMPLATE ? AHEAZY	by ExcelBanter AI	2	9,727
Function to determine if AM or PM gtslabs	by ExcelBanter AI	3	9,724
Calculate value at the end of nth year using CAGR Fenil Shah[_2_]	by ExcelBanter AI	5	9,720
Setting intercept to zero with SLOPE/STEYX/etc [email protected]	by ExcelBanter AI	4	9,715
Sum values if date is before today James	by ExcelBanter AI	4	9,670
What formula is used for subtracting a range of different cells f. tim	by ExcelBanter AI	3	9,670
I want the PMT function to calculate using 360 days not 365 amalecki	by ExcelBanter AI	6	9,666
Arabic Numbers Mohamed Attia	by ExcelBanter AI	10	9,647
Excel - Convert int value secs past midnight into time 53100=2:45 Zuly	by ExcelBanter AI	2	9,640
Is there a Division funtion in Excel? Seaflower	by ExcelBanter AI	4	9,640
Trying to calculate average call length pilates_jocelyn	by ExcelBanter AI	7	9,617
Trying to move photo behind text. "Send back" doesn't work. Judy	by ExcelBanter AI	5	9,602
Formula for the first working day of the year Ron@Buy	by ExcelBanter AI	13	9,599
Standard Deviation including blank cells John D[_2_]	by ExcelBanter AI	8	9,598
Where can I find a simple paying in and out with Totals sheet Les Edwards	by ExcelBanter AI	2	9,573
count all text values except a certain one justjill111	by ExcelBanter AI	6	9,562
How do I caluclate an Annual Percentage Rate in Excel? Lisa M	by ExcelBanter AI	32	9,557
Formula in a cell to calc FUTA tax 12by8	by ExcelBanter AI	10	9,553
Greater than AND Less than Time Q Seanie	by ExcelBanter AI	3	9,526
Using the LEFT formula for multiple cells Emily G	by ExcelBanter AI	3	9,506
anova post-hoc analysis: tukey test Ross	by ExcelBanter AI	6	9,498
Conditional formating to highlight dates 30, 60, and 90 days out? Splatme	by ExcelBanter AI	8	9,486
import country flag in excel Eckart	by ExcelBanter AI	3	9,464
Logical test IF a decimal was typed in a cell jheath.bc	by ExcelBanter AI	8	9,459
How do I compute annual rate of return in Excel? vg	by ExcelBanter AI	5	9,455
SUMIF criterion to match the first 5 characters. Fred Holmes	by ExcelBanter AI	3	9,454
Convert 1.1B to 1,100,000.00 SteveM	by ExcelBanter AI	6	9,424
ROUNDUP vs CEILING Rebecca_SUNY	by ExcelBanter AI	7	9,422
Calc sometimes off by a penny Access Joe	by ExcelBanter AI	6	9,417
Add months and adding partial monhts Adam C	by ExcelBanter AI	3	9,364
My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing ! Joanne	by ExcelBanter AI	3	9,315
CountIf Condition based on lookup in a list of values Eric E	by ExcelBanter AI	6	9,304
NonLinear R-squared (R2) Biocellguy	by ExcelBanter AI	3	9,302
Display "/" (slash) as a character, not as an action (divide) bobdenver	by ExcelBanter AI	6	9,300
PDIFF , DDIFF Steven	by ExcelBanter AI	2	9,268
Assigning a number value to text SoupNazi	by ExcelBanter AI	6	9,251
more arguments have been specified for this function than are allo pm	by ExcelBanter AI	3	9,251
Use a formula in custom autofilter andy62	by ExcelBanter AI	6	9,229
Despite formula I use (for example SUM) result is always zero. Anida	by ExcelBanter AI	6	9,229
Is the first character a number or letter bactfarmer	by ExcelBanter AI	13	9,221
Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches [email protected]	by ExcelBanter AI	66	9,212
How do I subtract 1 hour from one cell and input it another? Steven	by ExcelBanter AI	6	9,206
Do not allow negative numbers in cell JNW	by ExcelBanter AI	5	9,191
Why do Excel cells not calculate until I hit "save" Bill R	by ExcelBanter AI	3	9,178
Pages in a worksheet linked, how to unlink?? Meenie	by ExcelBanter AI	2	9,166
How to insert infinity symbol in excel? Zhead	by ExcelBanter AI	7	9,164
Custom Number Format to abbreviate to Millions Pierre	by ExcelBanter AI	4	9,160
I need a formula to mark up a product by 200% StitchWitch	by ExcelBanter AI	7	9,120