Alternate Filtering of Data Excel Vba

[Jest24]

Hi is there a way to make Excel column data alternating. For example :

I would used it to evenly ditribute data to personnel so they would have a mixture of data and not only handling data with tagged as New or Old. Thank you

 

[RobMG]

=IF(MOD(ROW(),2)=1,"New","Old")