| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I copy an array in a conditional formula
I am trying to copy an array from one sheet to another sheet as part of a
conditional formula. Something like =IF(D30="","",(L30:N30='sheet3'!L30:N30)) Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I copy an array in a conditional formula
Hi Theo
You can't do that with a formula. You would have to have the formula in each of the 3 cells, e.g. in cell L30 =IF(D30="","",'sheet3'!L30) and modify for the other 2 cells. -- Regards Roger Govier "Theo" wrote in message ... I am trying to copy an array from one sheet to another sheet as part of a conditional formula. Something like =IF(D30="","",(L30:N30='sheet3'!L30:N30)) Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I copy an array in a conditional formula
No.
In L30, put the formula =IF($D30="","",'sheet3'!L30) Then copy across (noting the absolute reference for the column in $D30 to ensure it stays unchanged when you copy across). -- David Biddulph "Theo" wrote in message ... I am trying to copy an array from one sheet to another sheet as part of a conditional formula. Something like =IF(D30="","",(L30:N30='sheet3'!L30:N30)) Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I copy an array in a conditional formula
The problem is that this would have to be copied in a file of approx. 3000
records with 16 data elements each. Thanks for the suggestion "Roger Govier" wrote: Hi Theo You can't do that with a formula. You would have to have the formula in each of the 3 cells, e.g. in cell L30 =IF(D30="","",'sheet3'!L30) and modify for the other 2 cells. -- Regards Roger Govier "Theo" wrote in message ... I am trying to copy an array from one sheet to another sheet as part of a conditional formula. Something like =IF(D30="","",(L30:N30='sheet3'!L30:N30)) Any ideas? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I copy an array in a conditional formula
I would have to do this for a file with approx 3000 records with 16 data
elements each. Therefore I was trying to copy the array, so I would only need one copy per record. Thanks Theo "David Biddulph" wrote: No. In L30, put the formula =IF($D30="","",'sheet3'!L30) Then copy across (noting the absolute reference for the column in $D30 to ensure it stays unchanged when you copy across). -- David Biddulph "Theo" wrote in message ... I am trying to copy an array from one sheet to another sheet as part of a conditional formula. Something like =IF(D30="","",(L30:N30='sheet3'!L30:N30)) Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy an array formula? | Excel Discussion (Misc queries) | |||
| Conditional Formatting/Array Formula | Excel Discussion (Misc queries) | |||
| Conditional Formula - No array | Excel Worksheet Functions | |||
| copy array formula | Excel Worksheet Functions | |||
| Copy An Array Formula | Excel Discussion (Misc queries) | |||
Linear Mode
