Check the particular values of several column of all rows

Hi, i'm a newbie to Excel VBA

Currently, I need to create a macro that

1. Check the values in several columns of the rows to find the rows with the same values
2. Delete the first one and delete the rest
3. add a specific number to the last column basing on the number of rows deleted

For example I have

Row 1 Car Long Red Apple Orange England 1

Row 2 Car Short Blue Pear Melon China 1

Row 3 Car Long Red Grape Berry England 1

Row 4 Car Square Green Mango Kiwi England 1

So when I run the macro, it will check the values of Column 2,Column 3, Column 4 and Column 7, after that it will delete the rows with similar values and then add a value to the 8th column based on the number of rows deleted.

Which will look like this

Row 1 Car Long Red Apple Orange England 2

Row 2 Car Short Blue Pear Melon China 1

Row 3 Car Square Green Mango Kiwi England 1


Is it possible to do this?
Thank you for any response :D

Hi, Sorry for not replying, the net is down for the whole weekend.

I have attached the an excel file with the information you asked, hope it helps.

And thanks for replying! :D

Yes it is :D

Thank you very much! XD
I just step into the world of Excel VBA and all my manager ever rams about is macro, so i thought that macro is the only viable option
:P

Thanks for telling me about the pivot table :D

Oh yeah, by any chance could you tell me how did you design your pivot table? I tried making one myself but the result looks more like a tree view than a table.

Thanks again :D

Thanks very much, I was able to done it with ease :D

Again thank you very much for helping me on my issue, you've been a great help