![]() ![]() It works, but it takes two minutes to finish!!! Ok, conditional formatting is a very effective visual indication and fast anough for my needs, but as I am not able to perform a loop to check the color of the cells (found some people against this approach!! Would be so easy! ) I need to find an alternative way to count the duplicates (as a whole, no need to identify how many for each case!). I would like to keep track of how many duplicates during the filling process. I need to check if duplicate entries exist in 30000 rows of a column (any value, but not blanks!). Actually, I already have a partial answer!!! Conditional formatting with “Cell value is” → “duplicate” !!! This way a check is performed for each user’s new entry in “real time”.
0 Comments
Leave a Reply. |