| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
