Need help filtering an excel file
Posted on 2014-03-19
I have a spreadsheet with many systems names in column A, but there are alot of duplicates. Problem these duplicates are there because in column B there are version numbers for each of the system names.
Now I need to remove any systems what have a version number of 17 and higher in column B, no these same system can have version numbers below 17, but is they have any numbers above 17, then I need to remove the system names completely regardless if they have version 17 and below.
I need to be left with system names that have version number 16 and below only.
Am I making sense. :)