Hi Gents,
Im new to this forum and need your help to resolve one requirement. I have 3 columns in a worksheet, where there are number of duplicates.
I want to some technic/Macro to eliminate those duplicate comparing 3 columns which are important. I have attached a sample data and result i need .
I sincerely hope some one will help for sure.
Thanks much,
-Eph
Hello and welcome ephrahim,
find the attached!
FOrmulas used in the sheet 1 are array formulas you need to hold control and shift together and then hit enter to make it array formula again, in case you change anything or copy and paste it somewhere else.
you also need to maintain conditional formatting to get the borders accordingly.
In sheet 1 select A1 to E10 go to conditional formatting and check the formulas
Last edited by hemesh; 10-24-2013 at 03:52 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Hi,
I hope you have seen the result page, how to achieve it. I can remove the duplicate using the exisiting options in Excel, but how to remove in column 1 and column 2.
Example: For Destination port(columnC), the formulae are showing 4 unique lines but there are only 3 unique Source IP-addresses in column A and B. How to remove that duplicate ????
-Eph
Last edited by ephrahim; 10-24-2013 at 08:27 AM. Reason: more clarity
how you want to remove duplicate in column A and B what is the logic or criteria you are looking. Basically there are five unique values in column A and column B
Column A has unique values at row 2,3,6,10,13 and column B has unique values at row 2,3,8,10 and 11
Hi Hemesh,
For example DNS 53 in column C, we have below records.
Source address Destination address Destination Port Application IP Protocol
192.168.1.2 192.168.250.10 53 dns udp
192.168.1.3 192.168.250.20 53 dns udp
192.168.1.6 192.168.250.10 53 dns udp
192.168.1.6 192.168.125.33 53 dns udpou
But if you see the column A, we could see duplicate value 192.168.1.6, Even in column B we could see duplicate value 192.168.250.10.
I want those to be removed , i dont have any idea so im here sir.
-Eph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks