Hello,

I have been trying to search for a simple answer to this but at the moment I'm stuck.

I have 4 cells each with a range of numbers representing days of the week.

For example in D1 12345
D2 1
D3 456
D4 17

I need a formula that can list these as one figure removing any duplicates so the the above example the resulting figure should be
1234567

Is this possible ot do I need to go to VBA to achieve this.

THanks for taking the time to look.

Regards

David