We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
Chit Chat
There is currently 1 person viewing this thread.
21 Jan 10
13:29
Joined:
Date Joined:
04 Jun 04
Been yonks since ive used this so cant remember a thing...
Say you have data in the form
1
MR A Smith
024 111111
101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
2
MR B Smith
024 222222
102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
3
MR C Smith
024 333333
103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
4
MR D Smith
024 444444
104 ANY ADDRESS, Coventry, West Midlands, POSTCODE
all this appears in A1:A16
[u]QUESTION[/u]
how do i get it so it appears on a new sheet as follows
A1:B1:C1:D1 would be 1 2 3 4
A2:B2:C2:D2 would be 024111111, 024222222, 024333333, 0244444444
etc
etc
basiccily i want to pick out 1,5,9,13 and put them along the top
then 2,6,10,14 along the second line
3,7,11,15 along the third etc etc
not explained it too well but hope its clear enough...
THANKS IN ADVANCE , SHERRIFF
Say you have data in the form
1
MR A Smith
024 111111
101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
2
MR B Smith
024 222222
102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
3
MR C Smith
024 333333
103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
4
MR D Smith
024 444444
104 ANY ADDRESS, Coventry, West Midlands, POSTCODE
all this appears in A1:A16
[u]QUESTION[/u]
how do i get it so it appears on a new sheet as follows
A1:B1:C1:D1 would be 1 2 3 4
A2:B2:C2:D2 would be 024111111, 024222222, 024333333, 0244444444
etc
etc
basiccily i want to pick out 1,5,9,13 and put them along the top
then 2,6,10,14 along the second line
3,7,11,15 along the third etc etc
not explained it too well but hope its clear enough...
THANKS IN ADVANCE , SHERRIFF
sort by:
Show
per page
Replies: 18
|
By:
am not a macro expert at all but i think its the only way to do this kind of job, someone might tell you if your lucky.
|
|
By:
First you could introduce a column 1 2 3 4 etc so you can always revert to the original order of data, then use SORT function and copy and paste into the required coumns, i'd imagine it's do-able
|
|
By:
Only one ' L ' - hope this helps.
|
|
By:
If it's not too large a file you can send it to me by mail and i'll have a go
|
|
By:
sorry i didnt explain it too wel
i really wanted this doing.. Been yonks since ive used this so cant remember a thing... Say you have data in the form 1 MR A Smith 024 111111 101 ANY ADDRESS, Coventry, West Midlands, POSTCODE 2 MR B Smith 024 222222 102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE 3 MR C Smith 024 333333 103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE 4 MR D Smith 024 444444 104 ANY ADDRESS, Coventry, West Midlands, POSTCODE 5 MR E Smith 024 555555 105 ANY ADDRESS, Coventry, West Midlands, POSTCODE 6 MR F Smith 024 666666 106 ANY ADDRESS, Coventry, West Midlands, POSTCODE all this appears in A1:A24 The list in column A is lot lot bigger than this but using 6 contacts as an example [u]QUESTION[/u] how do i get it so it appears on a new sheet as follows A1:B1:C1:D1 would be 1,MR A Smith,024 111111,101 ANY ADDRESS, Coventry, West Midlands, POSTCODE A2:B2:C2:D2 would be 2,MR B Smith,024 222222,102 ANY ADDRESS, Coventry, West Midlands, POSTCODE ETC ETC not explained it too well but hope its clear enough... THANKS IN ADVANCE , SHERRIFF ps star fish... have you got an old email address i can send it to for you.. thanks again |
|
By:
simonsimon141 at hot mail . com
|
|
By:
sent..thanks
|
|
By:
hope that does the trick
|
|
By:
thats great but just sent you another e mail to see how you did it.. :)
|
|
By:
Sheriff, in my example your data is in Sheet 1 and your new sheet is sheet 2.
Sheet2... A1 = 1 B1 = 2 C1 = 3 D1 = 4 A2 =INDEX(Sheet1!$A:$A,MATCH(Sheet2!A1,Sheet1!$A:$A,0)+1) A3 =INDEX(Sheet1!$A:$A,MATCH(Sheet2!A2,Sheet1!$A:$A,0)+1) A4 =INDEX(Sheet1!$A:$A,MATCH(Sheet2!A3,Sheet1!$A:$A,0)+1) Then just drag A2:A4 formula over to columns B C D |
|
By:
nearly got it but still cant quite crack it... grrrr
|
|
By:
I replied, both my way and Mr Nibs will do it, what's the sticking point?
|
|
By:
sorry m8..just seen your mail.. thanks again...
|
|
By:
Np :-)
|
|
By:
little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheet
if you have a1=Sheet6!A1 a2=Sheet6!A6 a3=Sheet6!A11 and i want to carry on this series downwards eg in a4 i would have =Sheet6!A16 and then A21 etc etc.. how do i drag the formulas downwards or what function do i use in order to maintain the series my head fried at min |
|
By:
anyone
|
|
By:
Sheriff,
Cell A2 in sheet 7 =INDEX(Sheet6!A:A,MATCH(A1,Sheet6!A:A,0)+5,1) Then drag down |
|
By:
Just make sure A1 in sheet 7 is =Sheet6!A1
|