Grouping??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Let's say I have a test matrix that has the following columns:

TC_NAME, REQ#, TESTER, AUTOMATE

In the TC_NAME are the test cases where the TCs appear multiple times
when they address multiple requirements.

E.g.

TC_NAME REQ# REQ TESTER AUTO
PrintQueue001 1.2.1234 Print Queue contents Joe Blow Yes
PrintQueue001 1.2.1235 Print Queue config Joe Blow Yes
PrintQueue001 1.2.1236 Print Queue Owner Joe Blow Yes
SaveQueue001 2.1.1234 Save a Queue Moe Blow No
SaveQueue002 2.1.1235 Save a Queue w/ bad path Moe Blow No
SaveQueue003 2.1.1236 Save a Queue w/ Win-net path Moe Blow No
SaveQueue003 2.1.1237 Save a Queue w/ Unix-net path Moe Blow No
....

I want to group the spreadsheet so that each value in TC_NAME only
appears once:

E.g.
TC_NAME REQ# REQ TESTER AUTO
PrintQueue001 1.2.1234 Print Queue contents Joe Blow Yes
SaveQueue001 2.1.1234 Save a Queue Moe Blow No
SaveQueue002 2.1.1235 Save a Queue w/ bad path Moe Blow No
SaveQueue003 2.1.1236 Save a Queue w/ Win-net path Moe Blow No

Is it possible to do this?
 
Insert a new column A (shifting everything to the right).

In A1, put: Count
in A2, put: =countif($b$2:b2,b2)
and drag down

Now apply data|filter|autofilter to that new column (or the whole range???).

Filter to show only the 1's.

You could copy those visible cells and paste them elsewhere if you want--or even
show the values greater than 1 and delete those visible rows.
 
Back
Top