•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to merge repeating zip codes with counts into single count for zip code
I have a file thats a list of customers by zip code with a count, some were extended zip and some were short 5 digits with a count. I made each row a short 5 digit zip, but is there a simple way I can get a combined count for each zip that repeats.
I could kinda manually do it by zip but that would take a really long time.
Im on excel for web from Microsoft 365
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives
#rows.com
#no-code spreadsheet solutions
#row zero
#real-time data collaboration
#real-time collaboration
#zip code
#count
#Excel
#customers
#combined count
#repeating zip codes
#Microsoft 365
#extended zip
#short 5 digit zip