Threads Replies Last Post 837 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Subtracting Hours Hi, I want to convert Israel time to U.S time. Every thing is going fine until the number become negative. For example: if the time in Israel is 02:30 and I want to find what is the time at New York I have to subtract 7:00 hours, and I Excel don't calculate it. Any help? Thanks, Amnon ... 2 30.09.2006 22:42:12 Excel needs to allow infinite rows and columns. At work I use some information sheets that use more rows than the 65,000 or what ever that Excel presently will allow. It would be very useful if you could have a more unlimitied number of rows to use. Has anyone experienced the need for this and if so how did you resolve the issue? Excel is a great application but that one limitation is frustrating. ---------------- This post is a sug... 1 30.09.2006 22:13:01 VLOOKUP function returning data from ranges I want to use a VLOOKUP function to find data in a table that includes ranges. Example: # of tables Cost per table 1 – 19 $50.00 20 – 39 $45.00 If I then type 26 in a cell, $45.00 would appear. I can then have a simple multiplication formula in the next cell to calculate total cost. -- ray... 5 30.09.2006 21:46:01 Formula to auto fill in following month. Much thanks, in advance, to anyone who can help me. :) Using Office 2003, I need a formula where the user enters a month for the current cycle in cell B2, and all subsequent month cells automatically fill in. So say the user enters April in B2, then B8 would automatically fill in as May, and B14 would fill in as June, and so forth. I also need it to display the full month name and not ... 1 30.09.2006 21:39:50 PRINTING I MADE A SPREAD SHEET TO TRACK JOBS THAT WE BID. I SET UP ALL THE FORMULAS SO ACCOMADATE 1500 JOBS. THE PROBLEM IS THATS 31 PAGES AND I DON'T WANT TO PRINT ALL OF THEM UNLESS THERE'S INFO ON THE PAGES IS THERE ANY SETTING OTHER THAN "SET PRINT AREA" SO IT WILL ONLY PRINT WHAT HAS INFORMATION ON IT ... 5 30.09.2006 21:38:01 Count and Sum data in same Pivot table I'm new to pivot tables. I wanted to have one pivot table column that counts the entries in a data column AND another pivot table column that sums the values of the same data column. Excel doesn't seem to let me put more than one copy of the column into the data section of the table. I can change it between count and sum, but i want to show both at the same time. Any ideas? Thanks. ... 7 30.09.2006 21:30:32 How do I run a regression on data that is not numerical? I am using Microsoft Excel 2003. I have been running regressions on numerical data and am curious to know how to run one if part of my data is non-numerical such as gender or race. ... 1 30.09.2006 20:43:01 Matching Multiple Columns I'm trying to create a Formula that will search within multiple columns and lineup by rows any data in the the columns that are a match. As an example data would be in four columns that do not have equal number of and the same exact content to start A B C 1234 7777 2424 8888 9999 1111 7777 2424 1234 2424 1234 7777 3333 4444 5555 After performing functio... 4 30.09.2006 20:38:01 Reverse NETWORKDAYS function? Hi: I know the NETWORKDAYS function will output the NET number of WORKDAYS between a given start and finish date, skipping a given list of holidays--but does anyone know if there's a way to input a start date, a number of days, and a list of holidays, and get the finish date--? For example, say I wish a task to start on 10/2, and I know it will take me 10 workdays. How would I find the f... 4 30.09.2006 20:34:09 Average Function and dynamic cell address I am sure this is an easy answer for some of you, but I am not sure how to do this...thanks for your help in advance. I have an average formula that I would like to dynamically change the number of rows it averages. For example if I have 25 cells of data, but the user only wants ten rows for their work. I would have them enter into a cell the number of points that want averaged and t... 3 30.09.2006 20:24:33 Day of the week Is there a formula or function that will tell me the day of the week associated with a date i enter in excel???... 6 30.09.2006 20:00:27 Trig functions I have been studing the early formation fo trig tables by Ptolemy abotu 100-200Ad. I now would like to know the methodolgy tht ecel uses for calculating these functions. I'm not interested in the detailed code, just the general methods. Can anyone help? -- rk koko pele... 4 30.09.2006 19:58:51 Search Column Data and Return Multiple Values across Row Hi All, I have two columns of data. Column "A" houses Numeric Labels and Column "B" houses Numeric Values. Data: Numeric Labels A20:A105 Numeric Values B20:B105 I would like to return across a Single Row all Numeric Lables that have a corresponding Numeric Value in Column "B" that is >=2 (greater than or equal to 2). Thanks, Sam -- Message posted via OfficeKB.com http:/... 4 30.09.2006 18:50:01 Something more than Conditional Formatting Hi, I have 7000 rows, 5 columns. I need to highlight the entire row if the value in column 5 is X conditional formatting is limited to 3. I may have more than 10 criterion. i.e. X, Y, Z, A, B, C, D, E, F, G, etc etc Please help. Thanks ... 11 30.09.2006 18:09:50 How can I set up names to automatically copy from a spreadsheet? I have a spreadsheet that has 42 tabs, 1 for each week. I want to be able to enter names on lines in the 1st tab and them automatically enter on the same corresponding line on each additional tab. Each tab contains the exact same spread sheet. Can this be done?... 3 30.09.2006 16:46:25 how do i get exact matches in a vlookup fomrula in my vlookup formula, I am finding values that shouldn't have values are returning the value for the closest match. ... 2 30.09.2006 14:01:01 EXCEL Books I am working with hugh spreadsheets ( 80+/- columns by 3000+/- rows), I have to take other workers spreadsheets and make a master copy. The other folks do not track their additions, deletions or updates to their spreadsheets. Hugh problem. I need a book or reference to tell me how to run or create formula's to do this. Any recommendations?... 2 30.09.2006 14:00:02 How to add previous sums in a column to current sums in a column? I'm trying to build a workbook from project plan that keeps a running total of actual hours. The only problem I'm having is with this summation question. Numerous employees are entering their weekly hours for the current week. How do I build a function that adds current weekly hours to the previous weekly hours in my Actual hours column? TD... 2 30.09.2006 13:55:01 how do i get exact matches in a vlookup fomrula in my vlookup formula, I am finding values that shouldn't have values are returning the value for the closest match. ... 4 30.09.2006 13:20:55 Hide rows Hi, I have a dropdown validation list. When I select an item from this list, the rows below will be populated using the HLOOKUP function. The HLOOKUP function brings the values from the other sheet. The records will be one to one thousand. And I have the formula upto 1000 rows. When item has just one value in it the other rows will have the value zero. I need to hide those rows which ha... 4 30.09.2006 12:55:15 Find value in array I am trying to do something that seems simple, but not sure how to do it... I want to have a table of text where the first column is a category and the adjacent cells in each row are the values for that category that users might want to find. The user types in a value, the function checks which category it is in and returns that value. Here is sample data; first value in row is category... 14 30.09.2006 12:32:26 Conditional formatting based on text within a formula I have several cells with formulas in them, and other cells have the same formula divided by 2. My real formulas are rather complex, i.e. Cell X6 is =INDEX(act!$A:$IR,MATCH($D6,act!$D:$D,0),MATCH(X$1,act!$1:$1,0))/2. So, here is a very simplified example: A B C row 1: =Sheet1!A1 =Sheet1!B1 =Sheet1!C1 row 2: =S... 9 30.09.2006 12:29:02 array formula does not work Hi, I have a range of numbers, say, b1:f100. I want to create an array formula, that delivers an array of maximums for each row. This I can easily do by, for example, {max(offset(b1, row(1:100)-1, 0,1,5))} If I put this array on a sheet, then I have correct max for each row. But if I want to select, for example, min of those max I change the formula to {min(max(offset(b1, row(... 1 30.09.2006 11:18:09 Range of Values Returns One Result Hello! I have a simple problem that probably requires a simple answer: I have a range of values in two columns and a third column that contains the value I want. The ranges NEVER overlap and are unique. For example: Row 1 (Columns A - C) have ICN000001, ICN000005, R45678 Row 2 (Columns A - C) have ICN000101, ICN000600, R01256 Row 3 (Columns A - C) have ICN001201, ICN003569, R85248... 3 30.09.2006 11:04:12 dependent drop down - repeat values In the Contextures example for ‘Data Validation -- Dependent Dropdowns from a Sorted List’ what if there were several people with the same name from different regions? Can you make a ‘NameList ‘ and refer to it the same way as ‘RegionList’ and still have the dropdowns be dependent? I have three columns of data where values are repeated in each. This results in multiple dro... 5 30.09.2006 08:02:45 837 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>