Excel Worksheet Functions - Page 49

Thread / Thread Starter	Last Post	Replies	Views
Vertical Growth Percentage? Arealtor12345	by JoeU2004	3	2,514
Weibull function in Excel Barbo	by Mike Middleton[_2_]	3	2,514
Adding hours and minutes Patrick	by David Biddulph[_2_]	16	2,514
Blank date column return datel 00-Jan-00 Frank Situmorang[_2_]	by Frank Situmorang[_2_]	4	2,513
Concatenate numbers and text while holding a custom number format. jpowell111	by Ashish Mathur[_2_]	9	2,512
How do I get a macro to be non worksheet specific? navel151	by Gord Dibben	6	2,512
First zero doesn't show up in zip code mail merge. DLencz	by Nick Hodge[_2_]	1	2,511
Using the Indirect.Ext function henryhbb	by Frank Kabel	1	2,511
Sin Function Data Analysis Matt	by Dana DeLouis	7	2,511
How do I get cell data in multiple Excel files into one summary fi 78degreesinHI	by Cbus	4	2,510
search with drop down list BigPig	by Debra Dalgleish	4	2,510
sumproduct between date range Looping through	by Don Guillett	14	2,510
creating drop down lists from source on another page Shaun	by Gord Dibben	7	2,509
How can I get my spreadsheets to open faster? Johnnie	by Johnnie	3	2,509
probability mass function jeroen van dijk	by Jerry W. Lewis	4	2,509
formula for multiple criteria inc. date range J.Scargill	by J.Scargill[_2_]	4	2,508
Merge 2 datasheets into single Pivot Table. free_ur_mind	by Eduardo	2	2,508
Nested IF Function, Date Comparing, and NetworkDays Function carl	by carl	2	2,508
How do I convert 8:30 to 8.5 hours? Gene Mah	by Gene Mah	2	2,507
Drop down list - color coding Sue	by Gord Dibben	1	2,507
Forced Distribution Mark	by hgrove	3	2,507
Sumif across workbook tabs tj	by Roger Govier	2	2,507
How delete to end of file; comp keeps adding rows; over 3000! whalesong	by Sheeloo	1	2,506
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet Aster	by Aster	3	2,506
lock cell based on a condition Amanda	by Gary''s Student	22	2,505
Sum formula of cells with specific color value MSOChick	by MSOChick	2	2,505
store inventory sheet(ex:sports equipment store) vardan	by PY & Associates	1	2,504
Return True/False to check duplicate items in a range with one for Tetsuya Oguma	by Epinn	10	2,504
How to assign unique number to column duplicates? Heather	by Heather	3	2,503
Formula Instead Of A Pivot Table Mike	by Mike	8	2,503
Excel - option to extend function in cell to column kjoshua777	by Gord Dibben	2	2,503
Can you use IF function in pivot tables? Steve	by Steve	2	2,503
Average If - averaging cells based on value of another cell Jarod	by Pete_UK	5	2,502
Using Indirect with an Index Match Function Mike[_16_]	by Mike[_18_]	3	2,502
COUNTIF with dates Lestergit	by Crusader	1	2,501
numbers in numerical order lost~dispatcher	by Gord Dibben	3	2,500
Return non-zero cells in column Greg	by Domenic	5	2,500
getting numbers divisible by 4 from random numbers in ascending order ramana	by T. Valko	6	2,500
Indirect and Sheet Name Rob	by Rob	4	2,499
Need to sum values of columns 1 - 13 and 4 - 15 ExcelHelp	by Frank Kabel	1	2,499
Adding text before a function Eric	by Ken Wright	1	2,499
CountIf function on combo-box entries Roxy	by Shane Devenshire[_2_]	4	2,499
COUNTIF....how to use =0 but <9 as CRITERIA Jay	by Jay	3	2,498
how to hide rows in a protected sheet Prakash	by JulieD	7	2,498
formula to calculate age using birth date and current date lalah	by Dave Peterson	2	2,498
Using Excel Solver or Goalseek on multiple Sheets in a Workbook au AlfredR	by AlfredR	2	2,498
using a toggle button to show or hide information in several cells hanson	by Gord Dibben	3	2,497
How do I search excel spreadsheets using multiple search criteria. Kasper	by Kasper	4	2,497
How do I remove the 1st 4 characters of a field in Excel? MFreeman	by CLR	8	2,497
excel divide by zero error Titanium	by Titanium	5	2,496
32 column limit in excel Form Harry S	by Debra Dalgleish	1	2,496
Combine sheets into one Eva	by GS[_6_]	17	2,495
COUNTIF cell reference won't work Kenny Newbry	by bj	4	2,495
How can I set up Excel to auto-sort each column independently? davisjw	by NoodNutt	2	2,494
Need Excel count of 1 word if found in multi-word cells of column Function_Challenged	by T. Valko	1	2,494
Conditional Formating if Greater Than or Less Than other column CClio333	by Suleman Peerzade[_2_]	2	2,494
How to enter symbols for subset or element of a subset in Excel? rwcita	by Chip Pearson	1	2,494
Excel 2003 - setting the Comment font size default rickz	by NickHK	3	2,493
"Custom" Data Validation leimst	by T. Valko	5	2,493
Can Sumproduct return Text values Richard	by Richard	8	2,492
weekday in pivot table yowzers	by Herbert Seidenberg	4	2,492
is there a template to create a sales tax chart? Momto1	by Shane Devenshire	1	2,490
change feet and inches to decimal inches Brian 1	by JoeU2004	4	2,490
rounding dates ellebelle	by Ron Rosenfeld	4	2,490
Max using Index/Match Help Exceller	by T. Valko	6	2,490
Easiest way to extract characters in a cell LEFT or RIGHT of a sym Training Goddess	by Niek Otten	2	2,489
Formula than understands midnight? Auric__	by Auric__	26	2,488
How do I use solver to find which cells add up to a certain amoun. Joe S	by Tushar Mehta	2	2,488
formula for linear regression DBane	by Ron Rosenfeld	14	2,488
Calculate a date based on a weeknumber brian martens	by Earl Kiosterud	2	2,488
Using "=randbetween" to select a number from a range of cells a0xbjzz	by Dana DeLouis	4	2,488
conditional formatting only applies to part of cell text klkropf	by [email protected]	12	2,488
count and return pair numbers Sly	by Rick Rothstein \(MVP - VB\)	14	2,487
Calculate eligibility/enrollment date PH@tic[_2_]	by JE McGimpsey	8	2,486
Creating a formula to populate information from multiple cells in another workbook Sullycanpara	by RagDyeR	8	2,485