LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cam Cam is offline
external usenet poster
 
Posts: 165
Default Help w/ VB to match & calculate

hello,

I have the following data:
Wrkctr Mach Setup Run
MCB607 5 30
XJ2607 5 10
QPU607 5 2
XM4607 15 5
XM4607 2964 815 15
XM4607 10 5
XM4607 15 5
XM4607 10 5
XM4607 15 5
XM4607 2964 750 15
XM4607 2964 100 15
XM4607 5 0
XM4607 10 5
XM8607 9435 5 60
XJ2607 15 120
XJ2607 15 10
QPU607 5 2
XM6607 4955 90 600
XM8607 9435 15 30
XM9607 0 240
XM9607 5 74
XN8607 9436 23 10
XN2607 PA111 30 1
QP5607 4 24
XJ2607 7 1200
QPU607 5 45
QPU607 5 10
QPU607 10 60
QPX607 5 45

I need to create a macro to give me this results:
Wrkctr Setup Run Cycle time
MCB607 5 30 35
QP5607 4 24 28
QPU607 30 119 149
QPX607 5 45 50
XJ2607 42 1340.2 1382.2
XM4607 1745 75 1820
XM6607 90 600 690
XM8607 20 90 110
XM9607 5 314 319
XN2607 30 1 31
XN8607 23 10 33

Calculate the sum of setup and run time for each wrkctr. The cycle time is
sum of setup & run time. number of rows of data vary. Thanks for any help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Formula: Return 1st match, then 2nd match, then 3rd match Scott Excel Discussion (Misc queries) 4 December 11th 09 05:50 AM
How to match date criteria then calculate an average of matches Buffy M. Warren Excel Worksheet Functions 5 November 21st 07 03:22 AM
MATCH Multiple Criteria & Return Previous / Penultimate Match Sam via OfficeKB.com Excel Worksheet Functions 27 October 6th 07 01:39 AM
Lookup? Match? pulling rows from one spreadsheet to match a text f cjax Excel Worksheet Functions 3 July 21st 06 02:51 PM
formula to calculate a 401K company match? Trish Excel Worksheet Functions 3 January 18th 06 06:05 PM


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"