Diane Jenkins
New Member
I am wanting to know how to set up my spreadsheet so that if there are two or more rows that are duplicates (contain the same info) as another row they are get highlited?
Finding and highliting duplicate entries in excel.
- Thread starter Diane Jenkins
- Start date
bobhc
Excel Ninja
Good day Diane and welcome to the forum
If you have not already done so, please read the link
http://chandoo.org/forum/forums/new-users-please-start-here.14/
And your question
As per the upload?
,.
If you have not already done so, please read the link
http://chandoo.org/forum/forums/new-users-please-start-here.14/
And your question
As per the upload?
,.
Somendra Misra
Excel Ninja
Hi Diane,
Just an alternate solution. See the file.
Regards,
Just an alternate solution. See the file.
Regards,
bobhc
Excel Ninja
I just used CF
Somendra is showing how to do the job with the following formula.
=SUMPRODUCT(--(($A$7:$A$13&$B$7:$B$13&$C$7:$C$13&$D$7:$D$13&$E$7:$E$13)=($A7&$B7&$C7&$D7&$E7)))>1
While my method uses the inbuilt Excel functions Somendra is giving a free lesson in formula and formula checking.
.
Somendra is showing how to do the job with the following formula.
=SUMPRODUCT(--(($A$7:$A$13&$B$7:$B$13&$C$7:$C$13&$D$7:$D$13&$E$7:$E$13)=($A7&$B7&$C7&$D7&$E7)))>1
While my method uses the inbuilt Excel functions Somendra is giving a free lesson in formula and formula checking.
.
Last edited: