View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CHRIS K
 
Posts: n/a
Default 1 TO 9 EXCEPT CELL CONTENT

if I have the number 5 in cell a1 how can I get 1,2,3,4,6,7,8,9 to appear in
cell c1?
ie 1-9 but not 5
then if there are two numbers in a1 eg 2 and 7 I want 1,3,4,5,6,8,9 to
appear in cell c1
Any suggestions?
--
CHRISK