I have a spreadsheet with multiple lines per material after deduping. The reason there are multiple line, of course, is there are some differing values in various columns and I need to specify which materials have which differences. Here is an example of the before and the after I need which I hope makes sense.
Please check he file, maybe something like this?
Something like that yes. I will try it thank you!Originally Posted by azumi
What am I doing wrong? I'm trying to change the formula to fit what I need but clearly not succeeding.
1-23-2014 9-51-14 AM.png
Last edited by shdwfx; 01-23-2014 at 12:40 PM.
Maybe change to:
=IF(COUNTIFS($E$2:$E$29441,E2,$O$2:$O$29441,O2)>=2,"","Yes")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks