New Posts For Thread: Excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-helpI 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. A B C D E 1 Tiger Woods 10 Rory McIlroy 1 2 Rory McIlThanks to everybody for their solutions.https://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515725499#515725499Thanks to everybody for their solutions.Mon, 30 Jan 2012 01:18:46 -0600play around with the vlookup examples in excel help and you will be zooming along no problemshttps://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515684599#515684599play around with the vlookup examples in excel help and you will be zooming along no problemsSun, 29 Jan 2012 05:35:22 -0600The 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.https://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515679637#515679637The 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.Sun, 29 Jan 2012 02:01:01 -0600Is the 0 the same as FALSE Compound?https://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515679519#515679519Is the 0 the same as FALSE Compound?Sun, 29 Jan 2012 01:51:18 -0600top2rated, 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.Cheershttps://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515678011#515678011top2rated, 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.CheersSat, 28 Jan 2012 23:59:31 -0600My preferred way would be to use a formula in cell C1This formula ~=VLOOKUP($A1,$D$1:$E$3,2,0)Then fill down for as many rows as neededIf you had many more names and results you just change the number after $E$ to the last row.so if you had 20 rows thttps://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515677867#515677867My preferred way would be to use a formula in cell C1This formula ~=VLOOKUP($A1,$D$1:$E$3,2,0)Then fill down for as many rows as neededIf you had many more names and results you just change the number after $E$ to the last row.so if you had 20 rows tSat, 28 Jan 2012 23:49:01 -0600Probably a better way but here goes.......1) Highlight everything in column D and E2) Click Data3) Click Sort4) Select Column D - Ascending5) Click OKYou should now have the golfers sorted in alphabetical order in column D, with their SP in column E6https://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515677835#515677835Probably a better way but here goes.......1) Highlight everything in column D and E2) Click Data3) Click Sort4) Select Column D - Ascending5) Click OKYou should now have the golfers sorted in alphabetical order in column D, with their SP in column E6Sat, 28 Jan 2012 23:46:56 -0600Good idea about hiding the columnsMy lips are otherwise sealed!https://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515676983#515676983Good idea about hiding the columnsMy lips are otherwise sealed!Sat, 28 Jan 2012 22:55:34 -0600In case you don´t know: right-click column letter and select hidehttps://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515676109#515676109In case you don´t know: right-click column letter and select hideSat, 28 Jan 2012 22:11:00 -0600I wouldn't delete the columns, just hide themhttps://community.betfair.com/general_betting/go/thread/view/94082/28882013/excel-help?post_id=515676057#515676057I wouldn't delete the columns, just hide themSat, 28 Jan 2012 22:08:50 -0600