How to get the count of repeated values in PowerShell from an Excel Sheet-CodePudding

Home > Enterprise > How to get the count of repeated values in PowerShell from an Excel Sheet

How to get the count of repeated values in PowerShell from an Excel Sheet

Time：08-16

COUNTIF(A$2:A$6,C2)

But you could also use:

COUNTIF(A$2:A$6,"Jay*")

However I find that less flexible.

Then you can use sumif() to get the totals etc