New Posts For Thread: EXCELL HELP PLEASEhttps://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-pleaseBeen yonks since ive used this so cant remember a thing... Say you have data in the form 1MR A Smith024 111111101 ANY ADDRESS, Coventry, West Midlands, POSTCODE2MR B Smith024 222222102 ANY ADDRESS, Binley, Coventry, West Midlands,  POSTCODE3MJust make sure A1 in sheet 7 is =Sheet6!A1https://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779554#418779554Just make sure A1 in sheet 7 is =Sheet6!A1Thu, 21 Jan 2010 16:41:52 -0600Sheriff,Cell A2 in sheet 7=INDEX(Sheet6!A:A,MATCH(A1,Sheet6!A:A,0)+5,1)Then drag downhttps://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779546#418779546Sheriff,Cell A2 in sheet 7=INDEX(Sheet6!A:A,MATCH(A1,Sheet6!A:A,0)+5,1)Then drag downThu, 21 Jan 2010 16:40:24 -0600anyonehttps://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779390#418779390anyoneThu, 21 Jan 2010 16:15:54 -0600little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheetif you have a1=Sheet6!A1a2=Sheet6!A6a3=Sheet6!A11and i want to carry on this series downwards eg in a4 i would have =Sheet6!A16 and then A21https://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779158#418779158little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheetif you have a1=Sheet6!A1a2=Sheet6!A6a3=Sheet6!A11and i want to carry on this series downwards eg in a4 i would have =Sheet6!A16 and then A21Thu, 21 Jan 2010 15:23:54 -0600Np :-)https://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779094#418779094Np :-)Thu, 21 Jan 2010 10:13:08 -0600sorry m8..just seen your mail.. thanks again...https://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779090#418779090sorry m8..just seen your mail.. thanks again...Thu, 21 Jan 2010 10:11:32 -0600I replied, both my way and Mr Nibs will do it, what's the sticking point?https://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779086#418779086I replied, both my way and Mr Nibs will do it, what's the sticking point?Thu, 21 Jan 2010 10:09:25 -0600nearly got it but still cant quite crack it... grrrrhttps://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779082#418779082nearly got it but still cant quite crack it... grrrrThu, 21 Jan 2010 10:05:42 -0600Sheriff, in my example your data is in Sheet 1 and your new sheet is sheet 2.Sheet2...A1 = 1B1 = 2C1 = 3D1 = 4A2 =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 =INDEhttps://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779070#418779070Sheriff, in my example your data is in Sheet 1 and your new sheet is sheet 2.Sheet2...A1 = 1B1 = 2C1 = 3D1 = 4A2 =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 =INDEThu, 21 Jan 2010 08:28:57 -0600thats great but just sent you another e mail to see how you did it.. :)https://community.betfair.com/chit_chat/go/thread/view/94038/23451118/excell-help-please?post_id=418779066#418779066thats great but just sent you another e mail to see how you did it.. :)Thu, 21 Jan 2010 08:23:49 -0600