Thread: count how long it will takes for a number to repeat
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sierra spiegel sierra spiegel is offline
external usenet poster
  
Posts: 18
Default count how long it will takes for a number to repeat
I need help creating a equation to count how long it takes for a number to repeat. For example:

1 2 3 4 5 6 7 8 1

so it takes 7 calls for number 1 to repeat.

thanks

EggHeadCafe - Software Developer Portal of Choice
XML/XSL VB Tester
http://www.eggheadcafe.com/tutorials...vb-tester.aspx
Reply With QuoteReply With Quote