Populate New or Dropped Data

[kumara_faith]

Hi,

I have the following data table:

Book2
	A	B	C	D
1	Month	Product ID	Product Name	Branch Name
2	Dec	123456	Product1	Branch 1
3	Dec	123457	Product2	Branch 2
4	Dec	123458	Product3	Branch 3
5	Dec	123459	Product4	Branch 4
6	Dec	123460	Product5	Branch 5
7	Dec	123456	Product1	Branch 1
8	Jan	123457	Product2	Branch 2
9	Jan	123458	Product3	Branch 3
10	Jan	123459	Product4	Branch 4
11	Jan	123461	Product6	Branch 5
12	Feb	123457	Product2	Branch 2
13	Feb	123458	Product3	Branch 3
14	Feb	123459	Product4	Branch 4
15	Feb	123462	Product7	Branch 5
16	Mar	123457	Product2	Branch 2
17	Mar	123458	Product3	Branch 3
18	Mar	123459	Product4	Branch 4
19	Mar	123462	Product7	Branch 5
20	Mar	123462	Product8	Branch 5
21	Apr	123458	Product3	Branch 3
22	Apr	123459	Product4	Branch 4
23	Apr	123462	Product7	Branch 5
24	Apr	123462	Product8	Branch 5
Sheet1

1) I need to populate on the details of the products that was either dropped or added as new product in the following months.
2) Any product added or dropped in the following months will need to populated in a separate table.
3) Only details of products dropped or added needs to be populated

Example of the correct result is as follows;

Book2
	G	H	I	J	K
1	Month	Product ID	Product Name	Branch Name	Status
2	Jan	123460	Product5	Branch 5	Drop
3	Jan	123461	Product6	Branch 5	New
4	Feb	123462	Product7	Branch 5	New
5	Mar	123462	Product8	Branch 5	New
6	Apr	123457	Product2	Branch 2	Drop
Sheet1

Is there anyway we could achieve this with a formula ? Appreciate all the help.

 

[kumara_faith]

Hi,

Appreciate any help.

 

[kumara_faith]

Hi,

Appreciate any help.

 

[kumara_faith]

Hi,

I have a cross post here;

Populate New or Dropped Data

Hi, I have the data table as attached in Table 1. It shows the names of products that we maintain every month. If a product is dropped in the current month, it will noy appear in the list of products the next month. Similarly, any new added product will also appear in the months in which it...

www.excelforum.com