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