countifs and also unique value

[VbaHell]

Hello all

I am trying to use a countifs statement to count the number of lines that match a date but i want to also include only unique lines.

[=COUNTIFS(Data!Q:Q,C6)]

This is the countifs statement in cell "E6"

I also want to add the unique count to this formula which is in [Data!V:V] which is TEXT

As an example

01/01/2019 text1
01/01/2019 text2
01/01/2019 text3
01/01/2019 text1

The count answer in "D6" would be 3 not 4

I have in cell "C6" onwards the date starting at 01/01/2019
Next row "C7" 02/01/2019
Next Row "C8" 03/01/2019 and so on.

 

[James006]

Hello,

Unfortunately ... your explanation is very confusing ...

What is in Column C, in Column D, in Column E, in Column Q, in Column V ...?