Worksheet Functions - Page 107

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
Adding a second formatting condition. by bollard In my spreadhseet, I have today's date in cell A1 using today() In Column C, I want cells to show up red if the date in the cell is over 14 days ago. I've...	August 21st, 2008 10:24 AM by bollard	2	66
Adding a Single Cell total from Seperate sheets by GccTxs I am putting together a Workbook that tracks the performance of my sales team. The work book has a seperate sheet for each salesman. Each sheet has a column...	October 3rd, 2005 11:57 AM by Max	3	152
Adding a sort to a working query asks for a parameter value by BRob[_2_] The following query works fine : SELECT . AS Old, . AS New, - AS Diff FROM ; However, if I add a descending sort to the last column and then run the query,...	July 23rd, 2008 10:28 AM by BRob[_2_]	0	74
Adding a space by eddie57 I have a sentence in field A1 and a number in field A2. The formula I am using is =A1 & A2. This is working but there is no space in between A1 and A2. How...	August 6th, 2007 09:09 PM by eddie57	4	62
Adding a space in text by MB Hello experts, A previous employee created a spreadsheet whereas in Column A are employee names as follows: Doe,John Is there a formula that would add a...	May 19th, 2006 07:15 PM by CarlosAntenna	6	117
adding a space to a text string by [email protected] I am attempting to add a space to a text string in multiple cells. Please see example below: The text string I have is: ROJ123456/1R1A The result I want...	February 19th, 2004 05:06 PM by Kent	1	209
Adding a space with =A59&B59 by Jim Hi, How do I add a space when merging two cells? I would like the space to be between the two cells being merged. Thanks	May 17th, 2005 12:37 AM by JE McGimpsey	1	86
Adding a statement to several documents by Newbee I am the owner of a share drive which is posted to a web paige. I need to ad a few statements on all of the thousands of documents we have posted. Is there...	March 17th, 2008 04:41 PM by Newbee	2	68
adding a symbol by GEORGE we have docs open. i created a worksheet which is shared by our network. the symbol option is greyed out. we need to use the checkmark symbol. however, if i...	August 19th, 2004 08:50 AM by	2	438
adding a toolbar function to an excel cell by Colin Hayes Hi I'm trying to run a toolbar function (Refresh All) , from cell M20. I'd rather do this than have it placed on the toolbar. Is it possible to do...	January 13th, 2010 12:28 AM by Gord Dibben	5	112
Adding a unique identifier to a column of data by Holly[_2_] I have a spreadsheet of data I exported from a Loutus Notes folder that unfortunately I can only get in this format: First: Fred Last: Flintstone Title:...	December 9th, 2007 07:01 PM by T. Valko	2	113
Adding a value to a customer ID? by Anne Hello! I have a case number for a patient. 2009-001, for example, in C2. I also have a contact number for the patient's family member, in D2. How can I combine...	April 15th, 2010 01:43 PM by Bernard Liengme	4	176
Adding a variable into a range declaration by Malvaro[_2_] Here is my defined variable: Dim RowCount As Long, myRange As Range Set myRange = Columns("A:A") RowCount = Application.WorksheetFunction.CountA(myRange) I...	June 24th, 2008 06:28 PM by Malvaro[_4_]	2	86
Adding a yearly calendar to excel spreadsheet by Sharon I currently have a spreadsheet that I am using in excel. I would like to add another 'worksheet' to this-- I want to add a yearly calendar, showing only one...	January 11th, 2008 04:31 PM by Sharon	2	140
adding a zero in front of a colon by 303mike Hello, I am importing data into a worksheet (Excel 2002 SP3) that is minutes and seconds. If the data is for one minute 27 seconds, it imports as 1:27. If it...	June 25th, 2009 07:30 AM by Per Jessen	5	92
Adding a zero to the front of numbers by Connie Martin I have a column of numbers, over 800 rows. Some numbers are 7 digits and some are 6 digits. I need a zero at the beginning of all the numbers with 6...	May 8th, 2009 04:37 PM by Connie Martin	5	112
adding accross sheets in a workbook by Todd Hi, I am adding accross sheets in a workbook with SUM('Start!:End!'!G51) and need a way to calculate the average of the result. The number of sheets change...	December 22nd, 2005 09:38 PM by Peo Sjoblom	3	122
Adding Across WorkSheets by computerangel Please help! I have 600 cases worked on from May through July- there were duplicates listed too. I need to figure out how many unique cases were worked on...	July 8th, 2008 06:08 PM by computerangel	0	75
adding actual numbers in columns by geb I am making a payroll spreadsheet. Gross wages times 6.2% and Gross Wage *1.45%, then want to take G wage and subtract the numbers from the calculated...	October 23rd, 2009 04:51 PM by T. Valko	3	110
adding amounts according to labels by Wayne Cameron I have labels in col D (multiple lines but only 7 different labels). I wish to add the cells in col E into 7 seperate totals (according to label). This is the...	October 28th, 2005 01:16 AM by RagDyer	1	98

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