Excel formula to find duplicate values based on column change

B

BORUCH

Well-known Member
Joined
Mar 1, 2016
Messages
528
Office Version
  1. 365
Platform
  1. Windows
hi

what formula in excel can i use to find duplicate values based on a column change in column A
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Here's my favorite. Sort on column A, then in an unused cell on row 2 (assuming there's a header row) place =IF(A1=A2,"**",IF(A2=A3,"*","")) and copy to end.
The first of any set of duplicates will have one asterisk, the subsequent ones will have two.
 
Upvote 0
OK

I would like to find the duplicates in column d based on change in column a
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question
Find the second highest attribute based on criteria. I know its a combo of index(match(large, but I just can't get it to work correctly.
Replies
1
Views
106
StephenCrump
S
W
  • Question
Highlight duplicates based on another column
Replies
2
Views
150
wikus
W
A
  • Solved
Need VBA to automatically copy paste rows based factory selected
Replies
8
Views
193
Alex Blakenburg
A
J
  • Question
Insert Row based on cell Value VBA
Replies
2
Views
51
mumps
mumps
E
  • Question
Help with VBA to change range limits
2
Replies
18
Views
245
EssKayKay
E

Forum statistics

Threads
1,215,181
Messages
6,123,508
Members
449,101
Latest member
mgro123

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top