Thread: [Solved] Machine time cycle calculation
View Single Post
 
Old 11-12-2019, 04:53 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
A pivot table might be the most straightforward answer to this, but your table has merged cells which make it unsuitable for creating such a pivot.
I copied your sheet and unmerged the cells and removed blank columns to create a pivot.
Is the attached at cell E49 more or less what you're looking for?
Attached Files
File Type: xlsx msofficeforums43814Machine cycle notes.xlsx (29.7 KB, 6 views)
Last edited by p45cal; 11-13-2019 at 02:05 AM.
Reply With Quote