knockingmyhead
New Member
- Joined
- Jul 14, 2012
- Messages
- 46
Column A has text. I want to clean it up and have the first occurance of a name in that column and if the next cell down that has the same name clear that cell.
john 100 john 100
aaron 200 aaron 200
aaron 200 200
aaron 200 200
doe 350 doe 350
doe 350 350
if it matters there are two blank rows between names. I don't want to delete the row (as i have seen in many posts, just clear the cell)
thanks
john 100 john 100
aaron 200 aaron 200
aaron 200 200
aaron 200 200
doe 350 doe 350
doe 350 350
if it matters there are two blank rows between names. I don't want to delete the row (as i have seen in many posts, just clear the cell)
thanks