COUNT but not if duplicated in another row

Jo Petch

Hi

Looking for some help with a formula... really not sure where to start. I have a sheet where each line relates to scaffold that has been built which is populated by a webform. Each line has a tag number and if I count all the tags in the column Tag No, I can see how many scaffolds are in place. The webform also collects if a scaffold comes down and that same Tag No is entered into the 'Tag No Dismantled' column. What I'm looking for is a formula that counts how many scaffold are up, but not to count them if a tag number is mentioned in the 'Tag No Dismantled' column.

Hopefully this makes sense?

Antonio Figueroa

You could use

=count([Tag No]:[Tag No])-count([Tag No D]:[Tag No D])

Antonio Figueroa

Hi

Can you share a Snip of your sheet.

Jo Petch

Hi

Here is a snip of the columns. Many thanks, Jo

Antonio Figueroa

You could use

=count([Tag No]:[Tag No])-count([Tag No D]:[Tag No D])