Variable Length Array does not bring correct data

Hi

I want to create variable length array which should bring different data at each condition.

My code is

Please Login or Register  to view this content.

But I could not understand at which part I did mistake, because code brings data only one of criteria. Please correct me. I want to understand the code.

Thank you in advance

Please Login or Register  to view this content.

Thank you very much.

Can you tell me what was my mistake?

There were several mistakes.

• Three nested loops when only two are needed (rows and columns)
• You tested the criteria for every cell (all rows and all columns) when you only need to test the criteria for each row in the first column.
• Your line For ar = 1 To r only looped through 4 rows as r was not the number of rows in your data. It was the count of the criteria match.