Jump to content

Need help consolidating the door schedule


Sky

Recommended Posts

I have many of the same doors and would like the door schedule to reflect the quantity of all doors with the same ID.

I placed the doors and edited the settings so that all doors that are alike have the same ID. However, the door schedule shows each door individually.

Perhaps there was a better way to do this to achieve a consolidated door schedule. I am open to all suggestions. Please help!

Link to comment

Ohh... okay - that must be a good first step. I've done that and got them all consolidated together.

Now, one other question (sorry to be so ignorant) but how do I get it to show the quantity and the correct size of the doors - it seems to have added them all up!

Link to comment

For the quantity put in an additional column with a formula of =count

For the size, pretend we put the =count formula in cell b2

=door.width/b2 will give the width.

There are a number of threads floating around regarding these issues. Do an Advanced Search on my posts (use name Pat Stanford). I think I have answered both those questions in the last month (maybe 2).

Pat

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...