Worksheet Functions - Page 707

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
How to SUM for indeterminate number of rows? by MrNobody I have a column of numbers starting at cell B3. The number of rows is not fixed - it changes. How do I write one SUM function to sum everything from B3 to...	February 20th, 2009 08:17 AM by David Biddulph	5	82
how do i make a dobble bar graph by sabrin i need it for my project	February 20th, 2009 07:05 AM by Ron@Buy	1	162
Linking value of cell on one worksheet to a column on another work by Dave I have a spreadsheet where I have two worksheets. On the first worksheet (intended to be an index sheet), I have a list of numbers (about 30) and text. On...	February 20th, 2009 05:57 AM by Christoffer Bloch Andersen	1	83
Sorting by kimberlyd. I currently receive a report with tons of information I do not need. I would like to sort by column D (commodity) then by column B (customer number). I get...	February 20th, 2009 05:54 AM by Herbert Seidenberg	1	166
Too many characters in formula? by Sandy Excel 2003 I have a series of rows with conditional formatting and I am trying to prevent the formatting from being altered if the rows are copied. The...	February 20th, 2009 04:35 AM by T. Valko	1	75
count cells, then reset count when value in another cell changes by Mitchell_Collen via OfficeKB.com I am trying to create a function that will assign number for TaskID. It will restart a count everytime there is a '0' in the Step column. This will be used for...	February 20th, 2009 04:22 AM by Teethless mama	4	120
Linking worksheets by Blackstone63 Hi I am pretty new to excel. I am trying to link information between worksheets. I have a master sheet with costing information and subsequent sheets with...	February 20th, 2009 01:54 AM by Blackstone63	2	64
Formula to a sheet name that is text in another cell by lauren_marie Is it possible to change the formula below so that the worksheet being referenced is dependent on another cell? =VLOOKUP($C$4,'Sheet...	February 20th, 2009 01:02 AM by Pete_UK	1	66
How can run a macro ( call a macro) on selection of any filtercriteria? by [email protected] Hi How can run a macro ( call a macro) on selection of any filter criteria? I have autofilter set and now I wanna call macro on changing my autofilter? how...	February 20th, 2009 12:34 AM by CurlyDave	7	115
HOW TO FIND A LAST NAME IN COLUMN OF LAST NAMES? by DANIELABAIR	February 20th, 2009 12:00 AM by Ashish Mathur[_2_]	3	126
Formatting a cell to print or not to print by lob[_2_] I want to use the same price list for 2 customers. But, they expect to receive a price list with only their name on it. How do I format the cells so that I...	February 19th, 2009 10:57 PM by Pete_UK	1	63
Nested if statement or Nested if OR statement by CD27 Hello, Trying to figure out how to do the below...I have 3 columns and in column D i need to be able to input a text. So, If cell A2 has a 1 or 2 AND cell B2...	February 19th, 2009 10:47 PM by CD27	6	78
how do i insert roman numberals in the middle of a sentence by kay how do i insert roman numberals in the middle of a sentence, for instance - project # iv	February 19th, 2009 10:02 PM by T. Valko	1	83
11 digits by Matt I am using a cordless scanner to scan barcodes into Excel. The barcodes have 12 digits but my Point Of Sale system only reads the first 11. To import this...	February 19th, 2009 10:01 PM by John	3	53
Currency formula by nishkrish I have a currency column when i put formula it shows error #Name formula i have is =if(e2=INR,"INDIA","OTHERS") sir can you please help me -- Nisha P	February 19th, 2009 09:14 PM by Niek Otten	7	74
Can Sumproduct return Text values by Richard Can sumproduct be used to return cell content? If so, does anybody have a sample that will requirte two conditions to be met. Thanks,	February 19th, 2009 09:12 PM by Richard	8	62
Worksheet(s) open to last used row by PapaBear Greetings, I have a workbook with 50+ worksheets in it. Each day when I launch my workbook I have to scroll down to the last few visible rows to be able to...	February 19th, 2009 09:04 PM by Mike H	5	101
Year or ROI by caroline hello, I am doing a cash flow and NPV calculation. so far so good.... However I also want to find out the year of my return of investment (i.e. when the cash...	February 19th, 2009 07:31 PM by joeu2004	8	66
Copying Conditional formating in a List of text and values. by Iraj I have a list of text and values i.e. A5:M5 and 200 rows beneath. I highlighted A5:M5CFNew ruleUse a formula to determine which cells to format... ( 1 2)	February 19th, 2009 07:25 PM by David Biddulph	15	129
How do I set up a multiple condition formula? by JoeAPM I have 12 different conditions where I need to assign a number: If E6 36.9, then the number is 0 If E6 =37 and =37.49 then number is 0.25 If E6 =37.5 and...	February 19th, 2009 07:23 PM by David Biddulph	4	59

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