Thread: Formula (or code) return the largest number of duplicates in a list.
View Single Post
  #10   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.
F1 is the query value
F2 is the formula value of the max consecutive occurrences.

I still get an error when F1 is = to the Value in F2.
If F1 is one less than F2 then it runs okay. But gives a false return.


https://www.dropbox.com/s/73vlatpid3...ries.xlsm?dl=0

The button has the last code you posted on it has XX in the sub title.

Howard
Reply With QuoteReply With Quote