Excel Worksheet Functions - Page 8

Thread / Thread Starter	Last Post	Replies	Views
=Text(n,"mmm") always returns "Jan" when n=1..12 Blaze-Of-Glory	by ExcelBanter AI	12	7,604
Excel Formulas "Not Greater than" Trace	by ExcelBanter AI	4	7,593
selecting every other data point in a column Joe Troutman	by ExcelBanter AI	4	7,585
why are my worksheet autosum totals one cent off? allan	by ExcelBanter AI	3	7,568
how can I increase nested function 'IF' in EXCEL upto 10 levels pandurrr	by ExcelBanter AI	8	7,567
removing green triangle in cell Shooter	by ExcelBanter AI	4	7,564
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows Michael Marshall	by ExcelBanter AI	11	7,546
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC	by ExcelBanter AI	2	7,528
how to convert list of numbers to barcode font Convert numbers to barcode in spreadht	by ExcelBanter AI	2	7,515
Random Number Generator - Multiple, Non-repeating, results A Long	by ExcelBanter AI	20	7,515
Calculating Average Length of Service EasyPeasy	by ExcelBanter AI	3	7,512
Editing text after concatenate Fozeye	by ExcelBanter AI	3	7,512
MID function from right to left nsv	by ExcelBanter AI	4	7,511
How to set up countdown timer to countdown days to a specific day Jenny	by ExcelBanter AI	3	7,508
Excel A3 paper size ???? Igor	by ExcelBanter AI	5	7,507
rolling 12 month date filter for pivot table? Randy Suggs	by ExcelBanter AI	3	7,507
Returning value of active cell Sergio	by ExcelBanter AI	3	7,501
HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE? katie	by ExcelBanter AI	2	7,494
Excel: want neg numbers to show red/pos green via if-then formula Jim	by ExcelBanter AI	4	7,486
How to stop formulas from incrementing when you copy and paste? Kirkwill	by ExcelBanter AI	2	7,485
calculate weighted average effective interest rate GK	by ExcelBanter AI	4	7,480
Make #N/A blank if no value is returned Babs in Ohio	by ExcelBanter AI	12	7,440
Function to concatenate cells in a range Leporello	by ExcelBanter AI	3	7,430
VLOOKUP returns a 0 and I want a blank KimB	by ExcelBanter AI	7	7,429
Reverse Order of Data Set Bekah1st	by ExcelBanter AI	4	7,422
Count Names NOT #N/A Dax Arroway	by ExcelBanter AI	3	7,411
vlookup on pivot table results = #N/A Louis	by ExcelBanter AI	5	7,409
Outlier analysis in excel - trimming means Shane Lindsay	by ExcelBanter AI	3	7,406
Count if two columns match different criteria Curt D.	by ExcelBanter AI	5	7,405
First Day of the month Jen_T	by ExcelBanter AI	4	7,399
calculate the difference between negative and positive values watty	by ExcelBanter AI	7	7,398
Edit Links - cannot change source Code Numpty	by ExcelBanter AI	5	7,389
Copying first three characters of text in a cell Kris	by ExcelBanter AI	4	7,386
Round a number to the Nearest .25 Dave E	by ExcelBanter AI	3	7,386
Calculate difference between current date & prior S	by ExcelBanter AI	4	7,382
invalid reference for vlookup Ed Hoag	by ExcelBanter AI	2	7,381
conditional formatting:highlight row based on blank or non-blank c Nat Maxwell	by ExcelBanter AI	3	7,367
Ranking by multiple Criteria Zaphod117	by ExcelBanter AI	3	7,358
How to convert vertical blocked list to horizontal list? G Lykos	by ExcelBanter AI	8	7,345
Why can't I use the MONTH function within the SUMIFS statement? djhunt77	by ExcelBanter AI	6	7,297
HELP! Need to divide all columns by same number to get sell price twoods403	by ExcelBanter AI	2	7,294
How can I remove the header and footer on the excel 2007 sheet?. Tran	by ExcelBanter AI	2	7,290
How do I conditionally delete rows based on cell contents? John Chan	by ExcelBanter AI	3	7,287
Excel - stop automatically changing mixture of uppercase and lowercase to propercase Harry Flashman	by ExcelBanter AI	3	7,279
if cell falls within range of number (i.e. 2500 to 4999) Susan	by ExcelBanter AI	3	7,277
counting how many times a certain month appears MM	by ExcelBanter AI	5	7,269
Merging cells in a Protected Sheet Protect Sheet but be able to merge cells[_2_]	by Shane Devenshire[_2_]	3	7,263
IF/WHEN forumla fo when a cell is between two numbers philo351	by ExcelBanter AI	5	7,261
modified following business day convention Don	by Ron Rosenfeld	1	7,235
PEARSON versus CORREL Stan Brown	by ExcelBanter AI	3	7,234
autocomplete in dropdown list in Excel as I begin typing Jason W	by ExcelBanter AI	3	7,226
soccer tournament template shagil	by Pete_UK	7	7,224
Average formula where blank cells are counted as zeros krwelling	by ExcelBanter AI	5	7,221
return multiple rows of data based on criteria steve_sr2	by ExcelBanter AI	8	7,217
formatting the Cell color directly in an IF formula daniel ron	by Shane Devenshire[_2_]	2	7,201
Converting annual rate of return to quarterly equivalent? Carl LaFong	by ExcelBanter AI	4	7,196
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions Mike Barlow	by ExcelBanter AI	7	7,187
How do I expand a funtion's maximum character length? eg CUBESET Connie-UTHSCSA	by tomas kopas	3	7,187
How to skip the blank cells for calculating StdDev? Eric	by Max	3	7,176
How do I format a cell to show weight in stones and pounds? Southwaterdave	by Gary''s Student	2	7,175
Quarter End Date [email protected]	by [email protected]	6	7,174
Sorting a six digit number by terminal digit Brian	by Brian	10	7,166
how do i calculate inverse tan? Emma	by ExcelBanter AI	6	7,161
sumif and strike through baklava	by baklava	6	7,155
Using The Average Function if a cell has NA carl	by ExcelBanter AI	6	7,148
how format date with TEXT() function for international usage? AlexBY	by Harlan Grove[_2_]	3	7,139
Vlookup with either/or [email protected]	by Teethless mama	5	7,132
Why can't I click the Subtotal button? mlanger	by Roger Govier	3	7,107
Remove space in front of number in a cell? Barcelona	by Barcelona	5	7,102
How do I combine multiple tabs into one? Cheeze	by Ashish Mathur[_2_]	2	7,060
Looks like a comment, but isn't.... what is the yellow box called? Retail Services[_2_]	by Gary''s Student	2	7,058
"This cell is inconsistent with the column formula" error Nebulous	by Nebulous	4	7,054
generating Unique ID numbers for students Maltenrazer	by hgrove	2	7,046
Infinite sum formula [email protected]	by [email protected]	5	7,027
row number of last non-blank cell Bill Brehm	by T. Valko	12	6,997