egydream2002

you can use countif function to know the occurence of each cell Filter what more than 1 move them to a new sheet mohsen mahmoud

The file contains unnecessary data hidden due to the oldest of the file week by week. The solution I did, 1. Copy all the sheet 2. Create New Sheet 3. Paste Special (select Values) 4. Paste Special (select Format) This make the size of the file from 11.7MB to 77Kb (Of course faster) See attached EMPLOYEESN_LIST_W47_mohsen1.rar

???????????????????????????????

please

please upload example to work on it Hope I can help mohsen mahmoud

please upload the files, hope I can help mohsen mahmoud

MROUND If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. MROUND(number,multipl) A B Formula Description (Result) =MROUND(10, 3) Rounds 10 to a nearest multiple of 3 (9) =MROUND(-10, -3) Rounds -10 to a nearest multiple of -3 (-9) =MROUND(1.3, 0.2) Rounds 1.3 to a nearest multiple of 0.2 (1.4) =MROUND(5, -2) Returns an error, because -2 and 5 have different signs (#NUM!) Mohsen Mahmoud MROUND.rar

please explain more

gmx.net