View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yossy Yossy is offline
external usenet poster
 
Posts: 127
Default Please help!! VLOOKUP AND COMBINATION FUNCTION

Possible two-person teams that can be formed from 8 candidates (28) i.e
=COMBIN(8,2).

However, my question is Lets assume the list of all 8 candidates names' are
John, Dustin, Mary, David, Peter, Rossy, Liz and Mike. How do I get the list
of all the two-person team that will total 28. All help will be appreciated.

I was thinking of using the vlookup together with the COMBIN function but
can't figure it out. Thanks