Thread: Can excel find a sequence of numbers from a known total?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Can excel find a sequence of numbers from a known total?
There are 6 ranges....Ron.
Chip highlights only one.
This array formula will show all of them:
=IF((SUM(INDEX(Bin,colm):INDEX(Bin,rowm))=68)*(row mcolm),colm&","&rowm,"")
if put in a 41x41 array.
Bin is the given set of numbers,
rowm is a vertical set of numbers from 1 to 41,
colm is a horizontal set of numbers from 1 to 41.

Reply With QuoteReply With Quote