Saturday, May 28, 2011

yogi_Get Header Name Of Column(s) Containing Data That Matches A Specified Value

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
edanishafridi said:
How do i get the header name of columns containing data which matches my query?
example
    A      B      C
1 group1 group2 group3
2 21 25 26
3 56 12 3
4 98 45 16
QUERY= 12
which formula do i use to get the header name of the column containing 12 i.e. in the above case group2.
i have search alot but didn't find the axact what i am looking for.
-------------------------------------------------------------------------------

No comments:

Post a Comment