Hello everyone. I'm brand new here and also very mediocre at using Excel. In my job Excel is used more for data entry and tracking to pass along a detailed record to our customers. I'll try to explain what I'm working with.
The workbook I use is comprised of several hundred sheets. Each sheet represents a piping spool, a unit of fabrication that correlates to an individual isometric drawing that our pipefitters build to. In column B we have weld letters A- Z or A- BB, rows 9 through 34. In column C and D we list the welding process used to make the weld and in column E we list the welder ID number. In column J we list what type of testing is required either LP or XR followed by the size of pipe if it is an xray (XR).
What I am missing is a formula or code to tally how many welds recorded through the entire workbook are made per each welder ID. For instance, how many welds did 33 make? and how many did 12 make? Further compounding my problem is that I need to exclude any welds that are NOT xray, so if column J says that 33 made a XR 3" I want to count it, but if it says LP SW or LP O-LET I want it omitted in one of the counts. So I'm looking for a way to count total number of welds for each welder ID, and then also count total number of welds for each welder ID excluding the LP tested ones.
I also need a report on how many total welds are to be made throughout the entire workbook. Since column B always shows welds A-BB regardless of whether it is a weld or not, the number I welds can't come from there. I'm assuming the best way to count the welds is to count the total number of filled cells throughout the workbook in column J, rows 9 through 34.
Is this possible? I know excel can perform incredibly complex tasks but I have no idea where to begin. This whole project was dumped on me at the last minute and I can't find out how to do this properly. To do this manually would take approximately 100-120 hours and that's unacceptable to my superiors.
I apologize in advance for any forum etiquette I may not be following. I haven't had a chance to browse this site or many others. Like I said, all this was dumped on me last minute and I'm already running out of time.
Bookmarks