Fill down numbers into column D using column C

[bjnockle]

Looking for formula to fill down numbers (1s and 0s) into column D using column C as basis. See attached file. Sample below as well. Thanks.


Formula Explanation
Firm Name: Yukon
For example, firm name Yukon is from A2:A9 and Sales 1 column C2=1 and C3=1 and C4:C9=Blank (""). Formula should be setup to return D2:D9=1 for Yukon.

Firm Name: 5D Systems Corp.
For example, firm name 5D Systems Corp. is from A26:A34 and Sales 1 column C26:C34="" (blank). Formula should be setup to return D26:D34= 0 for 5D Systems Corp..

Please Login or Register  to view this content.

[queuesef]

Try putting this in D2 ~

Please Login or Register  to view this content.

. This will work, BUT you MUST have your firm names EXACTLY the same... so Koko Cisco is NOT the same as KoKo Cisco (has an extra space before Cisco.

[bjnockle]

queuesef: The firm names are more than what I have in the sample. Firm name is over 10,000 and this formula will not work. Please take a look and adjust. Thanks.

[samba_ravi]

D2=IF(A2=A1,D1,IF(COUNTIFS(A$2:A$34,A2,C$2:C$34,1),1,0))
Try the above, copy and paste towards down

[queuesef]

I answered your question as is. Please try to take what is there and revise it yourself. You did NOT provide more info/Firms, NOR did you provide any pattern. Base on your limited info, I had solved the problem. You need to have more info OR a PATTERN. Vba COULD be an answer....vLookup could also work....you would need to create Unique list of names and the corresponding value for that firm. In Future, please provide enough info to solve your issue and it would be easier. Most people don't like to come back and revisit a question that was poorly asked.

[bjnockle]

samba_ravi: Outstanding formula. Works like charm. Thanks.

[bjnockle]

queuesef: Great solution based on requirements and explanation. Thanks.