Thread: Evaluate 5 columns and return right-most name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JulesMacD JulesMacD is offline
external usenet poster
  
Posts: 5
Default Evaluate 5 columns and return right-most name
I have 5 columns containing different supervisor levels. Some columns are
blank. I would like to write a formula to evaluate the 5 columns and return
the name in the farthest right column. Thank you!
Reply With QuoteReply With Quote