Unique Values - Remove Duplicates - 2 Ranges with Blanks

[ststern45]

Happ Holidays everyone,

I have 2 cell ranges with values
Range 1 = AO10:CX10
Range 2 = DB10:EF10

Each range has a random number of value and each range may contain blanks

I wnated to ask if a formula that will calculate range AO10:CX10 and also DB10:EF10 and in cell EH10 dispay values unique (remove duplicates).

Thank you in advance!!

 

[Peter_SSs]

Could you give us a small set of sample data and the expected results, preferably with XL2BB?

Ideally just 4 or 5 values in each range near the start of the range, but include a few blanks & duplicates to help demonstrate the requirement.

 

[ststern45]

I found a video from MrExcel that answered my question. Thank you for you reply.

 

[Peter_SSs]

Glad you have found a solution. Thanks for letting us know.