Worksheet Functions - Page 658

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
SCREEN NOT UPDATING by ub Hi I have a listbox in my sheet and a comadbutton that runs a macro. I select a name from the list and click on command button. I have...	March 18th, 2009 11:52 AM by ub	2	370
refer cell value of another workbbok in formulae by Abhay Hello! Indirect() function requires that workbook being referred in formulae should be open. I would like to change reference in formulae without opening...	March 18th, 2009 11:22 AM by Domenic[_2_]	1	77
Making COUNTIF update in real time by Bishop How do I make countif update in real time? For example, in column A1 I have this formula: =COUNTIF(A2:A5,"F") in cells A2:A5 I have F P f	March 18th, 2009 10:03 AM by Michael.Tarnowski	4	85
how can I convert numberic value to text in english? by Function New User I have try the different function to convert number to text. But still unsuccessful. Even though I'm using the BAHTTEXT and TEXT(value, format_text). Maybe...	March 18th, 2009 09:32 AM by Stefi	2	50
Refer cell value as part of formula by Abhay Hello!, I have to consolidate data from various excel workbooks. Each workbook is have name of employee for whom info is in worksheet. To summarise I wish to...	March 18th, 2009 08:48 AM by Stefi	1	60
Median by groups by freefighter My question is about median calculation. If there is a simple list of data, its easy to do. But when we want to calculate median of a variable for one or two...	March 18th, 2009 08:46 AM by freefighter	0	44
Max to min for dates by Ashish Mathur[_2_] Hi, In a separate column use the formula A2&C2 and copy down. Now sort on this new column (in ascending order). -- Regards, Ashish Mathur Microsoft Excel...	March 18th, 2009 07:33 AM by Bernd P	1	80
command line options/switches to print excel file by Stranger[_2_] I need command line options/switches to print the excel file on printer. Like C:\ excel.exe C:\abc.xls /print or C:\ excel.exe -print C:\abc.xls I'm able...	March 18th, 2009 06:36 AM by Stranger[_2_]	2	67
vlook up where one column has a range of numbers by travos one spreadsheet has a column with a range of numbers - ie. 1 - 10 representing member cards printed for a particular club name. what I would like to do is...	March 18th, 2009 04:41 AM by T. Valko	1	52
Indirect with index and match by Kashyap Hi, I have the below formula where it flech data from sheet as per C5.. In this case it is...	March 18th, 2009 04:24 AM by T. Valko	2	61
Using the results of the ADDRESS formula in another formula by JP Using the ADDRESS formula, cell B1 evaluates to A10. Using the ADDRESS formula, cell B2 evaluates to A20. I am trying to enter the MAX formula in cell C1 that...	March 18th, 2009 03:05 AM by T. Valko	4	217
Nested If Statements by Sarah_Lecturer Hi I am trying to create the following formulae =IF(G7=0,"Current",IF(G70,"Overdue",IF(G7=-3,"Reminder","Available"))) Unfortunately G7 contains an if...	March 18th, 2009 02:53 AM by Ashish Mathur[_2_]	5	119
Modify search function by Ashish Mathur[_2_] Hi, Use this...	March 18th, 2009 02:26 AM by Ashish Mathur[_2_]	0	44
Excel Formula to evaluate multiple criteria (countif + and) by VPSales I am trying to evaluate a data base of customers where column A lists the customers by name, column B is annualized sales $, and column C is the manhours of...	March 18th, 2009 02:05 AM by Ashish Mathur[_2_]	2	54
Count text within numbers by LiAD Hi, Is it possible to count how many times a letters appears in a text string. Example 1 234 N8 0,4xF9 I would like a formula that gives me the result of...	March 18th, 2009 02:00 AM by Ashish Mathur[_2_]	5	46
sumproduct formula work around by Chris Is there any way to replicate this formula with countif or sumif and not using the array (ctr shift enter) function? =SUMPRODUCT((A19:A357=A7)*(Y19:Y357=1)) ( 1 2)	March 18th, 2009 01:29 AM by T. Valko	11	104
excel 2003 by Quandary In all excel files, I can not get either Cell format, or Conditional format to change cell colour. The dropdown Format window allows the formats whether it...	March 18th, 2009 12:20 AM by Gord Dibben	1	43
Eliminating #DIV/O! by MCheru I have this formula =SUM(AVERAGE(N4:N200)). Right now #DIV/O! appears if N4:N200 does not have any data to report. Is it possible to modify this formula so...	March 18th, 2009 12:06 AM by MCheru	8	48
ogh, why is this not working by Sheeloo[_4_] See http://www.contextures.com/xlFunctions03.html#IndexMatch4 for a solution... " wrote: ...	March 17th, 2009 11:50 PM by Sheeloo[_4_]	0	95
sot data by daniel I want sort data by zip code on my spreadsheet dew	March 17th, 2009 11:21 PM by Gord Dibben	2	44

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