Thread: Can excel list the possible combinations from a range of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Can excel list the possible combinations from a range of cells
See Coleman's response in :


http://groups.google.com/group/micro...529de2aaf 685



--
Gary''s Student


"Syndrome" wrote:

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