Forum

@debaser Hi Velouria, many thanks for this - I added your formula to my main table and it appears to be working well! I'll test it out a little more t...

@riny Hi Riny, many thanks for taking the time to look at this in such detail. I should have thought to look at PowerQuery for this problem, I am goin...

Hi Riny,   Many thanks for getting back to me so quickly. I took your advice and made a table, I was able to generate a couple of pivot table...

Fantastic Velouria, super simple and it works a treat! Many thanks for the help. Alan

Thanks Riny, and apologies - please see the attached, hopefully this one makes sense! Alan

Hi Mynda, Sorry for the delay replying. I seem to have got it working though to be honest I sort of stumbled through it rather than having a "ligh...

Hi Mynda, Many thanks and of course the article was very helpful - I have almost got it back to the previous iteration. The file is very large so ...

Thanks for the reply Anders - there does not seem to be a feature for this yet - I do see some VBA based solutions on the web - I will give them a go....

Well there's another special moment for me 🙂 Many thanks Velouria and apologies Myanda! I tried writing the formula from scratch when I received ...

Hi Mynda, Many thanks for the help as always! I tried the TEXT function wrap as you suggested but I am still getting the same display, (updated fi...