Forum Discussion
RESOLVED issue: TRANSPOSE function of Excel is not working (try the alternative C+S of the keyboard)
Hi there, I have encountered an issue with an excel array function using a Windows computer. I am sure the formula and items in the function are all used correctly. I can replicate the same o...
wendy20 But did it work OK before you started redoing my formulae? Not sure why you get the value error. According to the help screens that will occur if you do NOT enter the formula with C-S-E where your Excel version requires it. You tagged your original post with "Office365". If that means that you are a MS365 subscriber using a current version of Excel, you wouldn't have to worry about C-S-E.
Yes, I can see the results of your working perfectly fine.
I just can't edit anything of the formula.
I believe I have the Office 365 Subscription. I tried to do it again by just hitting only E. The alert of ' you can't change part of an array' always pops out.