Copy and paste values but exclude duplicate listing

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
How do I create a formula or macro that will copy the list of values in the range BQ5:BS18 and paste into CH5:CJ18, but exclude any cells from the list that are duplicates.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Sprucy

Board Regular
Joined
Oct 31, 2005
Messages
92
Hey Brew,

Do you really need a macro?
If not, you could....
Select your range (BQ5:BQ18)
Then go to Data > Advanced Filter > Copy to another location
Specify your range, BQ5:BQ18
Copy to: CH5:CH18
and so on for each columns....
Check mark the Unique Records at the bottom....

See if this works for you...
I know there's a better way, but this will get you started...

Cheers,
Sprucy
 

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
Thanks for your help, however this does not work for my purpose, because the original data get it’s values from formulas referencing other cells, therefore, giving formulas as results referencing other cell locations. Does anyone have any other ideas?, maybe a macro is a better solution.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,630
Members
412,475
Latest member
JaredNAU
Top