Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Surname | First name | Result | Surname | First Name | Result | |||
2 | Brown | Tom | 0.185251644 | Smith | Tom | 0.048926 | |||
3 | Brown | **** | 0.980913046 | ||||||
4 | Jones | Harry | 0.917617581 | ||||||
5 | Jones | Bill | 0.265835241 | ||||||
6 | Smith | Ben | 0.794210474 | ||||||
7 | Smith | Tom | 0.048926178 | ||||||
8 | Smith | Jerry | 0.811946112 | ||||||
Sheet |
Ok, so when you select woodington what result do want? Do you want both names or just one name? If you want just one name, which one?when i select any of the woodington names it defaults to the first woodington in the list. does this help.