G
Guest
Greetings,
I have over 400 rows of data where Column 1 is text (project titles) and
Column 2 is a start date and Column 3 is an end date. In each of the date
columns, there are duplications.
I want to get these start and end dates into another spreadsheet which is
formatted like a calendar. However, I gather VLOOKUP on its own won't work
with the duplications, and when the dates in the first spreadsheet aren't in
chronological order.
There may be other ways of solving this, but my immediate thoughts were to
insert a new sheet search for all duplications in Column 2 and then
concatenate the corresponding text in column 1. I then need to find some way
of getting the concatenated text into the right day in the calendar.
Any suggestsions gratefully received.
I have over 400 rows of data where Column 1 is text (project titles) and
Column 2 is a start date and Column 3 is an end date. In each of the date
columns, there are duplications.
I want to get these start and end dates into another spreadsheet which is
formatted like a calendar. However, I gather VLOOKUP on its own won't work
with the duplications, and when the dates in the first spreadsheet aren't in
chronological order.
There may be other ways of solving this, but my immediate thoughts were to
insert a new sheet search for all duplications in Column 2 and then
concatenate the corresponding text in column 1. I then need to find some way
of getting the concatenated text into the right day in the calendar.
Any suggestsions gratefully received.