Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Excel formula for hole array

Status
Not open for further replies.

George631

Industrial
Feb 16, 2009
3
Hello folks

Here is what I'm trying to do.
I have a cabinet partition or a cabinet side wall slab that I want to drill a series of holes 32mm apart in a single line.

I am able to do this using the array. I have turned the array into an I-feature and it works beautifully. But all the holes are either on or off.
I would like to be able to select individually just the holes I want or don't want to use on the part.
There are a total of 77 holes so I don’t want to dimension them separately.


I'd like to try doing this on an excel spread sheet if possible.
Is there a formula that can do this?
Is this a practical way to go?

Thanks,
George
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor