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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!