Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mathias1979

    Analysis ToolPak crashes Excel

    I can reference other tabs just fine in normal operations...its just additional computations in the Analysis Toolpak (i.e. correlations, histograms, ect) that are causing a problem, even though I was using them just fine yesterday. As I said, already tried unloading and reloading the add-in...
  2. mathias1979

    Analysis ToolPak crashes Excel

    Using Excel 2003. Was using the Data Analysis Histogram tool in the Analysis ToolPak add-in just yetserday with absolutely no problems. Today, when I try creating a Histogram, Excel is crashing when I attempt to reference a tab other than the one that's currently active when selecting Input...
  3. mathias1979

    Excel 2003: Automatically Changing Reference Cells for a Sum?

    Skip, Thanks for the additional input! I will give it some thought.
  4. mathias1979

    Excel 2003: Automatically Changing Reference Cells for a Sum?

    Alright, I just answered my own question. I didn't realize you could use the OFFSET function within another function. So I knew you could do SUM(OFFSET(A2:A9,2,0)), but didn't realize you could also do SUM($A$2:OFFSET(A9,2,0)). So I see I can just use a variation of the formulat in my second...
  5. mathias1979

    Excel 2003: Automatically Changing Reference Cells for a Sum?

    Follow up... In addition to a cumulative average, I'm also doing a average of the prior 12 months. For the prior 6 months I realized I can just use the offset function as so: OFFSET(SUMPRODUCT($A$2:$A$7,$B$2:$B$7),ROW(A10)-8,0)/OFFSET(SUM($B$2:$B$7),ROW(A10)-8,0) This will offset my initial...
  6. mathias1979

    Excel 2003: Automatically Changing Reference Cells for a Sum?

    I'm basically doing a time weighted average of a monthly variable...using a formula like: SUMPRODUCT(A2:A9,B2:B9)/SUM(B2:B9) where column A has my monthly averages, and column B is the number of days in each month. The spreadsheet gets added to each month, and I'm trying to automate it so...
  7. mathias1979

    Excel: Searching dates using VLOOKUP

    Yes I did autofill, and that does look like it was the problem. I truncated to 6 places (5 wasn't quite enough precision) and that solved the problem. Thanks for the help guys...that was driving me crazy!
  8. mathias1979

    Excel: Searching dates using VLOOKUP

    But like I said, the serial numbers match EXACTLY out to 30 decimal places. I must be doing something wrong here.
  9. mathias1979

    Excel: Searching dates using VLOOKUP

    In my data, there are some dates that are not in the lookup table, so I would expect the #N/A error. I am experiencing the problem even when the date does exist. So in my sample dates, for instance, 9/1/2007 14:00 returns a #N/A, even though it clearly exists. And I the F9 update does not...
  10. mathias1979

    Excel: Searching dates using VLOOKUP

    I'm attempting to use the VLOOKUP function to look up dates, which I've successfully done before. This time around, VLOOKUP does not seem to be finding the dates I'm looking for, even though they exist and are an exact match. So here's a sample. So my dates look like this: Date/Time...
  11. mathias1979

    VLOOKUP won't return desired value

    actually, yogia's solution of adding '0' for the fourth argument works. I didn't even think to try it because I didn't think it was needed in this case, and all my other lookup values were working fine. thanks for the help guys!
  12. mathias1979

    VLOOKUP won't return desired value

    Ok, so I have a lookup table that looks something like this: Month, 1, 2, 3,... Altona, 35, 49, 52,... Bliss, 21, 37, 47,... ... My function looks like this: VLOOKUP("Altona",A1:D4,4) So the value returned should be '52'...but I get #N/A. However, if "Bliss" is the lookup value, the formula...
  13. mathias1979

    Windows Does not Remember my Dual Monitor Setup

    I have a dual monitor display...I have my laptop (primary monitor) on the right, with my additional monitor on the left. Problem is, everytime I boot up my computer, the setup reverts to my laptop on the left, with the attached monitor on the right...so I have to go into my display properties...
  14. mathias1979

    Skipping Empty Cells When Plotting

    yes, NA() gets the job done...thanks guys! huge help!
  15. mathias1979

    Skipping Empty Cells When Plotting

    xlhelp...that doesn't solve the problem. The problem is that for Excel to completely skip the points on a graph, the cell seems to have to be truely empty. Excel treats a blank (""), #N/A, or #DIV/0 as zeros when plotting. Skip...can you elaborate any more on how VBA can solve my problem?
  16. mathias1979

    Skipping Empty Cells When Plotting

    I know I can go to chart options and select to skip empty cells when plotting a graph. The problem is, the way I've programmed my spreadsheet, the cells aren't technically empty. I am averaging groups of cells to create my time series. When there is missing data for a certain time period...
  17. mathias1979

    Excel: Getting Date Formats to Match

    I believe I have solved the problem. After converting my date text string to a value, I had to the copy those dates using paste special to paste on the values, not the formulas. Still, thanks for the input!
  18. mathias1979

    Excel: Getting Date Formats to Match

    unfortunately I have no choice but to use strings to create the dates...there are simply too many to do it manually, and the increments between dates/times is variable, so simply using the TIME function to increment the dates is not an option.
  19. mathias1979

    Excel: Getting Date Formats to Match

    Where do I check regional settings, and what might I look for here? But a clarification, the dates that I am hard coding in, in the cell the still show the proper format (01/01/2000 00:00)...but when I highlight the cell, it is in the function box (?) where it shows up as 1/1/2000 12:00 AM.
  20. mathias1979

    Excel: Getting Date Formats to Match

    I need to create a lookup table for dates, in the format mm/dd/yyyy hh:mm. My problem arises in trying to get the formats of the dates I am looking up to match the format of the dates in the lookup table. The lookup table values are created by using the CONCATENATE function to string...

Part and Inventory Search

Back
Top