Need an excel formula to look at values on one Worksheet and only pull back the differences.

[Wecks]

I have 3 x Worksheets.

The master list is a Sheet called WINDOWS7MACHINES

This contains a complete list of Windows 7 machines and only has one column called WIN7MACHINES which lists all the names of the machines running windows 7


WINDOWS10READY

This is a list of machines i have picked out as being ready for a Windows 10 upgrade. It contains One column and this is called WIN10READYMACHINES and it contains a list of the machine names that are ready to be upgraded to Windows 10.

NOTWINDOWS10READY

Now I want to pull machine names from WINDOWS7MACHINES but I dont want to include machine names that are in WINDOWS10READY worksheet under the column WIN10READYMACHINES

Does anyone have any ideas?

Cheers

Andy

 

[Aladin Akyurek]

In A2 of NOTWINDOWS10READY control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX(Win7Machines,SMALL(IF(ISNA(MATCH(Win7Machines,Windows10Ready,0)),ROW(Win7Machines)-ROW(INDEX(Win7Machines,1,1))+1),ROWS($A$2:A2))),"")

where Win7Machines and Windows10Ready are named ranges.