Find Unique ID - then find last occurrence of a value

Hi all,
I have an excel file which pulls in .CSV files from the web. The data looks as below;

Image1.PNG


As you can see, there is the unique ID (Column Document.Column3), then in Column (Document.Column4) there are two occurrences of the word "Execution" - different ID's can have different no's of occurrences of this row containing "Execution". What I am trying to do is find the Unique ID (e.g. DanK01) and then from that find the position of the last occurrence of the word Execution.


So far I have the following;

Please Login or Register  to view this content.

This is not returning an error- but is just returning a blank cell.

Any advice appreciated as always.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi all,
Sample excel file with Data, Before and mocked up After sheet attached.

Thanks
Daniel

Hi JeteMc,
Thanks for the response, what I actually ended up with was a helper column in Column OO of the Data tab. On the summary sheet, I then used the following formula;

Please Login or Register  to view this content.

The cell H4 contained the UniqueID and the word "Execution" which could be found within column OO of the data tab. Worked as expected.


Thanks
Daniel