Did you get a result of True for the 107/236 row?
Did you get a result of False for the 100/336 row?

If you did and just need to see the rows with falses, you could apply
Data|Filter|autofilter to that column.

Display just the False rows.

If you need to copy those visible rows somewhere else, you could just select
those visible rows and edit|copy, then edit|paste.

===
What did those formulas evaluate to?


manasi wrote:

I used this formula:
=ISNUMBER(MATCH(1,(GRP2!$A$1:$A$20=A1)*(GRP2!$B$1: $B$20=B1),0))

Thanks Dave
I was able to copy the formula but the results were not the ones I
wanted I will try giving an example.
in Grp1 tab I have a combination of
unit id
107 236
100 336
.....
when I go to Grp2 tab I have
unit id
107 236
108 456
....
The combination of grp1 100/336 is not on Grp2 therefore I need to show
that.
Hope this will clarify

--
manasi
------------------------------------------------------------------------
manasi's Profile: http://www.excelforum.com/member.php...o&userid=27411
View this thread: http://www.excelforum.com/showthread...hreadid=469228

--

Dave Peterson