How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
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...
<?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 |