I have this code to compare columns to retrieve the entry if it isn't in the other. My problem is if there is a match it returns "0" and I'm wondering what I need to do so that if a match is found it will just leave the cell empty?
Please Login or Register to view this content.
Is the data being returned alpha-numeric?
If it is,Formula:
Please Login or Register to view this content.
Otherwise, you need to test what you are getting for blanks.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Alternatively:
=IFERROR(1/(1/INDEX(Inv!A:A,SMALL(IF(ISNA(MATCH(Inv!A$7:A$1000,Inv!B:B,0)),ROW(Inv!A$7:A$1000)),ROWS(Inv!D$2:D2)))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
TMS, That worked, can't believe it was so simple. Thank's a lot!
Thank you too Glenn I didn't need to try your alternate but appreciate the response!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks