Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Recent content by 1raven

  1. 1raven

    Repeating rows @ bottom of each page

    The 255 limit applies to the whole footer. Not per section. I think the only real alternative you have (other than upgrading to Excel 2002) would be setting up a large enough margin and creating a custom watermark.
  2. 1raven

    Freewheel Clutch for Bi-Directional Conveyor

    You may want to take a look at Hillard. They have a Bi-Directional Overrunning Clutch that might suit your needs. http://www.hilliardcorp.com/mcdboc.php3
  3. 1raven

    Conditional formatting help.

    0 is not even or odd, by the way. If the number is only going to be a 1 or a zero, and you want the format to be applied if it is a 1, that is actually much simpler. Select the row. In Conditional Formatting, us "Formula Is": =IF($A$1,1,0) A1 being the target cell with the 1 or the 0.
  4. 1raven

    Conditional formatting help.

    No way I know if to do it be selecting the whole table (with Conditional Formatting). But it will work by selecting the whole row (like I said above) NOTE: A1 in the above formulas would be the cell that has the 1 or 0 in it at the end of the data.
  5. 1raven

    Conditional formatting help.

    Select the whole row you want to change. Go to Conditional Formatting. For your condition, use "Formula Is" rather than "Cell Value Is". Insert one of the following the formulas: If you have the Analysis Tool Pak installed: =IF(ISEVEN($A$1),0,1) Alternatively: If you...
  6. 1raven

    VLOOKUP and HLOOKUP Used Together???

    You could try to use named ranges and intersection as a simple fix (could be a bit of set-up time if there are many rows and columns). If you would rather have a little more set-up and a lot less complicated formulas, do this... Select the row that has the humidity levels for temp 150 (all...
  7. 1raven

    I would like to find an official ex

    The way I understand it, a sheave can be used as a pulley, but it doesn't necessarily have to be. A sheave is simply a wheel or disk with a grooved rim. There is no function explicitly implied. It is no more than a simple object. A pulley is a sheave (or a collection of sheaves used in...

Part and Inventory Search