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 **

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 **

Hello Jim,

Thank you very much for your swift reply.

I have thought of that and it would work if it where not for the fact that
such an excercise needs manual work and I want it done automatically, any
other suggestions?

--
** Fool on the hill **


"Jim Rech" wrote:

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 **

I want it done automatically

I have re-read your first post and I see no mention of this requirement.
That would account for why I didn't suggest one.

Well, the only automatic solutions I know of involve macros. I don't know
if you're familiar with macros but if you know a bit about them you could
start off by recording the steps involved in doing the manual process. The
resulting macro would then need work to generalize it but it's a start. You
might come back with specific questions at that point if you have any. I'd
suggest you start a new thread at that point since this one will be 'pushed
down' by then and easily missed.

--
Jim
"Jaydubs" wrote in message
...
| Hello Jim,
|
| Thank you very much for your swift reply.
|
| I have thought of that and it would work if it where not for the fact that
| such an excercise needs manual work and I want it done automatically, any
| other suggestions?
|
| --
| ** Fool on the hill **
|
|
| "Jim Rech" wrote:
|
| 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 **
|
|
|