Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations KootK 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 awd319

  1. awd319

    Column shrinking

    Spot on Joerd, Thanks!
  2. awd319

    Column shrinking

    Thanks for the replies so far. Our own solution uses a very similar solution to jghrist, but using OFFSET rather than INDEX. Unfortunately, like most solutions, this involves creating a "dummy" column to do the counting. Can anyone come up with some arithmatic within the OFFSET (or...
  3. awd319

    Column shrinking

    If I have a massive column of data, How do I form a new smaller column consisting of, say, every fourth cell? i.e, If column A consists of cells containing the numbers 1,2,3,4,5,6,7,8,9 I want column B to be 1,5,9 by referencing A1,A5 and A9 in incremental steps. Thanks
See more

Part and Inventory Search

Back
Top Bottom