Reply to thread

Welcome to Old Skool Anthems

The Old Skool Resource. Since 1998.

Join now

Message: <blockquote data-quote="johns_ar" data-source="post: 422677" data-attributes="member: 342">sort the master list into country order (presuming youve got a diff column for country)then theres bound to be big chunks of them from the same country so just remove them in chunksim sure you could write a formula tho but excel is a twat and ive never bothered with it - something like if col b = anything but UK clear the cellim certain u can do something like that - google is your friend <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink    ;)" loading="lazy" data-shortname=";)" />youll defo get answer off there - 100%</blockquote>

Top Bottom