| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to repeat numbers in different cells?
If I fill in a number in one cel I want it automaticly repeated in another,
specified cel. How can I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to repeat numbers in different cells?
If you type the number in A1, you can use:
=A1 or =if(a1="","",a1) in a cell on that same sheet In a different sheet: =sheet1!a1 or =if(sheet1!a1="","",sheet1!a1) HWDijkhuizen wrote: If I fill in a number in one cel I want it automaticly repeated in another, specified cel. How can I do that? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do not allow repeat numbers | Excel Discussion (Misc queries) | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| IN EXCEL, HOW CAN I TYPE IN NUMBERS AND HAVE THEM NOT REPEAT? | Charts and Charting in Excel | |||
| How to make repeat long numbers shortcut ? | Excel Worksheet Functions | |||
| If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
Linear Mode
