deduping

I have a seemingly simple problem, but can't figure out the excel behind it... here's a simplified mock up of the data involved: <tbody> Letters Colors Numbers A Blue 1 A Red 1 A Blue 1 A Pink 1 A Purple 1 B Blue 2 B Pink 2 B Pink 2 B Yellow 2 C Blue 3 C Red 3 </tbody>...

I have two columns, one of users and one of errors I want to produce the user's name and how many of each error if the user is associated with 2 or more errors. Here's an example of what I have: user1 error1 user1 error2 user1 error3 user2 error1 user3 error3 Since user 1 shows up more than...

I am building a data analysis company. My thrust at the moment is analysis of cell number and SMS messages. I plan to do the following with cell numbers: categorize according to source (e.g. radio programme); frequencies by date, month, day of the week and time; dedupe, analyse SMS messages and...