Countif

[How_Do_I]

Hello, where am I going wrong here please... My D1 should be 4...

Excel Workbook
	A	B	C	D
1	USAAF	USAAF	2	6
2	USAAF Agenvillers
3	USAAF Ailly-le-haut-Clocher
4	USAAF Andres
5	USAAF Ardouval
6	USAAF
Sheet1

 

[Marcílio_Lobão]

How_Do_I, Good evening.

Try to use:

D1 --> =COUNTIF(A1:A6, "<>"&B1)

Is that what you want?
I hope it helps.

 

[How_Do_I]

Good evening to you too Marcílio_Lobão... Thanks for that formula, it worked for me.

 

[Marcílio_Lobão]

Thanks for the feedback.

Glad to be of help.