Chandler8
New Member
- Joined
- Jun 29, 2022
- Messages
- 23
- Office Version
- 365
- 2016
- Platform
- Windows
Hello all, so I need a formula to grab all of the peoples names in random cells from one sheet into another sheet while creating a straight down list of the names! And, if there is a way to (prompt/warning) when there is a duplicate name while not posting it to the list that would be very helpful! I have listed some pictures for examples below. Thank you very much!
Ex..xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Random_Guest 1 | Random_Guest 2 | Random_Guest 3 | Random_Guest 4 | Random_Guest 5 | ||
2 | Billy Bob | Kellie Bob | Bradyn Bob | ||||
3 | Kayla Ming | Joe Smith | |||||
4 | Bobby Doe | Joey Lawrence | Larry Bill | John Corley | Kelc Corley | ||
5 | Ashton Piercing | ||||||
6 | Ashur Low | Tim Low | |||||
7 | Lauv Smiley | ||||||
8 | Lola Jean | Michael Jean | |||||
9 | Kayla Pearson | Michelle Pearson | |||||
10 | David Kurt | Lindsey Kurt | Kiley Simb | Larry Simb | |||
Names |
Ex..xlsx | |||
---|---|---|---|
A | |||
1 | Guest_List_Names | ||
2 | Formula Here/to generate the names with ability to drag down (one name per cell) | ||
3 | |||
4 | |||
5 | |||
6 | |||
7 | |||
8 | |||
9 | |||
10 | |||
11 | |||
12 | |||
13 | |||
14 | |||
15 | |||
16 | |||
17 | |||
18 | |||
19 | |||
20 | |||
21 | |||
22 | |||
23 | |||
24 | |||
25 | |||
26 | |||
27 | |||
28 | |||
29 | |||
30 | |||
List |