Copy as text the result of “=CONCATENATE(“A” RANDBETWEEN(100000 999999))” to save time. 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!). To create the conditional formatting, go to the Home tab select Conditional Formatting Highlight Cells Rules Duplicate Values. Then you need to select the column of combined data. 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”. The conditional formatting doesnt work with data across rows, so youll need this combined column if you want to detect duplicates based on more than one column.
0 Comments
Leave a Reply. |