Search results for query: *

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...

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...

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

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...

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...

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...

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!

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

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...

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...

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!

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...

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...

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

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?

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...

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!

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.

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.

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...