View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
knoertje[_7_] knoertje[_7_] is offline
external usenet poster
 
Posts: 1
Default combination of numbers in lottery

I do have the numbers in column B5 to H5, which actually make it seve
numbers. The latest numbers are inserted

in Row 5 every time, because of other formulas. So the latest is alway
on top starting in B5. The order of the

numbers in the combination I'm looking for don't matter. So my meanin
is to give Excel 2 or 3 or 4 numbers and

let Excel find if that combination of 2, 3 or 4 numbers excist. If tha
combination excist I want Excel to

highlight or color the combination in the sheet or tell me that i
excist. But if that combination doesn't

excist I want it to either do nothing or give a message or so .

The formula given don't seem to work after adjusting it to my columns

--
Message posted from http://www.ExcelForum.com