Find number of occurrences in list and organize from most to least

SUCCESS!

2016030,8002830
AA01810,3144716
AA01800,1707448
AA01790,1570020
BDC JON,1419526
C104680,1001700
SK BDC ,818976

One final question, if I upgrade my OS will it possibly make macros with regex fail?

1 Like

Short Answer: No.

Highly unlikely, but we won't know for sure until you try.
Unfortunately Apple sometimes (often?) breaks things with their OS updates. In particular, I would stay away from HIgh Sierra for now.

I'm running macOS 10.12.6, so you should be good with Sierra.

OK thanks!

Also just a bit of extra proof I ran it with the longer data set from the thread you helped me with a couple days ago and it seemed to do the trick! Cheers.

2016030,4126350
AA01810,3809888
SK BDC ,3630565
BDC 029,3078343
AA01770,3042224
BDC JON,2980010
BDCR126,2899252
BDC 031,2755841
BDC 030,2672556
Take22.,2212821
080119-,1760015
AA01790,1435596
LYDIATE,1256681
AA01750,1139898
BDCR121,1059820
AA01800,1037915
BDCR125,1010745
Batt Da,957192
BDC 020,940016
BDC 043,879462
SK RF b,752220
YWCAS07,663637
BDCR110,538853
C104680,492210
C104690,457111
Take08.,424661
BDC 033,384069
AA0180-,373772
C104700,261341
bdc 006,194805
AA01780,77895
C104660,57887

1 Like