C
cfmartin76
Hello!
I have a little bit of a problem, and I wasn't able to find the
solution anywhere.
I have column A "Title" that is linked with column B "Day of the week".
Each title can have 1, 2 or 3 days of the week (which will then be
column C, D, etc). It looks like this:
TITLE DAY1 DAY2 DAY3
Math Mon Tue
History Tue Fri Mon
English Wed Mon
How can I create a new column that lists all the "titles" that appear
on Monday and a separate column for the ones that appear on Tuesday?
(the names of the new columns would be "Monday", "Tuesday", etc) If a
title has more than 2 days I want that title to appear on the columns
for both days.
It will look like this:
MON TUE WED THU FRI
Math Math English History
History History
English
Is there a macro for this?
Thanks!
I have a little bit of a problem, and I wasn't able to find the
solution anywhere.
I have column A "Title" that is linked with column B "Day of the week".
Each title can have 1, 2 or 3 days of the week (which will then be
column C, D, etc). It looks like this:
TITLE DAY1 DAY2 DAY3
Math Mon Tue
History Tue Fri Mon
English Wed Mon
How can I create a new column that lists all the "titles" that appear
on Monday and a separate column for the ones that appear on Tuesday?
(the names of the new columns would be "Monday", "Tuesday", etc) If a
title has more than 2 days I want that title to appear on the columns
for both days.
It will look like this:
MON TUE WED THU FRI
Math Math English History
History History
English
Is there a macro for this?
Thanks!