combining

[Yossi]

thanks for taking your time and trying to help out


i would like book1 to be the results from book2 plus book3

book1

b

c

d

e

f

g

l

t

<tbody>
</tbody>

book2	book3
b	b
c	c
g	d
l	e
t	f

<tbody>
</tbody>

 

[AhoyNC]

One way if using Excel 07 or 10

Copy data from Book 1 and 2 into the same column.
On ribbon goto:
- Data
-Remove Duplicates
- then sort as needed.

or in 2003
Under Advance Filter see Unique record.

 

[Yossi]

but i will need it in a formula since it will have to recalculate every hour