The data is more complicated than that. Here's a better sample of the data. This goes on for 40,000+ excel lines. Name1 Name1.1 99201, 99202, 99203, 99204, 99205, 97813, 97814, 97810, 97811 Name1 Name1.2 99205, 99211, 97813, 97814, 97810, 97811 Name2 Name2.1 S5101, S5102, S5105
... View more
Unique value is anything that appears in row three for Test 1.1 that doesn't appear in row three for test 1.2. Output should be the entire row. There will be other rows such as Test2 Test2.1 123 Test2 Test2.2 124
... View more
Hello, Is there a way to report on all unique values within a subset of data? For instance looking within the test1 set of data and comparing test1.1 to test1.2 to find that the unique value is 123. Test1 Test1.1 123 Test1 Test1.1 124 Test1 Test1.1 125 Test1 Test1.1 521 Test1 Test1.1 324 Test1 Test1.2 125 Test1 Test1.2 521 Test1 Test1.2 124 Test1 Test1.2 324
... View more