ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 961
- Office Version
- 365
- 2010
- Platform
- Windows
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!!
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!!