1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I've got a large document I need to sort.

I am sorting on a Company Name column. This has a laundry list of repeats as each line is a different entry for the same Company Name. I need to bring back a list of results for 300 Company Names. My first guess was to just use the filter feature and do that 300 times, but that doesn't seem like the best way to handle it. Is there something I'm missing or is that really the best way to handle this?

submitted by /u/mucinexmonster
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#large dataset processing
#Company Name
#sorting
#filter feature
#repeats
#entries
#document
#results
#handle
#list
#best way
#guess
#large
#column
#each line