Threads Replies Last Post 837 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  >>   Combining two formulas using concatenate Here is the formula I've tried that isn't working: ­=concatenate(text(=$c$17-time(1,45,0),"hh:mm"),"­",text(=$c$17-time(1,15,0),"hh:mm")) Is it possible to put these two formulas together? Basically, I need the time to look like 07:15-07:45. These times pull off of cell C17. If C17 is changed this range of time needs to change. How do I program excel to do this? ... 4 21.09.2006 03:13:02 multiple conditions Hello, I'm working on a attendance and vacation worksheet. The fist tab is a summary of the other 4 tabs. This very similar to Micosofts tracking templete1.I'm having trouble with summing multiple worksheet with a if then statement. Here is what I have so far, =SUM('1st Q:4th Q'!F6). This works fine. I want to also include if the value is greater than 2 "verbal warning, grater than 3 "w... 5 21.09.2006 02:33:18 look up formula not returning data I have been working with vlookup tables for a while now but when I started a new one with some new date from another source, it stopped working. It will not return values that I ask it to lookup. The date is both numerical and text. I have sorted the date in ascending order. I have tried changing the data from number to text to general. Nothing seems to work. If I open another s... 6 20.09.2006 23:45:41 copy cell from above with opposite sign i have a column containing numbers, every other row there is an empty row, i would like to copy the cell from above with the opposite sign to that empty row, how can i do that with a formula or macro. So that i don't have to do that one by one. Thanks a lot.... 4 20.09.2006 23:23:19 Formula I am working on a spreadsheet that has a column where people will enter in the date they completed a class, then the next column has a formula in it to show them when they need to take the class again (Every 2 -3 years). If the completed column is blank, then I need the due next column blank, as well. But, if there is a date in the completed column, it will need to calculate the next dat... 3 20.09.2006 22:58:05 Format data in History Sheet in Excel I have a history sheet to track changes to an excel spreadsheet. It works fine except the date and time field are not formatted correctly. Of course when I try to change the format to make it read like a normal date and time it says the sheet is protected. Is there anyway to change the format on cells in the History sheet. Thanks, Bobbie ... 2 20.09.2006 22:52:15 Duplicate entries I have a large spreadsheet consisting of about 16,000 rows and 8 columns. The first columns are longitude and latitude coordinates. Is there a way to sort and display the rows where both the values in columns A and B are the same? I have sorted on A then B but sometimes places have exactly the same longitude but very different latitudes. I'm just trying to eliminate the necessity of going ... 4 20.09.2006 21:27:48 How do I center align a title at top of sheet. Could someone tell me how to center align a title at top of a worksheet. I've read the help instructions but it isn't working. I'm using Microsoft Office 2003. Thank you ... 2 20.09.2006 21:00:13 Data Validation I would liek to know, if theirs a way possible that with either Macro or other ways, to use a data validation that you can select witch team and player to enter data and that it has to add it each week? Thx you!... 1 20.09.2006 20:57:01 Lookup Formula? I'm trying to come up with a lookup formula for the following example: Column A Column B Row 1 22k b22kcw Row 2 23k bf23kc Row 3 32k b25kce Row 4 28k be32kw In Column C, I want a formula that looks at the value in A2, compares it to column B, and if it finds "22k" anywhere in one of the values, i... 6 20.09.2006 20:39:53 Birthday Calculations Hi All, I am looking for a formula to do the following. I have a cell that has a date in it. Example: 09/15/2006 I have a person I want to be specific age. Example: 12 years old I have the person's birth Month and Year: Example 12/31 I want to calculate the persons birthday as of the value of cell 1 (09/15/2006) using the specific age and birth Month and Year. In the example th... 2 20.09.2006 20:39:32 emailed content with InDesign or InCopy I work for a newspaper company and we use InDesign to do our layouts. Now when we are finished we simply copy and paste the text for each story to notepad and save it. then we upload to the web. We are now wanting to add a note in the Indesign layout with an email for the story link to be emailed to when we extract it. I want a way with little steps to make a txt document of the text in in... 1 20.09.2006 20:22:30 OK tough one ! I am trying to make dynamic ranges that change as a list changes the ranges fall in parts of the list. I use this custome function: Function Nth_Occurrence(range_look As Range, find_it As String, _ occurrence As Long, offset_row As Long, offset_col As Long) Dim lCount As Long Dim rFound As Range Set rFound = range_look.Cells(1, 1) For lCount = 1 To occurrence ... 5 20.09.2006 20:11:45 Keeping Text format I have a column of data that is in text format: ex: '0215 '6251 '5489 '2351 '6350 '5126 How can I reference this data in another cell while keeping the same format. For example: I am trying to extract all of the unique values in my column of data by using the formula I found on cpearson (=IF(COUNTIF($A$1:A1,A1)=1,A1,"")) This formula works great but the data that it r... 4 20.09.2006 20:08:02 How can I count a record if it contains a date within a date range This may not be possible given how the data is stored on the spreadsheet, but here it goes anyway: I do reporting based on capacity, so the first week of the month I can do x# of reports, 2nd week x#, etc. I have a very simplistic list I keep on a worksheet but as volume grows I find myself counting how many reports I have already booked in a given week to see if I can fit one more. ... 1 20.09.2006 19:58:02 excel hyperlink to stock page in my excel page, i have a stock portfolio. i would like to open this file daily and have the current stock quote appear without having to go to the web site. how can i link that cell to the current stock price.... 2 20.09.2006 19:53:03 - sign help how do i create a formula that copy the cell from above inserting a minus sign before the number? Thanks for your help... 5 20.09.2006 19:39:01 Recognizing Cell Formatting To Use In A Formula Or Conditional For Is there a function that can recognize cell formatting? For example, I use VLOOKUP to find the machine routings associated with certain part numbers (all in an array on a separate worksheet). To indicate that the part numbers on that worksheet have been re-checked to verify that the part routings are correct, I manually format the cell background to be light green (an arbitrary choice) e... 1 20.09.2006 19:28:02 Footer in XL How do I insert a footer on only the first page of an XL multi page document... 1 20.09.2006 19:20:01 Looking for Excel SS which calculates Mortgage Payment with PMI Does anyone have a spreadsheet which calculates Mortgage payment with PMI added into it. This would be based on the following information: Loan Amount Purchase Amount Term Interest Rate If you do, please let me know as I would be interested in receiving a copy as we are looking for house at the present time.... 1 20.09.2006 19:19:01 adding several worksheet cells onto a main worksheet Hello, I asked this question a few days ago and someone answered me and it worked but by looking at what I needed it seems to be more extensive than antisapated so I need assistance. Ok, I have a workbook with several worksheets in it, each worksheet is set up the same. I want to have a main worksheet that will draw totals from all my other worksheets. My worksheets are named by date and... 3 20.09.2006 19:07:02 Vlookup and Values When using vlookup - if the column is empty, I receive a value of "0" in some cells (I assume this is due to the type of data in the cell), but I would rather receive a "blank" cell. How do I modify the vlookup calculation to return a blank if the originating cell is blank? Thanks ... 2 20.09.2006 18:54:23 Can Excel Adress Envelopes? I do not be able to print out envelopes from my excel databace. Is it not able to be done? Or is there a way that I don't know about?... 2 20.09.2006 18:52:39 By selecting cells adjacent to cells tally sheet $6,980 x $11,880 $4,900 x By putting an "X" in a cell adjacent to a number in a different cell is there a way for a sheet to add up the cells chosen? Using the example above the sheet would total $11,880.... 3 20.09.2006 18:09:47 Inverse Table Lookup Excel Lookup functions normally return a Table value based on a row,column search criteria. I need to return the row, column based on the table value. Any ideas Appreciated, Thanks in Advance ... 5 20.09.2006 17:40:33 837 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  >>