Comparing two rows and finding values in one row not in the other.

M

Malkial

Hello,
I am relatively a newbie to advanced Excel functions and such and
have a problem I hope you can assist me with.

I have one row [row 2] I want to compare with many other rows [row
4-500] and return the values in the one row [row 2] that are not i
each of the camparison rows [rows 4-500].


specifics:

User ApplicationName Feature_1 Feature_2 Feature_3
Average User Access File (File)|Menu Bar (MenuBarFull) Delet
(Delete)|Nil (Nil) Close (CloseWindow)|Menu Bar (MenuBarFull)

VS

User ApplicationName Feature_1 Feature_2 Feature_3
14 Access Office Links (OfficeLinksSplitMenu)|Print Previe
(PrintPreview) test
1224 Access File (File)|Menu Bar (MenuBarFull) Open..
(OpenDatabase)|Database (DatabaseContainer) Exit (Exit)|Fil
(FileMenu)
3314 Access Delete (Delete)|Nil (Nil) View Datashee
(DatasheetView)|Form View Popup (FormViewGeneralPopup) File (File)|Men
Bar (MenuBarFull)

I wanted to put the list in another worksheet.

Here is what I have tried so far which does return a correct response
however if I try to fill down or right I get the single fixed row [ro
2] reference changing on me. I suppose I may have two differen
questions here.

Formula trying so far:
=IF(COUNTIF(Access!C2:IV2,Access!C4)=0,Access!C4,"")


1) Is there a better way to do this?
2) Can I get a row reference in a formula to fix upon a single row whe
I use the fill feature or copy paste?

Thank you in advance for any assistance.

-Malkia
 
Top