I have a data set as follows:
Colmn B Colmn C Colmn D Colmn G
Test Location Instrument Reading
1 1 1 1
1 1 1 2
1 1 1 3
1 2 3 1
1 2 3 2
2 4 1 1
2 4 1 2
2 6 2 1
3 1 1 1
I want to know the number of unique tests based solely on location and instrument (Not including reading). In the example above, there would be 5 unique tests (1,1,1; 1,2,3; 2,4,1; 2,6,2; 3,1,1). I'm looking to display the data in a table format where Location and Instrument are the Row and Column Header, and the values within each cell are the number of unique tests. For instance:
Inst
1 2 3
Location: 1 2
2 1
4 1
6 1
I'm envisioning a forumla where I can set the "location" and "instrument" dependent on the value in the "final table" and have it sort through the data. Thus, there would be the same forumla repeated a number of times.
Any help would be appreciated.
Bookmarks