Finding first occurance of cell from Multiple cells

[jb]

I am facing a problem with finding first occurance of some value from multiple cells.

Let me explain it.

I have 6 excel sheets with name MON, TUE, WED upto SAT. This sheet contains daywise time table of a school.

Format of every sheet is same.

Header row contains names of classes. First column contains time slots. After every slot there is a blank line because at intersection of class and time slot, Subject name and faculty name is written. There can be a common faculty for two class. how to search first occurance?


Grade-1 Grade-2 upto Grade-15.

10 to 11 Maths Maths Science

AA AA BB

11 to 12

...

 

[NARAYANK991]

Hi ,


You can use Conditional Formatting to highlight the first occurrence of an item in a row or column.


Suppose your header row is row number 1 ; suppose your classes such as Grade-1 , Grade-2 , ... , Grade-15.


Your subjects are in row 2 , and your faculty are in row 3 , starting from column B.


Place your cursor in cell B3 , and in Conditional Formatting , put in the following formula :


=COUNTIF($B3:B3,B3)=1


Using the Format Painter , you can copy this formatting to the other relevant cells in the row.


The first occurrence of each faculty member will be highlighted.


Narayan