=countdiff

[How_Do_I]

I have a named range HomeWin =Sheet1!$C$6:$C$28
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
So, what am I doing wrong in A4 to get a return of 9 and not 8 please...

Excel Workbook
	A	B	C
4	9	1	8
5		1	Barnsley
6		1	West Bromwich Albion
7		2	Ipswich Town
8		3	Cardiff City
9		4	Middlesbrough
10		5	Leicester City
11		6	Watford
12		7	Blackpool
13		8	Nottingham Forest
14		9
15		10
16		11
17		12
18		13
19		14
20		15
21		16
22		17
23		18
24		19
25		20
26		21
27		22
28		23
Sheet1

 

[How_Do_I]

Good morning Aladin…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I did try to adjust the range from your other post but I couldn’t get it… As for the solution, it is fantastic, thank you for your patience with me and your brilliance with Excel…
<o> </o>
Are you a football man... there’s something about The Netherlands and the fact that they don’t concede many goals… Arjen Robben was a favourite of mine at <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:City w:st="on"><st1lace w:st="on">Chelsea</st1lace></st1:City>… If I’m realistic and admit that <st1:country-region w:st="on"><st1lace w:st="on">England</st1lace></st1:country-region> won’t win the World Cup, I think The Netherlands will be semi-final or possibly final material. It could even be their World Cup if they have the necessary luck that IS needed to win a tournament of this magnitude.