View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
widman widman is offline
external usenet poster
 
Posts: 103
Default Select number from leftmost column that has one

On a spreadsheet with 800 rows and 12 columns of data, how can I add a column
that is filled by the leftmost column that has data.
Some rows have data in only one of the 12 columns, some in 8, etc. No matter
how many there are, I only want the leftmost, no matter which column it is.