I have a excel spreadsheet that lists employees and production statistics. This spreadsheet is arranged in the first column by the equipment type then the employee that ran it for that day. The other columns are stats for that machine and employee. Different employees work on that machine on different days. I need to add one column by employee which means taking the information from different lines.
Need a formula that is if employee # is 123 then look in column x2 on each days spreedsheet
