Threads Replies Last Post 837 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>   How can I add functions in excel templates (XLT) Hi, I need to add functions/conditions to my excel templates. For example, check if it alphanumeric, length of the field etc. I would appreciate if someone can direct me to some link or suggest steps. Thanks in advance. ... 1 18.09.2006 18:46:13 How can I hyperlink from an excel cell to a page in a pdf document How can I hyperlink from an excel cell to a page in a pdf document? I know how to link to the pdf file, but I want to link to a specific page in the file. -- Mary Using Office 2003 and Windows XP Pro... 1 18.09.2006 18:27:01 Color Code Date Rows I have a call back sheet that has call back dates and I would like to color code the rows that I need to call back today to blue, prior to today red and after today to gray. I think it would be under conditional formatting but I haven't successfully figured it out yet. Thanks!... 2 18.09.2006 18:19:38 how do I get rid of blue asterick in create list? I am trying to formate my worksheet but somehow I have one column with a blue astrick and I can not get rid of it.... 4 18.09.2006 18:14:32 How do I use 3 separate column qualifiers to sum? IF statements? I am trying use 3 columns, from another tab, as qualifiers to obtain sum. Example, look at column A for all 1s, look at column B for all the "0"s and look column C for all the "1"s. From those qualifiers, obtain a sum. I have tried to use a "Sum" statement with IF embedded in the formula, but I get the message "too many arguments for this function. I would appreciate if anybody can he... 2 18.09.2006 17:55:01 ted_IFs A1 = Original Planned Due Date B1 = Revised Planned Due Date C1 = Actual Due Date I’m trying to write a formula that computes the following: 1) If dates exist in cells B1 AND C1, calculate delivery performance (i.e., Eary, On-time, or Late) in cell D1 ELSE 2) If dates exist in cells A1 AND C1, calculate delivery performance in cell D1 ELSE 3) If there are no dates in ((A1... 8 18.09.2006 17:53:02 Lookup on two criteria Dear all I would like to create a lookup or index that finds a particular entry by column and row. This is my data part number month1 month2 month3 month4 123 10 20 30 40 456 50 60 70 80 On another sheet I have two selection cells, I have selected part number 123 and ... 5 18.09.2006 17:24:01 How to convert Arabic number to english text (63 to SIXTY THREE) is there any function that i can us eto convert Arabic number to english text format (63 to SIXTY THREE). Thanks in advance for valid suggestions... 4 18.09.2006 17:16:38 How do you subtract time as in a timecard to calculate hours work Is there a template out there that calculates time for hours worked.... 3 18.09.2006 16:58:18 Caluclation of depreciation Col 1 Col 2 Col3 Col4 Col6 Col7 Col8 and so on 20 yrs 01-Dec-06 01-Jan-07 01-Feb-07 31-Dec-06 31-Jan-07 30-Apr-07 No of months 1 1 3 ________________________________________ {} ... 4 18.09.2006 16:55:07 how do i profile a survey? how do i profile a survey from a excel database?... 2 18.09.2006 16:54:54 add cells in several worksheets I have a excell file that has several worksheets and on each worksheet it has several employees names and %'s. Is there some way I can have a worksheet at the end or beginging of all the others and have it total %'s from the other worksheets? Lets say I want to total a row A1 to L1 from the other worksheets and it gives me a total % from the % numbers in the rows on each worksheet. Tha... 2 18.09.2006 16:40:17 Re: Formula and or data entry into cell? Guru's: This is a tricky one! Is it possible to have a calculation formula in a cell or set/range of cells if one condition exists and allow for data entry if needed and still have the calculation take place against the entered data under other conditions? Say, cell F5 - Q5 are calculated formulas based on a value entered in cell E5, but under other conditions, I'd like to either ad... 4 18.09.2006 15:46:53 select detail in column B if column A = date I and trying to create a separate cover sheet for a monthly worksheet that includes daily info by line. The dates are found in column "A" and the related daily info is stored on the same line. My question is, how can I bring the related info for either the last daily info added, or if the entered date for the report matches the date in column "A" from the worksheet. (i.e. "A1" = 9/1/0... 1 18.09.2006 15:46:02 special formatting? i have a cell i wish to fill in from selections in various other cells and i cant quite get it to work a1 = the date 10/1/6 a2 = month(a1) this shows in a cell as 10 a3=day(a1) this shows in a cell as 1 (unless i put special format of '00', then itll show as 01) a4=year(a1) this shows in a cell as 2006 if the formatting is text a5=QI... 4 18.09.2006 15:31:13 formula {=TABLE(G13;)} I found the formula {=TABLE(G13;)} in a worksheet, and I would like to know its function. I've checked in Visual Basic and did not find any macro under that name...... 3 18.09.2006 15:21:07 Selecting the correct number from a range of cells Hi - hope someone can help with this. I'm creating an order form in Excel, and would like to have a discount schedule built in - the higher the list price, the higher the discount. In my order totals section at the bottom of the page, I have a cell for List Price, a cell for Discount, and a cell for Net Price. Further over to the right I have the discount ranges entered into separate cel... 5 18.09.2006 15:04:02 Picture Disappear in MS Excel I'm using MS Excel 2003 SP2. I've inserted pictures using the Insert / Images / From File option. My pictures disappear when I scroll and the picture is scrolled off the visible section of the screen and then back on. They also disappear when I resize the cell. I've tried to change the Picture Properties by right-clicking on the picture / format picture / properties tab / Move and size wit... 1 18.09.2006 14:51:31 Conditional Formatting Rows of data from two sources have been combined and sorted on one worksheet. To identify the source of the data, the rows are 'flagged' with the acromyns "ign" or "leg". The only reason they are appearing on this report is that there is/are cell(s) of data that have been incorrectly entered in one of the two records. In this worksheet, I need to find and highlight the following: 1) ... 1 18.09.2006 13:51:02 looking for assorted statistical excel templets I am taking a statistical class and would like to have a myriad of templates for calculation purposes. Would appreciate if anyone could assist..... 2 18.09.2006 12:48:02 what is a coupon rate and ytm of a bond? ... 3 18.09.2006 12:44:02 Isolating mailadresses Hi Into a spreadsheet I have copied an adress list, where names, mailadresses and phonenumbers are on one line. I imagine I could use an IF function and say something like, if the word had @ in it, then isolate it into the next row, and if the "word" contains numbers then isolate it to row 3. Is that possible, and if then how. Thanks -- Therese... 2 18.09.2006 11:15:32 Data validation Hi, In Excel 2000, I am using an Input box for the users to enter some data. However, my cell also has data validation on it. However when i enter data via the input box, the data validation doesn't seem to work - is this right, and is there a way round this? Thanks ... 2 18.09.2006 10:26:38 Sum in Autofilter Hi New to Excel 2000 i have a worksheet in which i have 1500 rows of data. In Row 2 I want to add a function which will give me the sum of column G irrespective of how many additional rows are added - i cant seem to get the syntax right. Can someone help me please Also If I then add an autofilter to filter based on data in another column, I need to the sum above to relefect the sum of... 2 18.09.2006 10:22:49 Is it possible? I have a workbook with several tabs. The top tab is the main spreadsheet were I enter all my gathered data. The other tabs are the same spreadsheet, the same data, but broken out by specific building. Right now, I enter the data (alpha and numeric) into the main spreadsheet, then manually copy/paste it to the respective sub-level spreadsheet. I can specify the "IF" part of the line i... 25 18.09.2006 10:21:02 837 Pages: <<  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  >>