Excel VBA Highlight Duplicates and Duplicate between Range

**ayazgreat** · 12-19-2022, 09:57 PM

**DocAElstein** · 12-22-2022, 03:38 AM

Hello

Originally Posted by ayazgreat

....but it seems to be just like a challenge work I just want to know that can it be possible through macro ....

This is very bad English and does not really make any sense.
One answer to this could be
Yes, it most likely can be done with a macro, what ever it is you want. But god only knows what it is you actually want.

What is column B about?
Does column B have anything to do with the problem?

This is what you have given

_Row\^Col	A	B	C
1	Numbers	Remarks	Duplication
2	12345		1 Duplication
3	23456	This number is duplicated between C6 Cell	2 Duplication
4	32456
5	12345		1 Duplication
6	23455-23458		Total Duplicated in this range 3
7	23457	This number is duplicated between C6 Cell	3 Duplication
8	34567
9	23455	This number is duplicated between C6 Cell	3 Duplication
10

The only thing that makes any sense at all there is row 2 and row 5.
Nothing else makes any sense there, and your attempts to explain anything are useless.

I assume the results you want are column C ?
And I assume you start with just column A?

If that is the case you need to explain exactly how you get the results, etc. etc.

You need to explain it a lot more

Perhaps the best I can do is try to help you with some English language.

Dog
Cat
Dog

There are duplicates there because Dog and Dog are the same. There are 2 Dogs.

Dog
Cat
Dog ---- this is a duplicate

_.____________________________

Dog
123
Cat
123

There are duplicates there because 123 and 123 are the same. There are 2 numbers the same (123)

Dog
123
Cat
123 ---- this is a duplicate

_.___________________________

Dog
123
Cat
124

There are no duplicates here

( There are two sequential numbers here. 123 and 124 are sequential numbers.
We may also describe these as sequential numbers out of sequence.

_.________________________

Here I have 4 sequential numbers in sequence.
The sequential numbers 11 12 13 14 are in ordered sequence.
They are in order
11
12
13
14
7
Dog

_._____

Here I have the same 4 sequential numbers but they are out of sequence.
They are not in ordered sequence.
They are not in order.
They are out of order
They are jumbled up.
The order of the sequential numbers, 11 12 13 14, is all fucked up in a bloody jumbled up mess
12
Dog
14
7
13
11

_.__________________________________

Here I have identified a set of sequential numbers that are out of order in a list of things. I have identified the sequential numbers by highlighting the cells containing them

_Row\^Col	A	B
21
22	12
23	Dog
24	14
25	7
26	13
27	11
28

_._______________________________

23455-23458 ______ - This is representing 4 sequential numbers.
Using a dash, -, in between 2 numbers is a typical way to represent a list of numbers
In that example, the 4 numbers that are being represented are
23455
23456
23457
23458

With ayazgreat forum postings there are two main problems

Problem 1
This is usually a macro requirement, - a coding is wanted. This problem is usually not too difficult to solve, requiring just basic VBA skills

Problem 2
This problem is trying to understand what ayazgreat wants. This is usually a very big problem, and sometimes impossible to solve

Alan

Alan

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA