Search results for query: *

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

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

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

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

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

I was directed over here from the VB forum. I have a dataset which has data reported every hour. Problem is, there are sometimes gaps in the data (several hours missing) or extra data (data reported in between hours). I've never used VB before, but I need to figure out how to fill in the gaps...

Hello, I'm a proficient Excel user, but I've never used VB beyond a few automatically created Macros. What I have is a lengthy data set (actually 20 years split into multpile files) with data reported every 10 minutes. Problem is, there are gaps and extra times in the data set. So sometimes...

Is there a way to break links in Excel while retaining the formula within that cell? In other words, if I have a Workbook called 'Book Two', and in one of those cells I have the following: "='\\folder\[Book One.xls]Sheet1'$C$5+$D$7" is there a quick way to change it so it simply references...

Using Macros in Excel...is there a way to run a Macro in different workbook even if the sheet are not the same? In other words...if I record a macro that copies data from a sheet titled "Sheet 1" to a sheet titled "Sheet 2"...is it possible to run this in another workbook where the sheets are...

I'm working with fortran 77 on pgi compilters. I need to go through a real array and replace occurrances of NAN with -9999. I was just trying a simple if statement such as: if (test(i,j).eq.NAN) test(i,j)=-9999 This just seems to ignore occurances of NAN. And if I try to do something like...