formula to copy ocurrences...

P

pmarques

I need a formula (or some other tipe of solution)
That Copys ocurrences from columm C to D when the number in A apear
(one or more times) in B.
The data copyed (in D) should be in the same line that the numbe
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
+-------------------------------------------------------------------
 
C

CLR

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
 
P

pmarques

*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.*--------------------------------------------------------------------------
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top