Search for value and return value from previous row

[kazman101]

HI All

Wondering if anyone can help, I have an excel sheet that has a list of status transitions, in the sheet there are system generated transitions because a user has forgotten to perform an action

I need to pull out a list of the userids involved which is in Column I, however if the system performs a transaction it shows the system userID "AUTO_UPDATE" the actual user ID is contained in either the previous row or the following row

does anyone know of a way I can put together a list of these users

 

[hiker95]

kazman101,

You are very welcome.

Glad I could help.

Thanks for the feedback.

Come back anytime.