I have some data in non arranged order and I need to rearrange it in different place (see example below). The logic is:
- first row below "orange themes" cells look C1:C5 for "orange" and returns first occurrence
- second row below "orange themes" cells look C1:C5 for "orange" and returns second occurrence
- etc
here is example I made:
I have been scratching my head to figure out excel formula to do that, but with no success. All the help would be appreciated!
- first row below "orange themes" cells look C1:C5 for "orange" and returns first occurrence
- second row below "orange themes" cells look C1:C5 for "orange" and returns second occurrence
- etc
here is example I made:
![example62978.png](/board/proxy.php?image=https%3A%2F%2Fi.uppaa.fi%2F2017%2F10%2F27%2Fexample62978.png&hash=f68fddb6ab68e64f8ee45f705ac5a7c7)
I have been scratching my head to figure out excel formula to do that, but with no success. All the help would be appreciated!