excel01noob
Board Regular
- Joined
- Aug 5, 2019
- Messages
- 93
- Office Version
- 365
- 2016
So me and my co-workers share a monthly excel file for keeping track of customers bills.
I converted this file into a table.
In some occasions, we found that the bill number (column A) appears more than once.
The number is a 12-length character but I see that some of my colleagues do copy/paste from emails without realizing that they paste the bill number with spaces.
What is the best way to highlight these duplicates (even with spaces)?
I created a Macro button to show the bills due in the current date.
I suppose I could include VBA code to show the duplicates as well but there might be issues if the duplicates are inserted with different dates (if that happens, there was a mistake when inserting it as bill number is unique)
I converted this file into a table.
In some occasions, we found that the bill number (column A) appears more than once.
The number is a 12-length character but I see that some of my colleagues do copy/paste from emails without realizing that they paste the bill number with spaces.
What is the best way to highlight these duplicates (even with spaces)?
I created a Macro button to show the bills due in the current date.
I suppose I could include VBA code to show the duplicates as well but there might be issues if the duplicates are inserted with different dates (if that happens, there was a mistake when inserting it as bill number is unique)