I'm a welding inspector trying to develop a weld tracking sheet and am in need of a formula that counts types of welds from column-B but without duplicating a weld number from Column A. For example:
Weld#. weldType. Inspection. #ofwelds
A. B. C. SW = 2
weld1. BW. Step1. BW = 2
weld2. SW. Step1
weld3. SW. Step1
weld4. BW. Step1
weld2. SW. Step2
weld4. BW. Step2
weld4. BW. Step3
we are tracking the welds by the inspection being conducted and will have 6-7000 welds, however with all the inspections have 3-4 steps each, we will have estimated 11,0000 BW's showing.. Thanks in advance guys.. New to this...
The closed I came was something like this =COUNTIF(Frequency(B1:B10,"BW"), but not if ????
Weld#. weldType. Inspection. #ofwelds
A. B. C. SW = 2
weld1. BW. Step1. BW = 2
weld2. SW. Step1
weld3. SW. Step1
weld4. BW. Step1
weld2. SW. Step2
weld4. BW. Step2
weld4. BW. Step3
we are tracking the welds by the inspection being conducted and will have 6-7000 welds, however with all the inspections have 3-4 steps each, we will have estimated 11,0000 BW's showing.. Thanks in advance guys.. New to this...
The closed I came was something like this =COUNTIF(Frequency(B1:B10,"BW"), but not if ????
Last edited: