1 min readfrom 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

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com