I have the following table:
Class Name Result 1 Result 2 Result 3 Result 4 Result 5
D David 3703 3714 3769 3773
D John 3714 3719
D Edward 3684 3741 3749 3763 4943
D Stuart 3650 3660 3718
D Jill 3633 3688 3695 3769
D Jean 3654 3690 3702 3707 3757
D Harry 3646 3651 3658 3740
D Ross 3653 3663 3677 3700
D Phil 3648 3654 3682 3687 3764
D Clayton 3665 3674 3663
D Neil 3635 3649 3653 3683 3663
D Craig 3620 3651 3685 3698 4927
D Yang 3693 3705 3724 3736 4804
D Martin 3617 3620 3668 3687 3620
D Ian 3680 3700 3769 3773
D Andy 3714 3632 3636 3771
Basically I want to type in a Result e.g 3663 and I would like to return a list of all the occurances of this result and who got the result
So in this case 3663 would return
Ross
Clayton
Neil
As these are the only three entries with 3663
Bookmarks