•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Issue with transpose function when switching from sheets to excel
I'm new to excel and am finding out there are MANY small differences with sheets. I have a table that uses the transpose function just fine in sheets, but in excel it produces a bunch of zeroes.
the formula I'm using is:
=transpose(filter($IJ$60:$IJ$503,$IH$60:$IH$503=AI64))
Do I need to add or remove anything to make it work the same as sheets?
Also, (this one's minor) it worked fine with merged cells for a cleaner look in sheets, but excel made me unmerge the cells where the results go. It kept giving me a #spill error with the merged cells. Any ideas on this?
Thanks for the help
[link] [comments]
Want to read more?
Check out the full article on the original site