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: *

  • Users: dreadnaught
  • Order by date
  1. dreadnaught

    water mark in excel

    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?
  2. dreadnaught

    Pivot Chart

    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?
  3. dreadnaught

    chart title

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

    Access import from excel

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

    Access import from excel

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

    too many different cell formats

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

    Access Data base Report question

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

    PIVOT TABLE FILTER DATA

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

    Excel header information

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

    pulling last populated cell in a row

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

    pulling last populated cell in a row

    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?
  12. dreadnaught

    pulling last populated cell in a row

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

    pulling last populated cell in a row

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

    Pulling a single number from a matrix

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

    Pulling a single number from a matrix

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

    Query Statement

    Thanks, That seemed to do the trick!!!!
  17. dreadnaught

    Query Statement

    Here is the written SQL SELECT INPOP300.P3PRJ, INPOP300.PURCH, INPOP300.VNDNO, INPOP300.BUYER, INPOP300.HOUSE, INPOP300.OREDT, (QUANO-QBILD)*ECOST, INPOP300.LINE#, INPOP300.ACOST, INPOP300.LSTAT, INPOP100.PSTAT FROM STB.RMSFILES.INPOP100 INPOP100, STB.RMSFILES.INPOP300 INPOP300 WHERE...
  18. dreadnaught

    Query Statement

    I have two rows each either bring back a Y or N. I want to say that if both are Y then do not pull the information. I am using MS Query to pull the information and normally pull using the visual sql instead of writing it. I am not sure how to write this. Hopefully someone can help.
  19. dreadnaught

    Water mark in Excel

    Is it possible to create a water mark in excel on a sheet? I am currently using version xp professional.
  20. dreadnaught

    Pivot advanced function sort

    When sorting my say a month why do I continue to get July before June when using the advanced sort function? I use month for column headers

Part and Inventory Search

Back
Top