Recent content by dreadnaught

I have an excel sheet that I want to put a water mark on and cannot find it. the help did not help either. I tried to use the background feature in formating but it only let me select a file. Can anyone help?

I am working in a pivot chart I have set the format that I want but when I start to filter the data the chart format changes. Is there a way to lock the format so it is not continually changing?

In excel how to I link a graph chart title to a specific cell? The cell will change as I change the data?

Skip the query is run using MS query and the data is returned to excel. I then import the excel file to a created access data base. within access is where the added lines appear.

I have a query that is pulling from our as400 system. I then import this file into an access data base. every month then I import the import adds about 44k blank lines. I have deleted all columns to the right of the data and deleted all row below the data. Does anyone have any idea why this...

I am using an excel spread sheet and I am trying to hightlight or enter data into the sheet and I am getting and error "too many different cell formats". The sheet does have a lot of formating but I am not sure why I am not permitted to enter data? Is there actually a limit to the amount of...

I am running a report with a calculation. At some points in time the report divides by zero. This causes and #Error to appear in the report. I am trying to figure out how to get ride of the error. I tried an if statement but it did not work. With the error in the report Access will not...

When I create a pivot table and run the data I get all the information in the filter/head that will allow me to fileter on. If I run the data a week later even though some of the data is not in the data set it still shows up in the filter as a data point. I know I can change the header in the...

I am trying to get the header in excel to be populated by a cell from the sheet I am trying to print from. Any ideas? Dreadnaught

Actually no they are not blank. It is a query from a data base and it is bringing back zero in that cell.

glennuk I put in the formula exactly and I am getting a return value of 0. I did make sure I did the ctrl shift enter. Any ideas?

what if the last number in the row is not always the max?

I am trying to pull the last populated cell in a row. I have but an example below. It there any formula that will do this? 1 2 3 4 5 6 7 8 9 10 11 12 number a 7 4 2 5 9 9 b 1 3 5 6 8 9 12 12 c 2 4...

Thanks it worked perfectly. I am so happy there are experts out here like you. Dreadnaught

I have a matrix with is 5 lines and 5 rows and I want to be able to select a specific combination of that. How would I write the formula. Here is the example X a b c d e 1 10 15 20 30 40 2 20 21 22 23 24 X 3 30 32 34 33 38 4 40 25 35 67 34 5 50...