arsenal

  1. T

    Return Column name from results in grid

    Hi, I hope yo can help I've a grid with home team on the y axis and away team on the x. I've each fixture where the teams meet within the grid (so Arsenal v Leicester = 1, Leicester v Arsenal = 31 e.g.) <tbody> <colgroup><col><col><col><col><col><col></colgroup><tbody> Arsenal Bournemouth...
  2. W

    Auto Fill Problem

    Hi All - I have a spreadsheet which is based on the english premier league. In cell C4 and E4 is where I type in the scores for Team 1 (Arsenal) and I paste this formula into F4 with some conditional formatting <tbody> <e4,"lose",if(c4=e4,"draw")))<...
  3. W

    If function to fill next cell

    I'm I only really know basic excel but I'm trying to set up a spreadsheet to record football teams and results as games occur Arsenal win Man u draw Chelsea lose Arsenal lose Chelsea draw I then want on another sheet to record all this information by team i.e (based on the data above) to...
  4. R

    Find text after the line break

    Hi, Can anyone help me? I need to extract text after the last line break within the cell. For example, from cell below, Добавление нового SLIP во входящем перестраховании: ARSENAL / 2/16-86_7-0000000041 Начисление перестраховочной премии по входящему перестрахованию (по рискам принятым в...
  5. E

    which teams were removed

    Hi, I have a long list of soccer teams in each cell example like the one below from a website data. B1 LIVERPOOL B2 CHELSEA B3 ARSENAL B4 MAN UNITES etc... Once a week I udate data by pressing, data, refresh all, so teams will change from week to another. I want a formula that the new...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top