Combine two Column without Duplicate

[hardeep.kanwar]

Hi Experts

I have data in Two Sheets,

Is it Possible with Formula

For Example:
Sheet1

1
2
3
4
5
6
7
8
9
10
3
2
5
6


Sheet2

10
9
8
20
25
26
24
58
26
3
4
5
3
78
79
3
3
3


Expected Result Should be
1
2
3
4
5
6
7
8
9
10
20
25
26
24
58
78
79

I am Looking a "Formula" Not "MACRO OR ANY CODE"

Thanks in Advance

Hardeep Kanwar

[Cheeky Charlie]

A formula alone would be absolutely horrendous -> as you don't want a macro (understandable) a couple of quick manual steps:

Copy Sheet 2 data and paste underneath sheet 1 data
sort column
select top of column
Data->filter->advanced filter
Copy to a new location (select an adjacent cell)
Check in "unique records only"

Instructions for XL2000/02/03 as you haven't bothered to update your profile with your XL version.

HTH