In general, when you have a list and you want to see only the records that
have a certain field you should consider the Data, Filter, AutoFilter
feature. You can use it display only those records and then copy them to
another sheet if you wish. Also, when you want to count items that match
some criterion you should consider the COUNTIF worksheet function.

--
Jim
"Jaydubs" wrote in message
...
| Dear Excel(lent) users,
|
| The following is the case.
|
| I have a spreadsheet with three tabs. In the first tab I have data about
| system tests. In the second tab I have data on acceptance tests. The
| structure of the columns in both tabs are exactly the same. Including one
| column (for instance 'H')in which we indicate wheter an issue is declined
and
| returned for further solution(s).
|
| In the third tab I want to summerize all Issues which have been returned
due
| to non acceptance (i.e. yes filled in 'H' in both other tabs).
|
| Furthermore I want to find out how many times each issue has been
| ping-ponged back and forth.
|
| Please help me out !! Thanks!
|
|
| --
| ** Fool on the hill **