I've been having a hard time finding a solution for this problem I'm having.
On Column A is a name of an edit to a certain set of drawings. The drawings are on Row 3, starting at Column E (ie: E4) and the symbols found on row 4 signify which of the drawing sets have the latest revision associated with the change (A4, B4). The Drawing names run in chronological order from left to right (First drawing -> Last Drawing).
I'd like to have a formulate in column C that looks for the furthest symbol on the right of it (Latest Revision) and extract the last 8 characters from the drawing set name above it (which is the date) and populate that date in column C. So moving forward if I made an additional revision, based on me adding a new symbol to the right of the last one, itll pull the date from the name above it automatically.
On Column A is a name of an edit to a certain set of drawings. The drawings are on Row 3, starting at Column E (ie: E4) and the symbols found on row 4 signify which of the drawing sets have the latest revision associated with the change (A4, B4). The Drawing names run in chronological order from left to right (First drawing -> Last Drawing).
I'd like to have a formulate in column C that looks for the furthest symbol on the right of it (Latest Revision) and extract the last 8 characters from the drawing set name above it (which is the date) and populate that date in column C. So moving forward if I made an additional revision, based on me adding a new symbol to the right of the last one, itll pull the date from the name above it automatically.