D
Derick
Hi,
Help needed please on a filtering question.
Have a table with several columns. Column B and column H have items in them.
Need to filter/display only those items where there are mulitples.
For example.
B H
Apples Oranges
Peaches Pears
Apples Oranges
and so on
Since Apples/Oranges occurs in the list two or more times, would like to
keep them.
As Peaches/Pears occurs only once, would like to eliminate it .
In other words, any pair that occurs more than once must be kept; any pair
that occurs only once must be discarded.
Not quite sure what tools would be needed to do this. Any suggestions would
be greatly appreciated. Thank you.
Help needed please on a filtering question.
Have a table with several columns. Column B and column H have items in them.
Need to filter/display only those items where there are mulitples.
For example.
B H
Apples Oranges
Peaches Pears
Apples Oranges
and so on
Since Apples/Oranges occurs in the list two or more times, would like to
keep them.
As Peaches/Pears occurs only once, would like to eliminate it .
In other words, any pair that occurs more than once must be kept; any pair
that occurs only once must be discarded.
Not quite sure what tools would be needed to do this. Any suggestions would
be greatly appreciated. Thank you.