While opening an Excel spreadsheet in OneDrive, if you confront an error message saying We ran into a problem completing your request, here is how you can fix it ...
How-To Geek on MSN
Excel's UNIQUE function can't skip columns—unless you use this trick
Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
Hosted on MSN
I loaded a million rows into this spreadsheet app and it barely blinked—and no, it's not Excel
Excel might be the best spreadsheet program ever created, but it has its limitations. One particular limitation is the number of rows it can handle—it can't load millions of rows. Luckily, there's Row ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback