Thread: Formula (or code) return the largest number of duplicates in a list.
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default Formula (or code) return the largest number of duplicates in a list.
On Tuesday, December 9, 2014 7:28:37 AM UTC-8, Claus Busch wrote:
Hi again,

Am Tue, 9 Dec 2014 16:26:31 +0100 schrieb Claus Busch:

the code is faster if you delete the formula column

if you write Appliation.ScreenUpdating = false
the code will also a little bit faster.

I did both of those suggestions and the time is about half.

Good stuff and many thanks.

Howard
Reply With QuoteReply With Quote