Thread: Formula (or code) return the largest number of duplicates in a list.
View Single Post
  #14   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.

That is great having both formula and VBA.

On my computer both run in about 16 to 20 seconds, and I assume with 13000+ rows that is quite reasonable given the calc's it is doing.

The first 9 rows on the formula sheet column B have no formulas, I assume that has to do with the use of OFFSET in the formula. Just guessing on my part, but why would it be nine rows?

Thanks for the nice work.

Howard
Reply With QuoteReply With Quote