Hi,
i have attached an example copy. currently,the values in sheet(auto selection) are copied from sheet(raw data) using the auto selection button in sheet(raw data). then, i have copied the rows in sheet(auto selection) into (hidden) as well as all the rows in sheet(raw data) into sheet(hidden).duplicated rows are supposed to be highlighted in red as shown in the hidden sheet. however, in row 17 to row 20 are not highlighted. it is because for row 17, the value of column c is 6831.4909 while value of column c of row 32 is 6831.49090909089. does anybody know what is wrong with my coding? how can i change my coding to make sure that the decimals for sheet(raw data) and sheet( auto selection) are identical?
thank you.
Bookmarks