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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.