I have a log for a copy machine usage. column A is a list of names. column B is the meter readings, and column C contains a simple formula subtracting every entry in column B from the next one to get the total usage.
I would like to sort the list by column A to get all identical names separated, but because columb B is a continous cycle I will not get the right numbers in Column C.

Here is what i want to do.
in one row on a separate worksheet I want excel to automaticaly enter one entry from each name in column A and then list all the numbers in Column C corresponding to that name under it.
I hope that is clear enough. And now, who can help? Macros, formulas or what ever works would be greatly appriciated. Thanks in advance.