HLOOKUP, if,? OR MACRO
hi everyone, Newbie here. so please take it easy on me.
I have a very real issue and dont know how to get the function or macro I need. I am also working with Access but right now need the help with Excel 07.
the problem
I have a workbook, 5 Columns A: Weld ID, B:Welder 1start, C:Welder 2start, D:Welder 3finish, E:Welder 4finish. and thousands of rows
i need self population and repeatability,
I have numerous weld ID's and Numerous welders but no more than 4 welders per weld and as little as 1 welder per weld, the problem is trying to count how many welds each welder made, if four welders made a weld
I want to give each of them credit with 1 weld but if only 1 welder worked on the weld only give credit for 1 weld, but the kicker his or her id is (example) 1234A must apper in B, D column at minimum these this represents different stages of the weld beginning and finish.
So to sum it up if 2 welders begin a weld and only 1 guy finished it all three need credit, but if same guy began and finished only credit 1, I will
tally all welds beside the welderID. It does not have to grab the out of first available as long as it gives credit to the welder as long as the welder id is in one of the four blocks. for each weld. any help would be greatly appreciated and i await your replies. thanks in advance.
|