Needed help with if function
 

I am newbie here and is having hard time in doing this.
I have an excel workbook which has two sheets Grp1 and Grp2
within these sheets i have unit and id columns, what I am trying to do
is find out the combination of unit and id column which is on Grp1 but
not on Grp2 tab.
Could you all please help?


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

manasi Wrote:
I am newbie here and is having hard time in doing this.
I have an excel workbook which has two sheets Grp1 and Grp2
within these sheets i have unit and id columns, what I am trying to do
is find out the combination of unit and id column which is on Grp1 but
not on Grp2 tab.
Could you all please help?

Welcome to the forum, Mansi.

Rule number 1...*never multipost*. You only need to list your problem
one time, in one place. Nothing is more frustrating to a responder
than to find out they have wasted their time because someone else has
already answered your question in another location!

good luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469227

And just to add to swatsp0p's response---
You have a reply to your post in .misc.

swatsp0p wrote:

manasi Wrote:
I am newbie here and is having hard time in doing this.
I have an excel workbook which has two sheets Grp1 and Grp2
within these sheets i have unit and id columns, what I am trying to do
is find out the combination of unit and id column which is on Grp1 but
not on Grp2 tab.
Could you all please help?

Welcome to the forum, Mansi.

Rule number 1...*never multipost*. You only need to list your problem
one time, in one place. Nothing is more frustrating to a responder
than to find out they have wasted their time because someone else has
already answered your question in another location!

good luck

--
swatsp0p

------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469227

--

Dave Peterson