General Discussion - Page 110 - OfficeFrustration

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
Can someone help with a formula to calculate dates? by SharonP. Can someone help with a formula to calculate ending dates? For example, I have a beginning date of 01/01/2006 and need to determine an ending date. I need to... ( 1 2)	August 9th, 2005 01:47 PM by Dave Peterson	11	384
pivot table sort entries that don't yet appear in table by rachael I have a pivot table that's accessing an ODBC data source. There's a field for career level in the table that's currently sorted alphabetically. I'd like to... ( 1 2)	September 19th, 2005 11:29 PM by Ron Coderre	11	593
Importing Text Data by mfx_krypt Ok, I have ran into a large problem that I can't figure out. We have a data machine that dumps a file at the end of the day with all the data it has recorded... ( 1 2)	September 27th, 2005 08:00 PM by mfx_krypt	11	171
in an excel macro can you import data from word into a cell? by Trefor I have several word documents being emailed to me containing tables. I would like to be able to import some of the data in the word table into a cell in my... ( 1 2)	October 6th, 2005 01:49 PM by Dave Peterson	11	552
Work Rota - Do I need a formula? by dataheadache Hi everyone. I'm new around here, so forgive me if this or something similar has been asked before (I would have done a search, but wasn't sure what to search... ( 1 2)	October 3rd, 2005 10:53 PM by Sandy Mann	11	323
How do I determine which numbers in a list equal a given sum? by infraterra I have list of dollar amounts given to me and a general ledger sum which some of those in the list must equal. How can I determine which of these amounts will... ( 1 2)	October 7th, 2005 11:39 PM by Ken Wright	11	153
date calculations by TUNGANA KURMA RAJU I am working on a personal worksheet.In cell A1 I put my Date of birth(1-NOV-1975) in ddmmmyyyy format.What formula I need to write to get(in B1 to B6) 1.What... ( 1 2)	October 11th, 2005 12:55 PM by Ron Rosenfeld	11	134
hyperlink email challenge by brendan I currently have a workbook that I use to build a new part within my business. It contains about 12 worksheets and each work sheet has 3 email hyperlinks... ( 1 2)	October 18th, 2005 09:08 AM by Ed Ferrero	11	266
Help...Need to modify data within a column in a .csv file by [email protected] I have been given a .csv file of several thousand rows, and I need to change column A of each. The brief cutout below shows column A of the first two rows. ... ( 1 2)	October 26th, 2005 11:23 PM by Ken Wright	11	143
EXCEL MISSION IMPOSSIBLE ? by hkappleorange I have a simple task on Excel but I cannot figure it out. Pls help:- I have 200 separate Excel files with data all in 3 columns: Region, Month & Amount. They... ( 1 2)	September 12th, 2005 07:19 PM by Arvi Laanemets	11	115
Array Functions by Jaytee Excel 2003. Trying to enter an INDEX function. I put in the proper formula (checked, and re-checked) Then, instead of simply hitting "enter, I... ( 1 2)	September 13th, 2005 12:03 AM by Harlan Grove	11	182
How do I say… by thomasstyron Hello All: I have this formula: =IF(C8C9C9C10C11C12C13C14C15=0,"",SUM(C8:C15)) How can I condense this group, C8C9C9C10C11C12C13C14C15, to... ( 1 2)	August 8th, 2005 10:02 PM by Dave Peterson	11	106
more than 3 conditions in conditional formatting - possible? by rob curtis Is it possible to have more than 3 conditions using conditional formatting? I am dealing with text and not numbers which makes it a little harder... ( 1 2)	August 17th, 2005 04:02 PM by JonnyCrabb	11	424
Average non-adjacent cells if the cell does not contain zero by Cheri I have a spread sheet with data in non-adjacent cells. I would like to average the data in the cells only if the cell does not contain a zero. How would I do... ( 1 2)	August 20th, 2005 08:12 AM by Biff	11	390
Extend formats and formulas by JRB Does anyone know why a running sum type of formula =SUM(B2,C1) does not automatically copy down? Similarly, I cannot get a fill colour to extend down when a... ( 1 2)	August 28th, 2005 08:21 PM by marisky23	11	279
Protected cells by Roy I have a sheet with protected cells. Everytime I re-open the file, the cells become unprotected. How do I stop the cells from becoming unprotected? ( 1 2)	August 25th, 2005 02:33 PM by Dave Peterson	11	189
The IF function by Emma How can i use the IF funvction to find the highest value, from a list of 19 values? ( 1 2)	August 25th, 2005 12:56 AM by Emma	11	143
Customer Quoting Database by mount_mordor Hello I have a quoting program in excel that I created, I use this program to quote customers for laser cutting. It is fairly basic, on the first page I input... ( 1 2)	September 6th, 2005 01:45 PM by mount_mordor	11	206
How do I continue this pattern in excel? by Greg K. It seems like a simple thing to do but I just can't continue this pattern in excel. I'm sure it's just copying and pasting but I'm stuck. Also each is a 4X4... ( 1 2)	September 5th, 2005 06:30 AM by Ragdyer	11	146
... I would like the Worksheet Tab Title to be in Cell A1 too... by Dr. Darrell Is there a function that links the text on the Worksheet Tab to a Cell? Darrell ( 1 2)	October 28th, 2005 02:47 PM by Dave Peterson	11	166

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