Forum Discussion
Splitting a table taking one portion and putting it under the other via LET - file format changed
PeterBartholomew1 - thanks for taking time to look at. I am good - finally - so many people happy now - but me more than any of them. I need to go back to my solution architect role.....
NotSoFastEddie Check it again and look closely. I just redownloaded both files (your original and my version) and they are not the same. I made the changes to the formula directly in cell A2, so the "current state" results match the "desired state" that you hard-keyed below. Scroll to the right and you'll see the results only go to column U in my file, whereas the original file goes all the way to column AM. Compare the files side-by-side and the differences will be obvious.
djclements Thanks again. Merged it into the big spreadsheet and it works beautifully. At least I was on the right path with what I was attempting, just getting some weird results.
That wraps it up for this spreadsheet. Want to thank you for all your help - could not have done it without you.