Repeat Material Codes

Hi All

If C:C>0, i want my formula to enter the relevant material code in A:A, but i have multiple material codes, how do i make my formula notice the change in material and show the new material value...

Please see attached file

My Logic...

Once i have the material running along side the order, i will use a lookup to show load by time and current material shortages.

I hope this makes sense.

Thanks

Chris..

Hello,

as you can see, the forum software takes out the carefully inserted spaces in your table and your actual data layout is unrecognisable. Pleas post a workbook instead and mock up your expected results. Click Go Advanced below, then the paper clip icon to attach a file.

cheers,

Now, can you upload a file with the desired results? column A is empty. What would you want to see where. Why? What is the logic?

You only have one material code in the data sample. In the real world, there will be many material codes, no? Can you come up with a data sample that is more aligned with the real world and manually put in what you would like to see in column A?

cheers,

Hello, this looks like you are trying to do a pivot table backwards.

Where is the data coming from? Is that the initial, raw data you have?

btw: please don't attach updates of your file to the original question. use a new post instead.

Hello,

there may be other ways, but what I've come up with is this:

use a helper column, for example column F. In F1 enter the formula

=IF(B1="material",ROW(),"")

copy down all rows of data.

Then in cell A2, enter the formula

=IF(AND(C2>0,B2<>"material"),INDEX($C$1:C2,MATCH(99^99,$F$1:F2,1)),"")

copy down.

See attached. You can hide column F if you want.

cheers,

Using sample in post # 1 - perhaps:

Please Login or Register  to view this content.

@DO: Nice!