COUNT but not if duplicated in another row
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?
Best Answer
-
You could use
=count([Tag No]:[Tag No])-count([Tag No D]:[Tag No D])
Answers
-
Hi
Can you share a Snip of your sheet.
-
Hi
Here is a snip of the columns. Many thanks, Jo
-
You could use
=count([Tag No]:[Tag No])-count([Tag No D]:[Tag No D])
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!