Reference to a column depends on the column heading

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I am sorry it is proving so difficult!

    In some ways I am pleased - it just shows that I would never have figured it out!

    But I apologise for not explaining it properly at the outset.

  • This code is finding the correct column and the date to look for in the data.

    I'm getting an error in the formula but I can't see why. I'll take another look in the morning, hopefully it will be clearer then

  • It seems to not like the dte part of the formula for some reason?

    Leaving your code as is, but replacing the "dte" with a hard coded text, and it works. I did the same with "iCol" - but it is the "dte" that it doesnt like, which is rather mystifying

  • I have played around with quotes, brackets, spaces etc and cannot get this to work.

    However the attached code does work - looks a bit clumsy, but it works! So it uses 90% of your code, so thank you very much.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!