Hi,
I used this formula below to give me unique entry counts from a column that has texts.
I have another column that indicates whether the text is from 2018 or 2017.
How do I embed in the formula to just give me texts from 2018 entries (then count unique entries that are from 2018 only)? the years are logged in column A in my excel sheet.

=SUMPRODUCT((E10:E162<>"")/COUNTIF(E10:E162, E10:E162&""))

Thank you!!