Worksheet Functions - Page 514

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
"300" notfound? by BrettM =INDEX(all!A1:K1338,MATCH("300",all!A1:A1338,0),11) is my formula but "numbers' such as "300" cannot be located? If I add a letter to the number (i.e. "300E")...	February 22nd, 2006 05:48 AM by JMB	2	71
INDEX then MATCH by BrettM =INDEX(all!A1:K1338,MATCH("300",all!A1:A1338,0),11) cannot locate "300" or any other "numbers" I may enter. This works fine if I add a letter (i.e. "300E") yet...	February 22nd, 2006 05:59 AM by Biff	1	80
Replace Comma with Dash by [email protected] Hello, Please can someone explain how I can replace commas with a dash/ hyphen. For example cell A1 contains "ABC,DEF,GHI". I would like cell B1 to display...	April 18th, 2008 10:26 AM by Rick Rothstein \(MVP - VB\)[_335_]	3	65
Replace Comma's with Dash by [email protected] Hello, Please could someone help me. In cell A1 of my spreadsheet I have "ABC,DEF,GHI". I would like B1 to contain the same data as A1 but with a dash...	April 18th, 2008 09:00 AM by Rick Rothstein \(MVP - VB\)[_333_]	2	79
Dates - Need to display date one month prior to user-entered date by brettopp I'm looking for a formula that displays the billing-month start date based on a user-entered end date. The system I will be using this calculation for... ( 1 2)	December 3rd, 2007 05:58 PM by brettopp	13	218
Calculating percentage of Shaded Cells in a row by BrettPotts I am trying to calculate the number of shaded cells v's none shaded cells in a row. There is no data in the cells only black shaded cells or uncoloured cells.	March 28th, 2008 09:33 AM by Gary''s Student	1	117
Capturing average turn around time with constraints by BrettS I currently have a spreadsheet tracking the performance of a purchasing group. There are 3 columns of interest to me in this formula. Column D is the...	June 17th, 2008 03:12 PM by BrettS	0	66
Multiple value lookups from a table to select & sum data from colu by brettster999 I have a task to analyze GPRS usage on a company's monthly cellular bill for each individual phone. There are many telephones in the fleet and the rawdata...	July 8th, 2008 12:32 AM by Max	6	141
Using Index and Match Formula by Brett[_4_] Hello, I am having a few issues using the Index and Match formula in Excel. For example I can get the Index and Match formula working if the data is layed out...	June 5th, 2009 02:39 PM by Brett[_4_]	2	112
Tabbing in Excel by bretye2 When I opena new document in Excel and I start in A1 and tab once I end up in M1. What is wrong?	March 15th, 2006 07:01 PM by Paul B	1	63
Counting rows based on the contents of multiple cells by Bret[_4_] Hello, We have a spreadsheet that is layed out something like this: 6 Collumns. Collumn A contains certain features of a software product. Collumn C...	August 11th, 2009 09:26 PM by T. Valko	2	97
Indirect(address...function help? by brewdon Hi there, This seems to be the group of which to ask questions since I'm a newbie to Excel intricate function! I'm trying to merge pivot table results from...	June 5th, 2008 07:32 PM by ryguy7272	1	78
Indirect function in Excel 2007 by brewdon Hi there, This seems to be the group of which to ask questions since I'm a newbie to Excel intricate formulas! I'm trying to merge pivot table results from 3...	June 4th, 2008 12:45 AM by brewdon	0	82
Dotted lines for projections in graph by Brewhill I've created a line graph that compares number of sales from '06, '07 and '08. For sales from June '08 until the end of the year, I'd like to show a dotted...	June 3rd, 2008 09:05 AM by Dave Curtis	1	123
range label works in VLOOKUP except if refenced in another cell by brewmaker I'm getting N/A message in VLOOKUP formula if I reference a range name in another cell. I setup the range name and formula correctly becuase it works when I...	January 23rd, 2009 03:08 AM by T. Valko	3	61
Updating master workbook from source that may/may not exist by [email protected] I am using Excel 2003 and have a master workbook that has many references (links) to various other workbooks that are in Excel 4.0 format. These source files... ( 1 2 3)	April 7th, 2005 03:37 PM by Dave Peterson	20	656
How can I display a loss or gain (currency) by brewster56 If I start with $1000 and lose $250, I would like to somehow indicate that the remainder ($750 in this case) was actually "down" from the original $1000....	November 26th, 2008 07:41 PM by David Biddulph	5	51
Calculating Dates by brewster56 I would like to have Excel add 7 days to a starting date and display that in a Date format. What I am doing is scheduling something every week on the same...	April 28th, 2009 06:57 PM by brewster56	4	79
Linking Between Worksheets by BrewsterGK Hello, I have a relatively large project that I am doing, so individually linking each cell is very inconvenient. I have one large worksheet with all the...	June 9th, 2008 04:35 PM by BrewsterGK	0	62
Copying Functions between Cells by BrewsterGK I want to copy a set of cells that have a function in them from one worksheet to another, how do I do this?	June 19th, 2008 05:34 PM by RagDyeR	1	77

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