I have an Excel sheet of individuals whos status are Members or Leaders. The members are listed first, then at the last row of each group the leader is listed. The names are in column C, the Status (Member or Leader) in column I. What I want to do is add a last column (Column J) that will extract the names of the members (column C) and list them in column J opposite the leader.
For instance, rows 2, 3 and 4 are members and row 5 is the leader. What I want to accomplish is list the names of members found in column C to column J opposite the Leader. Attached is the sample Excel file, the actual file contains a lot of rows.
Bookmarks