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!

Search results for query: *

  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

Part and Inventory Search

Back
Top Bottom