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!

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

Recent content by draacor

  1. draacor

    Referencing another worksheet and getting #name?

    Thank you for all of your help.
  2. draacor

    Referencing another worksheet and getting #name?

    doh i took too much out, i have some names i didnt want to post on the forums so i tried editing it to just say workbook and didnt realize i took out the formatting too. This is what it looks like: =IF('[Workbook1.xls]Trend Analysis'!$R$2 > 79.9%,'[Workbook1.xls]Trend Analysis'!$R$2,"")
  3. draacor

    Referencing another worksheet and getting #name?

    i did the mouse click, i didnt type in the reference, i opened up both workbooks and just clicked on the cells i wanted to reference. I have a feeling that the iferror is whats causing the #name? but there has to be a way around that.
  4. draacor

    Referencing another worksheet and getting #name?

    if it helps i do have excel 2007, maybe there are extra features that can alleviate this problem.
  5. draacor

    Referencing another worksheet and getting #name?

    doh! that didnt work i get the same error :(
  6. draacor

    Referencing another worksheet and getting #name?

    Hello, I have two excel workbooks. The first excel workbook has a cell with the following formula: =IFERROR(AVERAGE(B2:P3),"") The second workbook has the following formula to reference the first workbook. =IF('Workbook1!$R$2>79.9%,'Workbook1'!$R$2,"") I only want it to show the data if the...
  7. draacor

    converting time to numbers

    Thank you very much GS i think that will work for what i need. One more thing i was wondering if its possible. Can you take a number in excel like 301.00 and truncate it so it drops off the 30 in front of it so it only shows 1.00?
  8. draacor

    converting time to numbers

    sorry i think i messed up when i said average mean. Let me explain in detail what i want. I cant for some reason think of the word to describe it. We have a standard where if someone is scheduled to work at 1:00 AM every day 5 days a week. We get the average login from another report. So for...
  9. draacor

    converting time to numbers

    I need to convert a time into numbers so that i can take those numbers and put them on a weighted average. I couldnt figure out how to do this easily so i came up with the following formula: =if(j2 = "12:50 AM",10,"") i want 1:00 AM to be the average mean and if its 12:50 to 1:00 AM i want it...
  10. draacor

    Average cells from different sheets with zeros

    Ok i have scoured this site looking for a way to do this and i cant so im opening it up for discussion. I have 6 excel worksheets in a single workbook. The first 5 worksheets has data that pulls from other workbooks. I am trying to compile data across other workbooks into one single workbook...
  11. draacor

    getting rid of zeros

    I have a chart that shows the Average Cycle Time for a range of data. It works fine but for some reason anything outside the date range im selecting is being zero'd out and shows up on the graph as a zero. I cant figure out a way to get rid of it. I cant use the select tool because there are...
  12. draacor

    not able to show data for two SQL Commands

    I am trying to a report that shows details about the surveys we send out for tickets that get created. The survey data is located on a specific table. I have created the following command to get this particular data as follows: SELECT CAST(call_req.persid AS nvarchar(30)) AS persid...
  13. draacor

    List reference in Excel 2007

    I was able to achieve what i wanted by adding the worksheets in the reference workbook as datasources. It works great now, thanks for all of your help guys :)
  14. draacor

    List reference in Excel 2007

    ya im trying to work it so that i have one workbook with all the values that i can change, so that the other workbooks get updated automatically with the updated lists.
  15. draacor

    List reference in Excel 2007

    Another Workbook

Part and Inventory Search

Back
Top