Count of line items (Unique one, which is extracted after removing duplicates) from column

In Excel 365 / 2019+, you would just use

=COUNTA(UNIQUE(Range))

In 2016-, array-enter (enter using Ctrl-Shift-Enter)

=SUM(1/COUNTIF(Range,Range))

like

=SUM(1/COUNTIF(A2:A1000,A2:A1000))

Do not use the entire column, or include blanks in the range passed to the formula.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

There are a number of techniques to extract the unique values (or distinct values, as some refer to them) from a list.

The first is to use Advanced Filters - select your list of values, then choose the Data tab, then "Advanced" from the sort and filter section, and choose the "Copy to another location" and "Unique records only" options.

The second is to insert a pivot table and use your values as the row data - if you want a count of each, then re-use your values in the data ares.

The third is to use a column of formulas, like this to highlight the first value of each instance in column A, with the formula in cell B2:

=IF(COUNTIF($A$2:A2,A2)=1,MAX($B$1:B1)+1,"")

Copy that down, then use this formula

=IFERROR(INDEX(A:A,MATCH(ROW(A1),B:B,False)),"")

and copy down until the formula return blanks.

Then there are a ton of VBA methods....