colin

  1. O

    Excel help with formulaes to produce appearance records for weekly football logs

    Hey i log information for my weekly work football and am trying to automate more of my collection of data. I have a set of data that looks like this: <tbody> <tbody> Date Game No. Win Draw1 Draw2 Loss Win Goals Draw1 Goals Draw2 Goals Loss Goals Win Scorer Draw1 Scorer Draw2...
  2. S

    Syntax error in defining range using a worksheet function

    Greetings, I am receiving a compile error on this line: h = worksheetfunction.Slope((Cells(yy,ww):Cells(2,ww)),(Cells(yy,xx):Cells(2,xx))) the first colin in the Y's range is highlighted. What is the correct syntax here again? Thanks!
  3. E

    Rearranging first name and surname in Excel

    Hi there, I have a list of names in excel in the below format; however I need to re-arrange the cells to read "Colin Smith", (dropping the ,). <tbody> Smith, Colin Is there a simple way of doing this please? Many thanks </tbody><colgroup><col></colgroup>

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