Avatar of Pau Lo
Pau Lo
 asked on

advanced filter formula.

I have got an extract of data, with 2 key columns, computer, and software. the data is basically a software inventory of devices and in a sequential order, e.g.

computer 1 - software 1
computer 1 - software 2
computer 1 - software 3
computer 2 - software 1
computer 2 - software 2
computer 2 - software 3
computer 3 - software 1
computer 3 - software 2
computer 3 - software 3

There is one particular piece of software that should be on ALL computers, but I have fears it is not. I need a way to supply a value e.g. software 2, and filter my data so it returns just the computers who do not appear to have software 2 installed.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Saqib Husain

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Rob Henson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61