View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bollard bollard is offline
external usenet poster
 
Posts: 65
Default Finding entries across columns

Hello

I have a spreadsheet which has names in Column B.

In the next 6 or 7 columns, from Column C onwards, there are psoradic
entries. There may be an entry in Column C or D or E etc. There may also be
more than one entry.

I just want some way of returning only the first entry that occurs to the
right of the Name in Column B.

Can anyone help, plase?

Thank you.

Keith