Hi all,
New here and would really like some help with a formula.
(Table created for clarity) I would need the formula to firstly find the persons name in the first Row, once it has been found it would look along the row and return a specific cell (For this instance say its the second row), it would then in the next cell to the returned information do the search again but ignore the previous returned result and return a different one.
Say we wanted to know the result from the third row for Katie for all of her accounts, the first returned result in the cell would be 'Open 1st', then to the right of that result it would return the next one 'Closed 5th', then lastly 'Open 2nd', and so forth until it has returned all results.
The only sort of duplicates I dont want returned is when its from the same cell, if the same text appears on a different cell then that is fine.
<tbody>
</tbody>
Thanks in advance for the help if its possible, it would be a massive help for what is needed to be done with over 20000 accounts.
New here and would really like some help with a formula.
(Table created for clarity) I would need the formula to firstly find the persons name in the first Row, once it has been found it would look along the row and return a specific cell (For this instance say its the second row), it would then in the next cell to the returned information do the search again but ignore the previous returned result and return a different one.
Say we wanted to know the result from the third row for Katie for all of her accounts, the first returned result in the cell would be 'Open 1st', then to the right of that result it would return the next one 'Closed 5th', then lastly 'Open 2nd', and so forth until it has returned all results.
The only sort of duplicates I dont want returned is when its from the same cell, if the same text appears on a different cell then that is fine.
Katie | 20/06/1984 | Open 1st | |
John | 06/02/1978 | Open 2nd | |
Peter | 31/01/1991 | Closed 1st | |
Katie | 20/06/1984 | Closed 5th | |
Suzie | 15/12/1988 | Open 1st | |
Katie | 20/06/1984 | Open 2nd |
<tbody>
</tbody>
Thanks in advance for the help if its possible, it would be a massive help for what is needed to be done with over 20000 accounts.