General Betting
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.
sort by:
Show
per page
Replies: 11
|
By:
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 |
|
By:
I wouldn't delete the columns, just hide them
|
|
By:
In case you don´t know: right-click column letter and select hide
 |
|
By:
Good idea about hiding the columns
My lips are otherwise sealed!  |
|
By:
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. |
|
By:
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. |
|
By:
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 |
|
By:
Is the 0 the same as FALSE Compound?
|
|
By:
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. |
|
By:
play around with the vlookup examples in excel help and you will be zooming along no problems
|
|
By:
Thanks to everybody for their solutions.
|