hi,

i work on large data, was wondering if you guys could help me with my problem.

In a particular column (E), there are random dates from a different column (B). what i need to do is that if one particular date has recurred 30 times, the date is replaced by another date from column(B).

Thanks