Good Afternoon,
I hope you can help as I am trying to return column header after matching cell value. For example when search for "Cat" it should return Col 3
<colgroup><col width="64" style="width: 48pt;" span="7">
<tbody>
</tbody>
I hope you can help as I am trying to return column header after matching cell value. For example when search for "Cat" it should return Col 3
col1 | col2 | col3 | col4 | col5 | col6 | col7 |
Animal | Apple | |||||
Animal | Apple | |||||
Animal | Apple | |||||
Animal | Apple | Cat | ||||
Animal | Apple | Cat | ||||
Animal | Apple | Cat | Dog | |||
Animal | Apple | Cat | Dog | |||
Animal | Apple | Cat | Dog | |||
Animal | Apple | Cat | Dog | |||
Animal | Apple | Cat | Dog | |||
Animal | Apple | Cat | Dog | Test | ||
Animal | Apple | Cat | Dog | Test | ||
Animal | Apple | Cat | Dog | Test | ||
Animal | Apple | Cat | Dog | Test | Horse | |
Animal | Apple | Cat | Dog | Test | Horse | |
Animal | Apple | Cat | Dog | Test | Horse |
<colgroup><col width="64" style="width: 48pt;" span="7">
<tbody>
</tbody>