We have 1,000's of rows of text data, but a huge number of rows have only one unique event.
joe called
joe called
bill called
joe called
etc. It's almost impossible to sort this data, so we're trying to find a command or macro that would delete the entire row when "bill called" because it only happened once. This scrubs our data to indicate repeat events only.
And this is always text-never numbers
Much appreciated!
joe called
joe called
bill called
joe called
etc. It's almost impossible to sort this data, so we're trying to find a command or macro that would delete the entire row when "bill called" because it only happened once. This scrubs our data to indicate repeat events only.
And this is always text-never numbers
Much appreciated!