Hello, Using excel 2007
I have an attached worksheet that has 2 formulas looking for matching numbers. What I want if the first formula finds a matching # then I don't want the second formula to find a match on that same number.
Attached is a sample worksheet, showing the data, formulas and what I would like to see happen with a new formula that I need help constructing.
Thanks for you help.
Michael
I think I have it.
=IF(COUNTIF(C11:G11,H11)>0,0,COUNTIF(C5:G5,H11))
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
Thanx Dunc, that did it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks