Hello
I got this formulae on here which helps identify duplications.
however it won`t work if the target workbook is closed
is there any alternatives Please ?
?PHP Code:IF(COUNTIF('[Master report test.xls]Sheet1'!$E:$E,D17)>0,"Possible Duplicate","ok ")
Last edited by bimo; 04-25-2014 at 08:07 AM.
You could try using a VLOOKUP instead.
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
Vlook up is good the only draw back is when Vlookup return #N/A , Cell value is #N/A instead of "OK"
=IF(VLOOKUP(D17,' Master report test.xls]Sheet1'!$E:$G,3,FALSE)=#N/A,"OK","Possible Duplicate!")
Can you help ?
Thanks
Please Login or Register to view this content.
=IF(isna(VLOOKUP(D17,' Master report test.xls]Sheet1'!$E:$G,3,FALSE)),"OK","Possible Duplicate!")
Last edited by icestationzbra; 04-25-2014 at 09:39 AM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
it works ! Thank you..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks