PLease i need your help on this prob...
Attached is the picture of my data sheet...tnx...
PLease i need your help on this prob...
Attached is the picture of my data sheet...tnx...
Last edited by Haroldski; 09-24-2012 at 10:23 AM.
Post a sheet instead of a picture pasted in Word
You can you excel's built in function. Highlight the 2 columns, then Click on the Data tab>Remove Duplicates. There a checkboxes to check if your data has headers. In the listbox select the 2 columns that have the dupes.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Tnx mike7952, but i want a condition that will just notify me if two data are havig exactly the same in the two columns... and i will have also the option to input or NOT to input the same data again...
Please guys I badly need your help in this matter...
Are you using 2003?
NOPE, im using excel 2007
Try in D2 and copy down.
=IF(SUMPRODUCT(($B$2:$B$24=B2)*($C$2:$C$24=C2))>1,"Alarm","")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Put this in column C and drag down.
Formula:Please Login or Register to view this content.
Yah it works... Tnx
Can i used it it DATA VALIDATION>CUSTOM
Hi Haroldski,
Do you want to delete the duplicate or highlight them so you can Identify them?
In range C2:C24, IN custom validation rule, put this.
=SUMPRODUCT(($B$2:$B3=B2)*($C$2:$C3=C2)*($C$2:$C3>0))<2
I want to be notify if the condition are met, but i have the option if i will continue to input the data or not...
Sir fotis1991 perfectly done, you save my job....LOL
If it will not abuse your kindness, how can i also highlights the last data that are been duplicated?
Then you can not use Custom Validation.
Use my formula in column C, or use Conditional format to change color if condition met.
In Conditional format rules, put this formula.
=SUMPRODUCT(($B$2:$B3=$B2)*($C$2:$C3=$C2)*($C$2:$C3>0))>1
Choose range and color.
Ok tnx sir fotis1991...
Sir fotis1991
=IF(SUMPRODUCT(($B$2:$B$24=B2)*($C$2:$C$24=C2))>1,"Alarm","")
regarding the above formula how about putting a blank instead an "ALARM" in a blank cell?
Can i combined conditional formatting and data validation?
If the condition is met, then we use "ALARM" OR anything else you like. If the condition is not met then cell is empty.Look formula in column C.
Take a look to the example.
Ah ok, but i need also to highlight the cell C3 and B3 in your sample sheet... for easy reference of the duplicate data...
In Conditional Formatting rules, put this formula.
=SUMPRODUCT(($B$2:$B$24=$B2)*($C$2:$C$24=$C2)*($C$2:$C$24>0))>1
Once again thanks very much!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks