View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jenn jenn is offline
external usenet poster
 
Posts: 107
Default Make list of cells in array and checking for duplicates

I have an array B2:F11, that has text in each cell. I need to make a
concantenated list in H2 where cell values are separated by commas. I also
need to make sure that the values in the compiled list are all unique,
because there is a chance that the same value will exist in more than one
cell.

The last thing I need to do is make sure the compiled list is in descending
order.

Can anyone help?

Thanks!