=IF(C4=C3,IF(D4=D3,"DUP",""))
That formula’s not working for me. It’s displaying DUP (duplicate) for every single line. Basically if C4 = C3 is false, goes straight to Dup. Why would that be?
Also how would I say what im trying to say, ie if C4=C3 & D4=D3 then Duplicate? I tried ‘&’ that's not working.
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
=IF(AND(C4=C3,D4=D3),"DUP","")
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
great thanks guys.
can you tell me why my formula kept saying duplicate when it wasnt?
Originally Posted by TMShucks
actually thats not working somehow..
the value of this cell, and all others, is indeed DUPE
excel 3.png
I have one quick question.
Whether the calculation is Automatic? If it is automatic whether the calculation process completed to 100% without any interruptions?
ohhh. it is indeed manual. i did set the manual option for some files i was working on a week ago, i didnt realize it carries over, thought that was just for the file i was working on. is that not the way it works?
anyway, so how does that impact things in this case?
Pressing F9 will calculate the Active WORKBOOK (Calculation Occurs For All Sheets in the workbook)
pressing Shift+F9 will calculate the Active SHEET (Calculation Occur for Current Sheet Only).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks