Worksheet Functions - Page 501

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
MIN / MAX for specific value from other column by Steve Smallman A complete answer would involve coding a user defined function, and while relatively simple, may be confusing. Have a look at DMIN and DMAX and see if they...	December 6th, 2003 10:15 AM by Leo Heuser	1	119
Hiding Rows by Jeff Is there a way to conditionally hide rows based on a condition or value being met in the content of each row? Thank you.	December 5th, 2003 09:27 PM by drabbacs	1	246
Time Sheet calculations by John Tibbotts HELP NEEDED WITH TIMESHEET FUNCTIONS !!! I have not been able to get the attached Timesheet file to calculate the way it should 1. All time based equations...	December 7th, 2003 05:21 AM by Biff	1	530
PivotTable question by joone Is it possible to Click on "Refresh Data" on a Pivot Table if the sheet is protected? It is not letting me at this time and wondering if there's anything I can...	December 7th, 2003 08:42 AM by Nick Hodge	1	95
Keep pivotchart formatting when data is refreshed? by Pmxgs Hi! Is it possible to keep all the formatting in a pivotchart after i refresh the data. Although i check the preserve formatting option, every time i refresh...	December 7th, 2003 02:09 PM by Debra Dalgleish	1	241
Statistics, #N/A and dynamic range problem by Peo Sjoblom This should take care of it =MIN(IF(ISNUMBER(MyRange),MyRange)) =MAX(IF(ISNUMBER(MyRange),MyRange)) I assume that you want to include the N/A error as zero...	December 7th, 2003 08:36 PM by OscarC	1	502
Excel Formulas for date & time by Peo Sjoblom =(start_date_time-end_date_time)*24 will give you decimal hours if you format as general or numbers -- Regards, Peo Sjoblom	December 7th, 2003 11:31 PM by Bob Phillips	1	201
Unable to Sort Multiple Columns by Parallax Abstraction Good day all! I've seen this posted in a million other places, but I wasn't able to get my question fully answered. I'm creating a simple sheet to list...	December 8th, 2003 02:06 AM by John Wilson	1	393
Cannot merge cells, old spreadsheets, new Excel by Using Excel2002, having upgraded from Excel'97. Whenever I open up an old spreadsheet, the "merge cells" command is not accessible. It it grayed out on...	December 8th, 2003 08:16 AM by Bob Phillips	1	472
Multiple values in a single cell, and validation by Harlan Grove "=?Utf-8?B?SWx5YSBCYWltZXRvdg==?=" wrote... My worksheet represents a list of entities E1, anb each E1 can have multiple of other entities E2 associated...	December 5th, 2003 07:58 PM by Peo Sjoblom	1	939
Replace cell references by mikegospo Does anyone know how to change the range cell references in a group of cells. I have cells that are doing a count in a range from cell b2 through b129. I...	December 5th, 2003 07:40 PM by Peo Sjoblom	1	117
Inserting rows under specific types of data. by Dan I have a Bill Of Materials (BOM) represented in excel, each row representing a line in the BOM. The BOM is made up of assemblies, sub-assemblies and...	December 5th, 2003 09:55 PM by steve smallman	1	211
Excel links on network: sharing file off network by Vicki I am sharing with an outside company an excel file that has links to other excel files on our network. I need to send this file back and forth and keep the...	December 5th, 2003 09:47 PM by steve smallman	1	551
Show the product of a formula calculated in spreadsheet one in spreadsheet 2 by Ronnie I have built a formula into spreadsheet 1 and the product of that formula is always displayed in, say, D12 of spreadsheet 1. I need to be able to...	December 5th, 2003 02:20 AM by Vasant Nanavati	1	671
Copying Goal Seek and Solver into a Power Point presentation by Topa Can anyone help me with this?	December 5th, 2003 02:16 AM by Vasant Nanavati	1	559
Counting Cells With A Specific Color by [email protected] Dear Receiver, Can someone have a formula or can explain this one found on http://www.cpearson.com/excel/colors.htm =COUNTBYCOLOR(A1:A10,3,FALSE) to counting...	December 5th, 2003 03:37 PM by John Wilson	1	245
Expiration date for Workbook by John Wilson Laurie, A much asked question......... The answer is yes!!!.....Absolultely!!!!! But it won't work. Explanation...... The functionality to do what you want...	December 6th, 2003 11:21 AM by macropod	1	87
moving worksheets between files by Markathepub Hi, On a monthly basis I need to move a worksheet from say the November file to the December file. The worksheet has lots of references to other worksheets...	December 5th, 2003 06:46 PM by Peo Sjoblom	1	263
calling linest from VB application by mgoldman regarding the following code, can anyone tell me when i redim arrx to be any bigger than (3,10), why i get an error when i try to call linest on the two arrays...	December 6th, 2003 12:56 PM by Jerry W. Lewis	1	119
Array formula issue by Richard Fletcher I have the following in a macro :- Range("Y5").Select Selection.FormulaArray = _ "=SUM(IF(data!$c$2:$c$65000=""Sheffield"",data! $l$2:$l$65000,0))" When run...	December 8th, 2003 09:52 AM by Leo Heuser	1	123

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed