Finding last occurrence cell of a mu[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Item
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45685
[/TD]
[TD]2-Jun-2019
[/TD]
[TD]Submitted (Jansson [Requestor])
[/TD]
[TD]4-Jun-2019
[/TD]
[TD]Submitted (Jansson[Requestor])
[/TD]
[TD]3-JUN-2019
[/TD]
[TD]
<colgroup><col width="64"></colgroup><tbody>
[TD="class: xl66, width: 64"]Submitted (Monica [Admin])
[/TD]
</tbody>[/TD]
[TD]6-JUN-2019
[/TD]
[TD]
<colgroup><col width="64"></colgroup><tbody>
[TD="class: xl66, width: 64"]Submitted (Mahesh [Admin])
[/TD]
</tbody>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25698
[/TD]
[TD]8-JUN-2019
[/TD]
[TD]Submitted (Peter [Requestor])
[/TD]
[TD]10-JUN-2019
[/TD]
[TD]Submitted (Nagraj [Admin])
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
ltiple partial text and retrieving contents adjacent to that cell . Below
table shows how my data looks.
In the result file I need to display as below. If you notice the 1 row had submitted [Requestor] status twice and I need the date from 2nd occurrence of action. I tried using INDEX and MATCH but was not successful Can anyone help me with a formulae to retrieve the date beside the occurrence of a text.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item
[/TD]
[TD]Submitted ([Requestor])
[/TD]
[TD]Submitted ([Admin])
[/TD]
[/TR]
[TR]
[TD]45685
[/TD]
[TD]4-Jun-2019
[/TD]
[TD]3-JUN-2019
[/TD]
[/TR]
[TR]
[TD]25698
[/TD]
[TD]8-JUN-2019
[/TD]
[TD]10-JUN-2019
[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Item
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD]Action date
[/TD]
[TD]ACTION TYPE PERFORMED BY
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45685
[/TD]
[TD]2-Jun-2019
[/TD]
[TD]Submitted (Jansson [Requestor])
[/TD]
[TD]4-Jun-2019
[/TD]
[TD]Submitted (Jansson[Requestor])
[/TD]
[TD]3-JUN-2019
[/TD]
[TD]
<colgroup><col width="64"></colgroup><tbody>
[TD="class: xl66, width: 64"]Submitted (Monica [Admin])
[/TD]
</tbody>
[TD]6-JUN-2019
[/TD]
[TD]
<colgroup><col width="64"></colgroup><tbody>
[TD="class: xl66, width: 64"]Submitted (Mahesh [Admin])
[/TD]
</tbody>
[TD][/TD]
[/TR]
[TR]
[TD]25698
[/TD]
[TD]8-JUN-2019
[/TD]
[TD]Submitted (Peter [Requestor])
[/TD]
[TD]10-JUN-2019
[/TD]
[TD]Submitted (Nagraj [Admin])
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
ltiple partial text and retrieving contents adjacent to that cell . Below
table shows how my data looks.
In the result file I need to display as below. If you notice the 1 row had submitted [Requestor] status twice and I need the date from 2nd occurrence of action. I tried using INDEX and MATCH but was not successful Can anyone help me with a formulae to retrieve the date beside the occurrence of a text.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Item
[/TD]
[TD]Submitted ([Requestor])
[/TD]
[TD]Submitted ([Admin])
[/TD]
[/TR]
[TR]
[TD]45685
[/TD]
[TD]4-Jun-2019
[/TD]
[TD]3-JUN-2019
[/TD]
[/TR]
[TR]
[TD]25698
[/TD]
[TD]8-JUN-2019
[/TD]
[TD]10-JUN-2019
[/TD]
[/TR]
</tbody>[/TABLE]
