Home/ Questions/Q 7169
Next
In Process
Computing Staff
  • 6
Asked: 2021-11-23T10:07:00+00:00 In:

Excel Formulas To Show Clashes – How To Set Up Aspreadsheet

  • 6

I need to create a spreadsheet which will show clashes, i am an administrator timetabling and i need a sheet which will pick up room/student clashes. I am using a sheet created by another locality which has been set up to highlight the rows in yellow which are clashing and it flashes and states Clash in a column at the end. If i click in ‘show formula’ and then click in the cell at the end with the title Clash? i get the following formula =IF(O2>0,”Clash * “&O2;,””), any help with setting up my own sheet would be much appreciated! 🙂

Share

    1 Answer

    1. any help with setting up my own sheet

      You haven’t provided any information on what your looking for.

      You have a spreadsheet that does what you want,
      so what does it look like and how do you want it modified?

      What does your current worksheet not do, that you want it to do?
      What does it do, that you don’t want it to do?

      We need more specific information.

      If you wish to post an example of your worksheet please read this How-To
      it explains how to you the < PRE > tags:

      http://www.computing.net/howtos/sho…

      MIKE

      http://www.skeptic.com/

      • 0