how to make duplicate value in other column
hi all
in the link below i put smal exempl for the resultat which i'm looking for, the idea is how to extract duplucate value in other column. by the way the column F and G has a thousands of values, the columns G and F i put them just to show members where is the duplicate values
https://1drv.ms/x/s!As8Mdv-a95REhU6iGQZ1-oyfh_Ti
Cross posted https://www.mrexcel.com/forum/excel-...er-column.html
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
Re: how to make duplicate value in other column
thank you @davesexcel for your informations
in attached file i put smal exempl for the resultat which i'm looking for, the idea is how to extract duplucate value in other columns. by the way the column F and G has a thousands of values, the columns G and F i put them just to show members where is the duplicate values
Last edited by SBAY3I; 09-13-2018 at 01:41 PM.
Hello,
Can you explain what you want to do with the results?
hi @davesexcel
thank you for your interests, the idea is how to extract duplicate values from column B and C and put it in other columns without forgeting coloration the duplicate values in columns B and C and in the others columns, i hope to give the right idea
See next macro
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
Re: how to make duplicate value in other column
thank you @PCI for your code, but there are some things incomplete as you see in the screen shot, if you check very well the column C you will find also duplicate value in C17, other thing to make the verification so easy, all the duplicate values in column C and cell beside them must be colored because there are thousands of values in column C the screen shoot just a smal exemple
thank you
It means it is duplicate only for column "C" ...please confirmyou will find also duplicate value in C17,
Okay it can be donethem must be colored
If you are looking for duplicates in B and C then Row 17 is not duplicate.
This will color the cells that are duplicate in column C, as it stands it is just using color.index. There are only 57 colors in color index, if more colors are required, we would have to do something different
for coloring the cells.
Please Login or Register to view this content.
Another one
Please Login or Register to view this content.
Last edited by PCI; 09-13-2018 at 04:33 PM. Reason: Range color adjustment
hi all
sorry to make you wait, thank you very much @davesexcel for your code it's working, but the code of @PCI is working better as what i want exactly and i'am very thankful for you @PCI
this thread resolved
Last edited by SBAY3I; 09-13-2018 at 05:38 PM.
You are welcome, but it was not so easy to understand your need.
The next give more details
thank you very much @PCI. i now my english not good to give the right idea for other members sorry for that.
SBAY3I
See here a small adjustment, was missing to clean up color for column "B"
Please Login or Register to view this content.
hi PCI
thank you for your interests, when i put your new code it's give me the same results, what i find out else is in column B (look at B19 and B20; C19 and C20) you will understand what i found out
If my undersatdning is good you are complaining that the colored cells is not complete?
C'est ça ?
Send the file you are working with, please
yesOriginally Posted by PCI
ok
thank you
Here we are
Test and test again
Please Login or Register to view this content.
now is very good PCI
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks