Excel Notify Duplicate Data

[Acowaz]

I'll try not to be too confusing. I have two inventory databases, A & B. I am merging Database B(updated database) into A. Once merged, is there a formula that will tell me which info is from "B" and which is from "A." I know "B" will have duplicate data compared to "A."

I've used =if(d1=d2, 0,1). This is good in that it tells me which is duplicate but i'm trying to find out which is the data from "B" when merged into "A." Any help is greatly appreciated. Thanks in advance.

 

[xlbo]

how are you merging the data ??
what application are you using ??


Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Acowaz]

I am using Excel. I am merging them by just copy & paste together.

 

[xlbo]

are you pasting the 2nd block UNDER the 1st ?? or are you inserting ??

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Acowaz]

I am pasting the 2nd block under the 1st.

 

[xlbo]

well - before you sort - you need to add an indicator to the block you've just pasted in. Just put a B in the next column for all those that have been pasted in - you don't need to do it 1 by one - just enter a B next to the 1st one then hover the mouse over the bottom right of the cell until it turns to a + and then double click to autofill

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244