I need to determine which column a specific item is located.
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]1[/TD]
[TD="class: xl66, width: 64"]2[/TD]
[TD="class: xl66, width: 64"]3[/TD]
[TD="class: xl66, width: 64"]4[/TD]
[/TR]
[TR]
[TD="class: xl67"]water[/TD]
[TD="class: xl67"]lettuce[/TD]
[TD="class: xl67"]chicken[/TD]
[TD="class: xl67"]ice cream[/TD]
[/TR]
[TR]
[TD="class: xl67"]cola[/TD]
[TD="class: xl67"]tomato[/TD]
[TD="class: xl67"]beef[/TD]
[TD="class: xl67"]cake[/TD]
[/TR]
[TR]
[TD="class: xl67"]juice[/TD]
[TD="class: xl67"]cucumber[/TD]
[TD="class: xl67"]pork[/TD]
[TD="class: xl67"]pie[/TD]
[/TR]
[TR]
[TD="class: xl67"]coffee[/TD]
[TD="class: xl67"]okra[/TD]
[TD="class: xl67"]lamb[/TD]
[TD="class: xl67"]brownie[/TD]
[/TR]
[TR]
[TD="class: xl67"]tea[/TD]
[TD="class: xl67"]carrot[/TD]
[TD="class: xl67"]shrimp[/TD]
[TD="class: xl67"]cookie[/TD]
[/TR]
[TR]
[TD="class: xl67"]milk[/TD]
[TD="class: xl67"]onion[/TD]
[TD="class: xl67"]fish[/TD]
[TD="class: xl67"]candy[/TD]
[/TR]
</tbody>[/TABLE]
How do I get Excel to return the column header of text that appears in the above array? Everything I have found only works for number(values).
Thank you,
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]1[/TD]
[TD="class: xl66, width: 64"]2[/TD]
[TD="class: xl66, width: 64"]3[/TD]
[TD="class: xl66, width: 64"]4[/TD]
[/TR]
[TR]
[TD="class: xl67"]water[/TD]
[TD="class: xl67"]lettuce[/TD]
[TD="class: xl67"]chicken[/TD]
[TD="class: xl67"]ice cream[/TD]
[/TR]
[TR]
[TD="class: xl67"]cola[/TD]
[TD="class: xl67"]tomato[/TD]
[TD="class: xl67"]beef[/TD]
[TD="class: xl67"]cake[/TD]
[/TR]
[TR]
[TD="class: xl67"]juice[/TD]
[TD="class: xl67"]cucumber[/TD]
[TD="class: xl67"]pork[/TD]
[TD="class: xl67"]pie[/TD]
[/TR]
[TR]
[TD="class: xl67"]coffee[/TD]
[TD="class: xl67"]okra[/TD]
[TD="class: xl67"]lamb[/TD]
[TD="class: xl67"]brownie[/TD]
[/TR]
[TR]
[TD="class: xl67"]tea[/TD]
[TD="class: xl67"]carrot[/TD]
[TD="class: xl67"]shrimp[/TD]
[TD="class: xl67"]cookie[/TD]
[/TR]
[TR]
[TD="class: xl67"]milk[/TD]
[TD="class: xl67"]onion[/TD]
[TD="class: xl67"]fish[/TD]
[TD="class: xl67"]candy[/TD]
[/TR]
</tbody>[/TABLE]
How do I get Excel to return the column header of text that appears in the above array? Everything I have found only works for number(values).
Thank you,