Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial