combining

[Yossi]

thanks for taking your time and trying to help out


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

[TABLE="class: cms_table, width: 100, align: left"]
<tbody>[TR]
[TD]book1[/TD]
[/TR]
[TR]
[TD]b[/TD]
[/TR]
[TR]
[TD]c[/TD]
[/TR]
[TR]
[TD]d[/TD]
[/TR]
[TR]
[TD]e[/TD]
[/TR]
[TR]
[TD]f[/TD]
[/TR]
[TR]
[TD]g[/TD]
[/TR]
[TR]
[TD]l[/TD]
[/TR]
[TR]
[TD]t[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: cms_table, width: 100"]
<tbody>[TR]
[TD]book2[/TD]
[TD]book3[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]l[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]t[/TD]
[TD]f[/TD]
[/TR]
</tbody>[/TABLE]

 

[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