•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Grouping similar not duplicate data of various Char lengths.
I have a database of over 30,000 outlets with the task of grouping them by their brand and having a count of how many outlets are under that brand, for example below the brand would be "1 Million" and there are 5 outlets.
The issue is not just the quantity of data but also the various character length ruling out a simple =left() or =unique,
Another example below of different "Acai" brands and the variation of lengths.
Is there a way to automate this or at best create groups that would at least reduce the number from 30,000+ to something more manageable.
Thank you for any help or advice.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#data
#grouping
#brand
#outlets