Assistance with Filtering out -m- tags from a Index when searching through a column of computers.
Here is my current code:
=IFERROR(INDEX(DataDump!A:A,SMALL(IF((DataDump!$K$2:$K$2001<>"6")*(DataDump!$B$2:$B$2001="Managed"),ROW(DataDump!$K$2:$K$2001),""),ROWS(L$2:L2))),"")
Breakdown
DataDump!A:A - is the list of computers to look through
DataDump!$K$2:$K$2001 - is the list of version numbers to look through and to show any version that is NOT 6.
DataDump!$B$2:$B$2001 - A list that will say either managed or unmanaged
This code above is currently working,
It looks through the list of computers, to find anything that is NOT a version 6, then looks for "Managed" in Column B, and then posts the resulting computer (That is managed and NOT version 6)
How can add to this formula to "ONLY review computers in DataDumpA:A that DO NOT CONTAIN -m-
I tried:
=IFERROR(INDEX(DataDump!A:A,SMALL(IF((DataDump!$A$2:$A$2001<>"*-M-*")*(DataDump!$K$2:$K$2001<>"6")*(DataDump!$B$2:$B$2001="Managed"),ROW(DataDump!$K$2:$K$2001),""),ROWS(L$2:L2))),"")
but it didn't work
My end game is for this not to count Macs
Bookmarks