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 ACTGuy

  1. ACTGuy

    SUMIF Problem

    Thanks IDS. That took care of it. I was regretting next week when this excercise repeated itself.
  2. ACTGuy

    SUMIF Problem

    I fixed the problem, but don't understand why or how. I formated all the cells the same. Then I had to open each cell, as to edit the cell. All formulas are functioning properly. I'm glad I had only 500 cells to do that to. There has got to be a better way. If you know, please reply. Thanks
  3. ACTGuy

    SUMIF Problem

    I need to convert an .mdi file to excel. I first copied the information to a text file, then to excel. Doing this exercise allowed me to maintain the columns needed for a spreadsheet. I am using excel as a database, somewhat. I put the converted information in a sheet. In another sheet I am...

Part and Inventory Search