View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default Function or Code Needed

If I have 51 columns,each column is a state and each row has a status for
each state, "Y" or "N", is there a way I can insert a column prior to first
state column that could pull which state has a "Y" and list in the new column
?