General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
29 Jan 12
03:43
Joined:
Date Joined:
06 Aug 04
I have Player and SP, i also have Player and Finishing Position(FP).
I'd like to be able to match the two together so i have Player-SP-FP.
In column C i want to place the FP from column E so it matches with the correct name in column A.
Like this.
Then i would delete column D+E.
Any help would be much appreciated.
I'd like to be able to match the two together so i have Player-SP-FP.
| A | B | C | D | E | |
| 1 | Tiger Woods | 10 | Rory McIlroy | 1 | |
| 2 | Rory McIlroy | 15 | Adam Scott | 2 | |
| 3 | Adam Scott | 20 | Tiger Woods | 3 |
In column C i want to place the FP from column E so it matches with the correct name in column A.
Like this.
| A | B | C | D | E | |
| 1 | Tiger Woods | 10 | 3 | Rory McIlroy | 1 |
| 2 | Rory McIlroy | 15 | 1 | Adam Scott | 2 |
| 3 | Adam Scott | 20 | 2 | Tiger Woods | 3 |
Then i would delete column D+E.
Any help would be much appreciated.
Show More
There's probably a quicker way of doing this in more modern versions of excel, but in mine (2003) this is what I would do . . .
1) Highlight everything in column A and B
2) Click Data
3) Click sort
4) Select Column A - ascending
5) Click OK
You should now have the golfers sorted in alphabetical order in column A, with their SP in column B
6) Do exactly the same with columns D and E
You should now have the golfers sorted in alpha order in column D, with their finishing position in column E - check that the names in the two columns match
7) Delete columns C and D
1) Highlight everything in column A and B
2) Click Data
3) Click sort
4) Select Column A - ascending
5) Click OK
You should now have the golfers sorted in alphabetical order in column A, with their SP in column B
6) Do exactly the same with columns D and E
You should now have the golfers sorted in alpha order in column D, with their finishing position in column E - check that the names in the two columns match
7) Delete columns C and D
In case you don´t know: right-click column letter and select hide 
Good idea about hiding the columns
My lips are otherwise sealed!
My lips are otherwise sealed!
Probably a better way but here goes.......
1) Highlight everything in column D and E
2) Click Data
3) Click Sort
4) Select Column D - Ascending
5) Click OK
You should now have the golfers sorted in alphabetical order in column D, with their SP in column E
6) Enter the formula =VLOOKUP(A1,$D$1:$E$3,1) in cell C1 and copy down to cell C3.
7) Hide columns D and E if required.
1) Highlight everything in column D and E
2) Click Data
3) Click Sort
4) Select Column D - Ascending
5) Click OK
You should now have the golfers sorted in alphabetical order in column D, with their SP in column E
6) Enter the formula =VLOOKUP(A1,$D$1:$E$3,1) in cell C1 and copy down to cell C3.
7) Hide columns D and E if required.
My preferred way would be to use a formula in cell C1
This formula ~
=VLOOKUP($A1,$D$1:$E$3,2,0)
Then fill down for as many rows as needed
If you had many more names and results you just change the number after $E$ to the last row.
so if you had 20 rows to do your formula would be ~
=VLOOKUP($A1,$D$1:$E$20,2,0)
When you have filled down the formula in column C, select column C, copy and while still highlighted
click paste special values only. Then you can clear all of columns D and E. or just select columns D and E
and delete selected columns.
This formula ~
=VLOOKUP($A1,$D$1:$E$3,2,0)
Then fill down for as many rows as needed
If you had many more names and results you just change the number after $E$ to the last row.
so if you had 20 rows to do your formula would be ~
=VLOOKUP($A1,$D$1:$E$20,2,0)
When you have filled down the formula in column C, select column C, copy and while still highlighted
click paste special values only. Then you can clear all of columns D and E. or just select columns D and E
and delete selected columns.
top2rated, you beat me to it.
The 0 in my formula as against the 1 in yours looks for an exact match so saves the need for sorting.
Cheers
The 0 in my formula as against the 1 in yours looks for an exact match so saves the need for sorting.
Cheers
The 0 in my formula as against the 1 in yours looks for an exact match so saves the need for sorting.
Thanks for the tip CM - that'll come in handy.
Thanks for the tip CM - that'll come in handy.
play around with the vlookup examples in excel help and you will be zooming along no problems
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539