Thread: Can excel list the possible combinations from a range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Syndrome Syndrome is offline
external usenet poster
  
Posts: 11
Default Can excel list the possible combinations from a range of cells
I have 15 cells with differing data in them, for example Andy in A1, Lesley
in A2, Keith in A3 etc etc.
I want to calculate and list the different combinations of the entries in a
column..... For e.g Andy
Andy, Lesley
Andy, Keith
Andy, Lesley, Keith
Lesley, Keith




Reply With QuoteReply With Quote