Excel formulas to show clashes - how to set up aspreadsheet

October 3, 2013 at 04:07:05
Specs: Windows 7 enterprise
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! :-)

See More: Excel formulas to show clashes - how to set up aspreadsheet

Report •


#1
October 3, 2013 at 12:24:57
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/


Report •
Related Solutions


Ask Question