excel forumla
Budget: $10 – $30 AUD
we manually input what is going on in our community centre in column c
i require contents of column C to be entered into the dates in coumn E, G, I AND K based on what column a date is and Column c says (match column C with the dates) F, J H, L = C contents reflecting dates which match
This should not take you more than 15 mins.
Meaning that every date in column A matches everything in colums E, G , I AND K - when those columns match you enter the content of colum C with the date in colummn A to the date in columns E, G, I AND K and then enter column C into F, H, J and L
i require contents of column C to be entered into the dates in coumn E, G, I AND K based on what column a date is and Column c says (match column C with the dates) F, J H, L = C contents reflecting dates which match
This should not take you more than 15 mins.
Meaning that every date in column A matches everything in colums E, G , I AND K - when those columns match you enter the content of colum C with the date in colummn A to the date in columns E, G, I AND K and then enter column C into F, H, J and L