View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Postman Postman is offline
external usenet poster
 
Posts: 11
Default Compare 2 columns with words to 1 and to get the 3rd word.

Hi All

I have question for you. I have letter "h" (from high) in column A1 and
letter "L" (from low) in column B1. In column C1 i would like to get the
avarage from them which is "m" (from Medium). How to do it?

Thanks in advance