hello
i have data A61:A500
i want to extract records with out duplicate on BN61:BN500
thanx alot
hello
i have data A61:A500
i want to extract records with out duplicate on BN61:BN500
thanx alot
what is your data? Numbers? text? mixed?
Hi, haroon2015,
loop through the cells in A61 to A500 and copy as well as add the value under those present in the target range if WorksheetFunction.CountIf delivers 0. Or copy over and use FilterDuplicates or the Advanced Filter.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
mIXED NUMBERS AND TEXT
Hello HaHoBe
will u plz make the code for me thanx
Hi, haroon2015,
like this:
You might consider to adapt the ranges to the actual number of records in the cells if these are constant values by using SpecialCells or get the last row number of filled data via Find.Please Login or Register to view this content.
Ciao,
Holger
HaHoBe
i don't want to vba code
i want simple excel code
i m using this function to make dynamic list my text range
i want to make dynamic list for numbersPlease Login or Register to view this content.
Hi, haroon2015,
please have a look at the attachment where I used a helper column in Column B and displayed the results in Column C.
Ciao,
Holger
Yup
now perfect thanx HaHoBe
+1 repu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks