View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cecilia Cecilia is offline
external usenet poster
 
Posts: 26
Default Pull value from column heading

Hello--

I have a table that looks like this:

135569 135572 135574 135577 135578
7664502273 1 1 1 1
7664505027 1 1 1 1
9.78158E+11 1


For each row, I need to pull the column heading for any instances where
there is a 1 and have that entered in it's own separate cell or separated by
a comma if in a single cell.

I've tried some index functions, but am not having any luck.

Any ideas?? Thanks so much for your help!!!

Cecilia