Excel Count

[Anoop]

Hi All,

I have a interesting question.

I have a worksheet with A1:E1 having headings of a certain table.

A2:E2 have the details as columns. This is continued in A3:E3 as well
as A4:E4.

I need to find the occurances of a value in these rows and display the
heading for the same in a result column. (say F2 trough F5)

Could any one please help me out with this.

Thanks,
Anoop.

 

[Pete_UK]

Take a look at the MATCH and INDEX functions in XL Help.

Hope this helps.

Pete