Possible help with Excel - finding pairsPrev TopicNext Topic

• CountingMan

  

  Charlotte
  United States
  Member #42,105
  June 27, 2006
  105 Posts
  Offline
  Aug 18, 2019, 11:32 am

  ▲▼

  Good Afternoon Team!

   

  Having a little issue solving, and am hopeful that the group may be of assistance.

   

  I am trying to come up with a method to ID pairs in past drawings using excel.  I have yet to come up with an elegant solution.

   

  The data set I have in my WB that I update regularly appears as such:

   

  8/18/2019	2	5	16	32	37
  8/17/2019	3	5	6	33	35
  8/16/2019	1	8	15	24	43
  8/15/2019	2	5	13	15	35
  8/14/2019	2	7	21	40	41
  8/13/2019	4	19	32	34	42
  8/12/2019	10	18	20	29	33
  8/11/2019	1	9	30	38	40
  8/10/2019	3	10	25	32	39

  I can nest formulas a well as anyone, but have not come across one to identify duplicates.  If it has be be in its own worksheet, that is fine.

   

  Thoughts?

   

  Thanks!!!