General Discussion - Page 451 - 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
Weekdays of the month. by Dean Am using Excel 2007 and I want to create a list of days of the week for a month as below I can convert the col 2 info based on Col 1. Any idea on a... ( 1 2)	August 1st, 2007 05:15 PM by T. Valko	17	218
How do I lock some fields but allow editing for others in excel by S.Sharif I am creating a form using excel at which certain fields of the form, editing is prohibited. Users then wont be able to change the locked values. Editing is...	December 13th, 2005 02:58 AM by JCM	1	218
Workbook fails to open - Excel 2003 by nc When I try to open a workbook, Excel launches but no workbook opens, not only the one I am trying to open but nothing. When I try to open a workbook that is...	February 2nd, 2006 06:33 PM by Anne Troy	1	218
Concatenating info from several cells into the one above by method373 Hey guys, I'm trying to pull info from a number of cells into one cell, the only thing is that the number of cells I'm referencing change, for example, one...	February 22nd, 2006 01:18 AM by daddylonglegs	1	218
How do I make a column equal a formula in Excel? by archllama I am an archaeology student and I am trying to make a catalog workbook for artifacts. We have the artifacts cataloged by bag number and FS#. What I have done...	April 11th, 2006 12:38 AM by John James	7	218
Preventing Duplicates by Ed I would like to apply Data Validation to entries in a cell to prevent duplicates, but the things is that this duplicate depends from 2 columns, for example I... ( 1 2)	June 1st, 2006 03:56 AM by Max	11	218
Find last instance of character in text by KonaAl Hi All, I need to be able to return an account number (7 digits) from a text string. The account number is preceded by a colon. I'm very familiar with... ( 1 2 3)	November 28th, 2006 06:59 PM by T. Valko	21	218
=INDEX(C3:N22,MATCH(G26,B3:B22),MATCH(H26,C2:N2)) by Dave F I just created this formula, and it works correctly, however I'm trying to understand WHY it works. As I understand it, INDEX can be used to find the value... ( 1 2)	January 10th, 2007 08:00 PM by Dave F	11	218
å¦‚ä½•åœ¨ Excel å¿«é€Ÿå–å¾—å·¥å…·? by Bain Using Excell It is so difficult to get necessary tools in compare with Excel 2003	July 10th, 2007 07:16 AM by Bain Using Excell	0	218
How do I set a cell value based on a formula in another cell? by dingy101 How do I set a cell value based on a formula in another cell? =IF(D4="P.B.A.",G8,0) ,This works to set the value in the cell the formula is in, say cell...	November 21st, 2005 08:51 AM by Bryan Hessey	1	218
Copy Data From Filled to Empty Cells by Sheikh Saadi Hi All, I am facing a problem. I have a long list of values having multiple columns. There is a column which is used for the persons name who deals with...	November 10th, 2005 07:21 PM by Sheikh Saadi	0	218
Copy tabs(sheets) from workbook without link to original source by Rich Ulichny I want to be able to copy tabs from workbook to workbook. However, when I right-click..'choose Move or Copy' and copy the tab into a new workbook, the formula...	August 25th, 2005 02:11 AM by ShelbyMan	3	218
change the defualt settings for comment boxes by Rick how do you change the default settings for the comment boxes in excel	August 23rd, 2005 08:48 PM by David McRitchie	1	218
How do I prevent Excel from auto-correcting the date format? by Watts I am using Excel, and every time I enter 2/1 in the spreadsheet - it corrects it to Feb-1. How do I prevent it from doing this?	September 15th, 2005 02:08 PM by Dave Peterson	2	218
Mailing List In Excel by [email protected] I have a customer that wants compile his own mailing list. Since he has excel and my mailing software imports excel files, it seems like I should have him put...	October 18th, 2005 09:29 PM by David McRitchie	3	218
Where is the Template Wizard with Data Tracking Excel 2003? by mnm_nut WOW...thanks... after downgrading 4 machines to MS-2000 so we could continue using this template you gave me a way out.... works like a charm... I'll ask you...	December 7th, 2005 06:50 PM by MTD	2	218
Excel nested IF formula question by [email protected] I have a question regarding Nested If statements in Excel 2003. I have a commission structure below that needs to be nested 0-$50K = 10% 50-100K = 20% 100-150K...	November 10th, 2005 05:11 PM by RagDyeR	6	218
General Functions by Lynxbci3 Can you write functions that will be available for whatever worksheet you happen to open. We have a date format from our AS/400 system and it gives us a...	July 30th, 2004 04:06 AM by Jim May	8	217
Dropdown List by Surf How do I create a dropdown list in a cel?? Thanks	June 30th, 2004 12:08 AM by RagDyer	1	217
Selecting or deleting data by Joey Hi all Is it possible to have a formula which recognises whether to select or delete data. Eg; A1 = xxx A2 = yyy A3 = zzz	June 16th, 2004 03:43 PM by Frank Kabel	5	217

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