•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
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#google sheets
#Excel alternatives
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#AI formula generation techniques
#formula generator
#excel
#transpose
#sheets
#formula
#function
##spill error
#filter
#merged cells
#$IJ$60:$IJ$503
#$IH$60:$IH$503