Count data from multiple rows

[Fjalar]

I have yet another struggle in the vba jungle.

What i am trying to do is getting data from column B, C & D to count.

Example: As you se below i only added value from "B2". There is another value in column C and D could be "4,5 litre V8" in C and "7-speed duoclutch GETRAG"
I want to create a code that counts how many times "Ferrari 458 4,5 litre V8 7-speed duoclutch GETRAG" occurs.

Please Login or Register  to view this content.

/Alex

[arlu1201]

Is this the only statement that needs to be counted or are there many more such combos?

[Fjalar]

There are plenty more combinations. A = model B = engine and C = transmission. Sometimes there are different models that have the same transmission. So i have to specify every code and prob repeat it for every different combo.

[arlu1201]

Maybe you can attach a sample file with dummy data, but in the same format as your original file and we can try to help you.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Fjalar]

Created a dummy with the same type of values that i would encounter in my original document.

As you can see i listed the car model twice but different engines etc.

Hope this helps. The original document contain more values but they are not relevant for the count.

Thanks, Alex

[arlu1201]

In what format should the output be shown?