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: draacor
  • Order by date
  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

    ...and not isnull ({tickets.resolve_date}) and not isnull ({tickets.active_flag}) and not isnull ({tickets.type})and not ({tickets.priority} like '') and ({tickets.resolve_date} >={?01StartDate}-84) and {tickets.priority} = '1-Critical' then (({tickets.resolve_date}-{tickets.open_date})*1440)/60
  12. draacor

    not able to show data for two SQL Commands

    ...> (DATEDIFF(second,'1/1/1970',{?01StartDate}-84) + (datediff(second,getutcdate(),getdate()) - (datediff(second,getutcdate(),getdate()) * 2)))) and (survey.last_mod_dt < (DATEDIFF(second,'1/1/1970',{?02EndDate}+1) + (datediff(second,getutcdate(),getdate()) -...
  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
  16. draacor

    List reference in Excel 2007

    Is there a way to create a drop down list in Excel where the data in the list references another workbook?
  17. draacor

    Average number of agents per time per day

    its really strange, i kind of inherited this report from another program. The command that is listed is nothing more than a stored procedure located on the database. I went into the stored procedure and it is so convoluted and confusing i just left it alone. So all the modifications i have...
  18. draacor

    Average number of agents per time per day

    hmm in Field explorer it is greyed out to add anything new. Is it because i already have a SQL command for this report?
  19. draacor

    Average number of agents per time per day

    its hard to explain but with this particular report i do not have access to do sql commands for it. Is there a way to do this within crystal reports using formulas?
  20. draacor

    Average number of agents per time per day

    Thanks to LBASS i have the following formula for calculating the average number of agents for each time frame. //{@accum} to be placed in the {@timeint} group footer: whileprintingrecords; numbervar int12to7; numbervar int7to5; numbervar cnt12to7; numbervar cnt7to5; if {@timeint} = "12:00 to...

Part and Inventory Search

Back
Top