Range N5:S15 (6 wide, 11 deep) is named range "drawn", and is either empty,
or random whole numbers between 1 and 49, which may include duplicated
numbers.
Have a 7x7 matrix (49 cells) - to display EITHER blanks OR the numbers 1 to
49, IN ORDER in rows, IF the number appears in "drawn" range.
So - if the number 7 appears once, or more than once(immaterial) then "7"
should appear in the 7th cell, top row
Am bogged down with the IF(COUNTIF) which I thought was the right route.
Help? please? Silvabod
Bookmarks