Find Column Heading Based on criteria in 2 rows

[ootkhopdi]

hi all

i have a table with more than 100 rows and 100 columns

in this table upper most 3 rows are having column titles.

i want to get column heading of particular column,
in which row 2 value and row 4 value is equal to criteria

any help

 

[navic]

Re: Find Column Heading Based on cretera in 2 rows

in which row 2 value and row 4 value is equal to criteria

If J2 and J3 are the criteria, A1:H1 Column headers
try

=INDEX($A$1:$H$1,SUMPRODUCT((J2=B2:H2)*(J3=B4:H4)*COLUMN(B1:H1)))

 

[ootkhopdi]

Re: Find Column Heading Based on cretera in 2 rows

Thanks Novic , But your solution is not given answer,
i think , my problem is not clear.

please see table as

Monday

Tuesday

Wednusday

thursdat

Friday

Monday

Tuesday

Wednusday

thursdat

Friday

Monday

Tuesday

Wednusday

thursdat

Friday

Monday

Tuesday

Shyam

Rakesh

Rakesh

Rakesh

Shyam

Rakesh

Ankur

Ankur

Ankur

Shyam

<colgroup><col style="mso-width-source:userset;mso-width-alt:1393;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1962; width:41pt" width="55" span="2"> <col style="mso-width-source:userset;mso-width-alt:2673;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1991;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:1507;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1962; width:41pt" width="55" span="2"> <col style="mso-width-source:userset;mso-width-alt:2673;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1991;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:1507;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1962; width:41pt" width="55" span="2"> <col style="mso-width-source:userset;mso-width-alt:2673;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1991;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:1507;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:2588;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:2730;width:58pt" width="77"> </colgroup><tbody>
[TD="class: xl67, width: 39"]S.No.
[/TD]
[TD="class: xl67, width: 283, colspan: 5"]Ankur
[/TD]
[TD="class: xl67, width: 283, colspan: 5"]Rakesh[/TD]
[TD="class: xl67, width: 283, colspan: 5"]Shyam
[/TD]
[TD="width: 150, colspan: 2"]Answer: First Non Zero Value on
[/TD]

[TD="align: right"]1
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]2
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]

[TD="align: right"]3
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]4
[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

</tbody>

hope now can understand my problme...