| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cells
Hi,
Column BD in my spreadsheet has a list of names and i would like to link this column to column A so that they both show the same list of names. However, if there is no name entered in column BD, i would like column A to remain blank. I've tried doing "paste special" and clicking on "paste link" but that puts a zero in column A if there is nothing entered into column BD. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking cells
copy this formula down in A1:
=if(isblank(bd1)=true,"",bd1) "Shannan" wrote: Hi, Column BD in my spreadsheet has a list of names and i would like to link this column to column A so that they both show the same list of names. However, if there is no name entered in column BD, i would like column A to remain blank. I've tried doing "paste special" and clicking on "paste link" but that puts a zero in column A if there is nothing entered into column BD. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking cells
hi
another way. =if(bd1="","",bd1) copy down as far as needed. Regards FSt1 "Shannan" wrote: Hi, Column BD in my spreadsheet has a list of names and i would like to link this column to column A so that they both show the same list of names. However, if there is no name entered in column BD, i would like column A to remain blank. I've tried doing "paste special" and clicking on "paste link" but that puts a zero in column A if there is nothing entered into column BD. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Cells | Excel Worksheet Functions | |||
| Linking cells into empty cells in another worksheet | Excel Discussion (Misc queries) | |||
| linking several cells into one | Excel Worksheet Functions | |||
| Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
| Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel | |||
Linear Mode
