View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maarten V. Maarten V. is offline
external usenet poster
 
Posts: 4
Default Counting and deleting rows

i'am getting from an other program a *.txt with data.
something like this:

apple
apple
apple
orange
apple
orange

I need to count how many of each kind there are, so :
apple 4
orange 2
apple
apple
orange
apple

and now i have to delete to other rows, so at the end i have only this:
apple 4
orange 2

how can i do this?