Forum

Pa, Without seeing how you are trying to use the formula it's impossible to say why you are getting that result. I asked how do you want the Hom...

Hi, Do you mean how do you make an absolute reference to a cell? This post explains Absolute References Regards Phil

Hi John, Please attach a workbook with your data when posting. Saves you and us typing everything in again. Please see attached file. I've c...

Hi Pa, So how do you want the Home and Away columns to affect the calculation? What exactly are you trying to calculate? I have a feeling t...

Wayne, Please attach your workbook. I emailed you directly yesterday asking you to do this. The 2 in SUBSTITUTE indicates which instance of the...

Hi Andy, You can raise a ticket on the Helpdesk which will not be publicly seen. Cheers Phil

Thanks. Did my formula do what you needed? Regards Phil

Hi, Please attach all the files you are working with so I don't have to recreate them. Thanks Phil

No worries. The code works through all hyperlinks in the sheet and if they are all listed in Column A then it already does what you are asking. ...

Hi Andy, I've run that code loads of times without error. Have you tried stepping through the code to see where it is generating the error? T...

Hi Daniel, 1 - Right click on one of the dates in the PT 2 - Click on Group in the pop-up menu 3 - In the Grouping dialog box click on Days -...

Hi Pa, Without your workbook working this out took a lot longer than it could have. I'm still not sure if this is what you want. =SUMPRODUCT(--...

Hi Andy, no workbook attached. Regards Phil

Hi Rajsha, This 'kind-of' works but as you haven't supplied the workbook where you are running it, I don't know if it's actually doing what you wan...