Finding Duplicates in workbook

[rsk]

Am using excel for daily report.Sheet name refers date (Jan 1 , Jan 2 etc).

daily I update all the project id's (in column A) done on that day. Once I update the project id's I check whether those id's are already done in previews sheet by using Search (ctrl + F) within workbook.


Is there any way to find duplicates by using conditional formatting or some other way?

 

[slaya_cz]

Hi rsk


I would recommend to use additional column into next sheet with the formula like that

=COUNTIF(Sheet1!A:A;Sheet2!A1)

I assume that projects ID are displayed in the column A, started from cell A1.


All ID with result different than zero are displayed in the previous sheet, so you can easily filter out then.


Hope this helps.

Regards

slaya_cz

 

[rsk]

Thank you for your reply slaya,

My work book contains more sheets (30sheets per month)

Daily i add one new sheet so i need to check all the sheets


Have you got my point?

 

[dan_l]

This is strange.


Why are you making a new worksheet for day of the month?

 

[slaya_cz]

Hi rsk


then just change formula to cover all the sheets - i.e. if you have 3 sheets, formula is

=COUNTIF(Sheet1!A:A;Sheet3!A1)+COUNTIF(Sheet2!A:A;Sheet3!A1)

in order to test first two sheets.


Definitely, much easier (from my point of view) would be to have all the data at one sheet, with additional column to identify which day it is. So you would have ID in column A, date would be in column B. Easy to track.


Regards

slaya_cz

 

[wintermute]

Hi rsk,


if you really need to store data in multiple sheets, maybe some kind of control sheet would be helpful. Try to use "Consolidate" feature in special sheet. There you can have several checking functions.

 

[rsk]

Thanks for the suggestions.

How to consolidate all data's in one sheet.

Have to do manually or any other way?