Forum Discussion
Solved
Productionflow from row to columns
For a project there is a list of 6 product in which product is given state of producing.
Want to make the list to date of start prep, prod and done. see list on right.
Sharts
NR
1
2
...
- MATCH finds the first hit so can be used to return the row number:
=MATCH("prepare",B1:B10,0)
INDEX gives the nth row of a column, so:
=INDEX(A1:A10,MATCH("prepare",B1:B10,0))
Of course you'd put "prepare" in a separate cell, not in the formula, but you get the idea.
MATCH finds the first hit so can be used to return the row number:
=MATCH("prepare",B1:B10,0)
INDEX gives the nth row of a column, so:
=INDEX(A1:A10,MATCH("prepare",B1:B10,0))
Of course you'd put "prepare" in a separate cell, not in the formula, but you get the idea.
=MATCH("prepare",B1:B10,0)
INDEX gives the nth row of a column, so:
=INDEX(A1:A10,MATCH("prepare",B1:B10,0))
Of course you'd put "prepare" in a separate cell, not in the formula, but you get the idea.