See attached.
Problem. If B <> Closed or Resolved, then I need to find the last column with data-2. Example, number 3 would be 700.10.1.1
I know how to do the IF and get the last column with data, but not how to get the 2nd to last column with data.
Thank you.
Bookmarks