Good morning. My problem is....
I receive multiple spreadsheets, some of the data is duplicated and I need it combined into one spreadsheet. I have tried filtering and removing duplicates but neither work.
The data is as follows:
Column C Column D Column E to N
# Subject Dates
Row 3 will have:
123 Happy 15 Sep 13 30 Sep 13 1 Oct 13
Row 4 could have:
123 Happy 15 Oct 13 17 Mar 14 etc
Row 3 needs to be displayed:
123 Happy 15 Sep 13 30 Sep 13 1 Oct 13 15 Oct 13 17 Mar 14 etc
Row 4 needs to be deleted.
I do not always have duplicate rows.
I am probably missing something completely silly. Your assistance is much appreciated.
Thank you
I receive multiple spreadsheets, some of the data is duplicated and I need it combined into one spreadsheet. I have tried filtering and removing duplicates but neither work.
The data is as follows:
Column C Column D Column E to N
# Subject Dates
Row 3 will have:
123 Happy 15 Sep 13 30 Sep 13 1 Oct 13
Row 4 could have:
123 Happy 15 Oct 13 17 Mar 14 etc
Row 3 needs to be displayed:
123 Happy 15 Sep 13 30 Sep 13 1 Oct 13 15 Oct 13 17 Mar 14 etc
Row 4 needs to be deleted.
I do not always have duplicate rows.
I am probably missing something completely silly. Your assistance is much appreciated.
Thank you
