I attached a file which explains in the comments of the cells what i exactly try to do, as a simple example >>
A B
JOHN S. 2
TOMMY 1
NASSER 2
JOHN S. 3
NADER 5
so i want the total of JOHN S. (5) to be in the Col. C and to delete the line of JOHN S. 3
this is a brief of what i try to get ,but the file that i attached is more bigger , and it will be better if it can be a MICRO not a formula
Thank you in advance
Bookmarks