Login

Search the forums now!

Welcome, Guest. Please login or register.

June 17, 2024, 05:59:39 pm
Pages: [1]   Go Down

Author Topic: Excel formula help  (Read 707 times)  Share 

0 Members and 1 Guest are viewing this topic.

lynt.br

  • Victorian
  • Forum Leader
  • ****
  • Posts: 652
  • Respect: +50
Excel formula help
« on: October 03, 2013, 09:15:15 am »
0
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
Logged
Pages: [1]   Go Up