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!

Search results for query: *

  • Users: zidol
  • Order by date
  1. zidol

    Maximizing a total at 24

    Thank you for your help!
  2. zidol

    Maximizing a total at 24

    Formula: {Hours 1} - {Hours 2} = 28 hours I want it to return the total, but maximize at 24 How do I write the formula for this?
  3. zidol

    Display Second Fastest Truck

    Good morning - I finally got to try the formula and it does work great. How can I find out what the 3rd fastest truck?
  4. zidol

    Display Second Fastest Truck

    I have not tried it - I am having problems with connection to my database. Hopefully I can tomorrow. Question - what if I want to know the 3rd fastest?
  5. zidol

    Display Second Fastest Truck

    Hi Pete - I am trying to get the 2nd fastest truck. I think what you described would give me the 1st truck. Thanks - Lynn
  6. zidol

    Display Second Fastest Truck

    My data consist of records with Incident Numbers. Within these incident records are several trucks with a response time attached to each truck: Incident Number - 160039 Truck - E34 ____ Response - 2.85 Truck - E35 ____ Response - 2.83 Truck - T34 ____ Response - 6.30 Truck - A35 ____...
  7. zidol

    How to change the start page number in crystal?

    I want to start the first page of my report at page number 5 and the following pages to increase by one. How do I do this? Thanks for your help.
  8. zidol

    Adding a decimal point to a number

    Yes - I do. I meant to type 1.5 - but thanks!
  9. zidol

    Adding a decimal point to a number

    Great! That worked. Thanks for your help.
  10. zidol

    Adding a decimal point to a number

    I have two fields: {Coverage.TOTALHOURS} which displays as "1.00" {Coverage.TOTALMINUTES} which displays as "30" - No decimal point Formula is: {Coverage.TOTALHOURS} + {Coverage.TOTALMINUTES} Because the {Coverage.TOTALMINUTES} does not have a decimal point, it returns "31.00" - I need it...
  11. zidol

    Trying to sum a text field that has been converted to a number

    I have a text field that I converted to a number. I am not able to get a sum of the new number field. The I have tried the following formulas. Formula Name: NumPerson1 Formula: ToNumber({IncdApps.NUMBEROFPEOPLE}) I place this formula in the report and the field shows up as a number. I insert...
  12. zidol

    "Countif" with a Condition Question

    It Works! Thanks for all your help!!
  13. zidol

    "Countif" with a Condition Question

    Wow - that is great. Thanks!!
  14. zidol

    "Countif" with a Condition Question

    Yes they do have headings. I seem to run into trouble when I have multiple criteria, e.g. "No Treatment,No Transport" , "Treatment,No Transport", as in the one I am trying to fix. The formula you sent me works but there is not multiple criteria in it. I do have this formula for another column...
  15. zidol

    "Countif" with a Condition Question

    Based on the sample database below using the formula: =COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport") I get 6 "Refusals" returned, which is correct. I tried using the following formula to get a count of "Refusals" that have been...
  16. zidol

    "Countif" with a Condition Question

    In Column F, I am getting a total of "Refusals" based on the following formula: Column F – Number of Refusals =COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport") Column I - List different types of Review Status, such as "Complete", "In...
  17. zidol

    Eliminating Duplicates in Excel

    I can not thank you enough. This works perfectly with the pivot table!! Again - thanks for your time and expertise.
  18. zidol

    Eliminating Duplicates in Excel

    Sorry for the delay in responding - I have been in marathon meetings! A big thank you to both of you! I appreciate how much time you are spending to help me. Thanks for sending me the test files. I think the pivot table is the way to go. I'm going to test it out on my database. I'm not that...

Part and Inventory Search

Back
Top