-
Excel VBA Highlight Duplicates and Duplicate between Range
-
Hello
Quote:
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 |
D |
|---|
| 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
