| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to copy ocurrences...
I need a formula (or some other tipe of solution) That Copys ocurrences from columm C to D when the number in A apears (one or more times) in B. The data copyed (in D) should be in the same line that the number apears in B. The example (attached) should Help I have tried something like =IF(COUNTIF($A$2:$A$10;B2) =1;C2;"") but doesn't works Thanks in advanced :) +-------------------------------------------------------------------+ |Filename: Example 2.zip | |Download: http://www.excelforum.com/attachment.php?postid=4313 | +-------------------------------------------------------------------+ -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=508215 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to copy ocurrences...
Put this in D1 and copy down...........
=IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),"",IF(VLOOKUP(A1 ,B:B,1,FALSE)=A1,C1,"")) Vaya con Dios, Chuck, CABGx3 "pmarques" wrote: I need a formula (or some other tipe of solution) That Copys ocurrences from columm C to D when the number in A apears (one or more times) in B. The data copyed (in D) should be in the same line that the number apears in B. The example (attached) should Help I have tried something like =IF(COUNTIF($A$2:$A$10;B2) =1;C2;"") but doesn't works Thanks in advanced :) +-------------------------------------------------------------------+ |Filename: Example 2.zip | |Download: http://www.excelforum.com/attachment.php?postid=4313 | +-------------------------------------------------------------------+ -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=508215 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to copy ocurrences...
*Didn't work for me... D12 = 0 and D13 = 0 should give D12 = dfh and D13 = dfj I'm working in excel 97... Thanks the same.*-------------------------------------------------------------------------- CLR Wrote: Put this in D1 and copy down........... =IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),"",IF(VLOOKUP(A1 ,B:B,1,FALSE)=A1,C1,"")) Vaya con Dios, Chuck, CABGx3 "pmarques" wrote: I need a formula (or some other tipe of solution) That Copys ocurrences from columm C to D when the number in A apears (one or more times) in B. The data copyed (in D) should be in the same line that the number apears in B. The example (attached) should Help I have tried something like =IF(COUNTIF($A$2:$A$10;B2) =1;C2;"") but doesn't works Thanks in advanced :) +-------------------------------------------------------------------+ |Filename: Example 2.zip | |Download: http://www.excelforum.com/attachment.php?postid=4313 | +-------------------------------------------------------------------+ -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=508215 -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=508215 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to copy ocurrences...
More ideas please. Thanks -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=508215 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to copy ocurrences...
I'm sorry....evidently I mis-understood what you are looking for. Perhaps
you could elaborate, giving specific cell numbers with values and what results exactly are expected in some simple model.....then maybe we can help more..... Vaya con Dios, Chuck, CABGx3 "pmarques" wrote in message ... *Didn't work for me... D12 = 0 and D13 = 0 should give D12 = dfh and D13 = dfj I'm working in excel 97... Thanks the same.*---------------------------------------------------------------------- ---- CLR Wrote: Put this in D1 and copy down........... =IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),"",IF(VLOOKUP(A1 ,B:B,1,FALSE)=A1,C1,"")) Vaya con Dios, Chuck, CABGx3 "pmarques" wrote: I need a formula (or some other tipe of solution) That Copys ocurrences from columm C to D when the number in A apears (one or more times) in B. The data copyed (in D) should be in the same line that the number apears in B. The example (attached) should Help I have tried something like =IF(COUNTIF($A$2:$A$10;B2) =1;C2;"") but doesn't works Thanks in advanced :) +-------------------------------------------------------------------+ |Filename: Example 2.zip | |Download: http://www.excelforum.com/attachment.php?postid=4313 | +-------------------------------------------------------------------+ -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=508215 -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=508215 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| copy formula using same references | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Linear Mode
