Showing text in a text string.....

You can use an INDEX/MATCH combination, or possibly VLOOKUP. Can you attach an example workbook (the FAQ describes how to), and then we can try out different formula in there for you?

Pete

Thanks Pete - have attached file to the orginal! It's a bit of a mish mash but i'm having a go at analysing with my mates how people post 'tips' to do with betting etc. Sadly i'm the most clued up on excel.....which isnt saying much!

I see that the latest results are at the top of the sheet - do you insert new blank rows there to maintain that order for new results? It might be simpler to have a column for the date of the fixture and then just add new fixtures at the bottom, and then to sort in reverse date order when you have entered them all.

I'm a bit busy at the moment, so I'll pick this up again tonight.

Pete

Yes Pete excatly what we do, c&p from ESPN website

We haven't really thought about formatting etc. so far just trying to work out how it all works really and if maintaing this is of any use for predicting anything.

That would be great thank you

In the attached workbook I've made use of two helper columns (K and L) to get the appropriate home and away sequence for each result. The last-5 home and away results (or -4 or -3, depending on how many games played) are then shown in column G of the summary table, which you might find more convenient to move to another sheet. If you insert some new rows from row 2 so that you can accommodate new fixtures, then you should copy the formulae in K and L upwards to K2:L2. All the formulae will adjust automatically when you insert new rows.

Hope this helps.

Pete

Peter,

Thats perfect! Just what we were after

I have now one problem! I have inserted the rows and put in this weekends results, but now where it returns W/D/L I get a #NAME? error in the cell?

The error occurs when you insert the cells to the top of sheet?

Not sure why you are getting #NAME error - can you attach the faulty sheet?

Pete

john2.xlsx

All i've done is insert a line?!!?

When I open the file I cannot see any #NAME errors (or any kind of errors).

Mind you, I do get a Security Warning that Data Connections have been disabled, so maybe that has something to do with it.

I'm not sure if I can help you any further - it seems to work fine for me (you would need to copy the formulae from K3:L3 up into the blank cells above).

Pete

Thanks anyway Pete - could well be a works computer sercurity measure? I know some people can't open up Macro's in work.

Might try it on my Dad's personal laptop and see if that fixes.

thank you very much though - much appreciated!!!!