chartmunger
New Member
- Joined
- Jun 30, 2022
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi -- I need some help with a problem.
Each tab (sheet) is a survey, and I need to create a summary tab that automatically combines user inputs:
Other information:
Each tab (sheet) is a survey, and I need to create a summary tab that automatically combines user inputs:
- Users (my colleagues) will fill out a bunch of random names under each column
- The title on Row 1 of each tab is fixed & the same
- The names below are the user inputs: there will be duplicates among the users within the same column (e.g. Mark's input under "Amazon" might have overlaps with Tim's input on his own tab), and I need to remove the duplicates for same columns only (in case there are 2 "John Doe30" under Facebook and Google)
Other information:
- # of columns: <=20, but we might add or remove columns in the future
- # of rows (inputs): <=20
- # of sheets: <=20
- This sheet is a tool that we will update (asking for new user inputs) from time to time, so we want automation