Comparing excel lists
Use following formula to determine whether a value in one column is in another column and if not then return 1
=IF(IFERROR(MATCH(A2,B$2:B$4117,0),-1)=-1,1,”")
Letting the web deliver business results you want
Use following formula to determine whether a value in one column is in another column and if not then return 1
=IF(IFERROR(MATCH(A2,B$2:B$4117,0),-1)=-1,1,”")
Tina Thompson:
Cool site, loved the info and I will continue to check back for updates.
November 7, 2008, 10:22 amAllison Sellers:
Great website, the information is good, and the content will keep me coming back, thanks again.
November 24, 2008, 2:25 pmTim:
Good information on your site. I am trying to build a good blog and would love any ideas you have to improve my site.
December 8, 2008, 1:57 am