Totally lost - Greenhorn question --> filling cells

[roth_georg]

Totally lost - Greenhorn question </SPAN></SPAN>à</SPAN></SPAN> filling cells</SPAN></SPAN></SPAN>

Hi all</SPAN></SPAN>

I guess I have a real greenhorn question but I did not manage to get this done with regular formulas and I’m not used to macros. I hope you can help.</SPAN></SPAN>

The problem is pretty good described in the picture below.</SPAN></SPAN>


https://plus.google.com/u/0/photos?tab=wq#photos/107223412229072028623/albums/posts


I want to move the values in B3 and C3 to every line where I have value = 1in column A. I can do that quite easily for one block with if (A4=1,B$3). But this does not work for rows after row 11. Here I would need now if (A4=1,B$10). I would need something like if cell value in column A = 2 or T do not consider values above. And so on and so…</SPAN></SPAN>
I guess this needs a bit of macro. Any idea??</SPAN></SPAN>

Thanks a lot for your help.</SPAN></SPAN>
Georg</SPAN></SPAN>

 

[Peter_SSs]

I really would like to provide you the example but I have not found out how I can share a sampe excel file. Maybe you can help?

You can post small screen shots directly in your post as TheCman81 and I have done. See my signature block for how to do it. A small representative sample is usually better than a large actual file anyway.

SOLVED!!!! Wrong settings!! I have replaced "," with ";"?

Yes, that can vary with different language/regional versions of Excel. You will always need to keep that in mind in the forum as the majority of users here will use a "," where you may need a ";"

I will check correctness!!

It will be good to know if the simple formula does what you want, and if not, further sample data and expected results.

 

[roth_georg]

Guys - you are incredible. The smal formula works, it seems so far!!

Have a great easter. Georg

 

[Peter_SSs]

Guys - you are incredible. The smal formula works, it seems so far!!

Have a great easter. Georg

Great! Thanks for letting us know.