ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comparing 2 Lists (https://www.excelbanter.com/excel-discussion-misc-queries/34211-comparing-2-lists.html)

inomata

Comparing 2 Lists
 

Lets say that I have a Sales Forecast list with Customer Name and Sales
Status columns. The number of registries in this list changes every day
(some new sales opportunities are created and some are deleted).

Questions a

1) How can I create a report to compare two days in order to know which
registries have been added and/or deleted?

2) If I want to know if a Sales Status have changed from one day to
another, what is the best way to do it?

Tks!!!


--
inomata
------------------------------------------------------------------------
inomata's Profile: http://www.excelforum.com/member.php...o&userid=18938
View this thread: http://www.excelforum.com/showthread...hreadid=385208



All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com