ATAR Notes: Forum

General Discussion => General Discussion Boards => Technology and Gaming => Topic started by: lynt.br on October 03, 2013, 09:15:15 am

Title: Excel formula help
Post by: lynt.br on October 03, 2013, 09:15:15 am

Hi everyone,

Looking for a little help with an excel spreadsheet formula. I'm trying to create a spreadsheet that allows me to enter in a list of class times, and then have a cell which tells me if a particular time clashes with another subject, and importantly, display which subject or subjects it clashes with.

For example, the spreadsheet should look like something as follows:

CLASSES        TIME             CLASH?
CLASS A        Mon 2pm
CLASS B        Mon 3pm        Class D, Class E
CLASS C        Tue 4pm
CLASS D        Mon 3pm         Class B, Class E
CLASS E        Mon 3pm          Class B, Class D


Does anyone know a formula I could use for the 'Clash' column that could do this? I figured something with the VLOOKUP formula but I've forgotten almost everything about excel! Assume that the 'Time' column will have some sort of standardised input template.

Thanks