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

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

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

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

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