Carl_London
New Member
- Joined
- Feb 28, 2023
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
Hello good people,
I hope someone can help me. I need to merge the contents of 3 worksheets (Oct, Nov, Dec) into a new worksheet called Total.
Each of Oct, Nov, Dec contain a list of entries (rows) starting at row 5. On each of the three workshet Column A is a unique ID and Column B is a date.
In the Total Worksheet I would to only show the full row for each entry, but only the first date the unique ID occurs.
Can someone help with a formula please, I would prefer not to use VBA.
Thanks
Carl
I hope someone can help me. I need to merge the contents of 3 worksheets (Oct, Nov, Dec) into a new worksheet called Total.
Each of Oct, Nov, Dec contain a list of entries (rows) starting at row 5. On each of the three workshet Column A is a unique ID and Column B is a date.
In the Total Worksheet I would to only show the full row for each entry, but only the first date the unique ID occurs.
Can someone help with a formula please, I would prefer not to use VBA.
Thanks
Carl