View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashutosh Ashutosh is offline
external usenet poster
 
Posts: 10
Default Matching & adding text in the respective column

I have text data in following way

high india
high australia
low russia
medium france
medium italy
low germany
high spain

Now in a separate sheet, I need result for high, medium & low by adding the
respective text of the same such as follows

High india australia spain
medium france italy
low russia germany

Can u help me phrasing the formula for the same ?



--
ashutosh