Excel check duplicate entries

[Asphyxia]

Let's run through a sample case, we get a process list from system 1:

Get-Process | Select-Object Path | sort | findstr ".exe" > C:\running.txt

Then how about we get unique files:

gc .\running.txt | gu > tasks.csv

So now we have a tasks file to open in Excel.

Insert just above, like so:


Time to add server names and highlight AN ENTIRE LIST to format.. for example click "B" so the FULL_FUCKING_ENTIRE_COLUMN is selected (not like my picture shows):


Click on "Home > Conditional Formatting > New Rule..."

Select "Use a formula to determine which cells to format"

Now enter this:

=countif($A:$A, $B1)

Select a format to apply, for example I select Fill > select blue color for the font text color.



...



Now you can see, side-by-side comparison of known files versus unknown files.

Imagine doing this with file hashes, we will come back around to that another time.