Excel VBA to store cell row numbers into an array if COUNTIFS criteria's is met

With a dictionary you can get keys and their items.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

A sample workbook would speed things up.
Questions:
1) What are your criteria? Please show your formula.
2) Do you want the Row numbers in the array, or the values of the cells?
3) Will there be gaps between "TRUE" cells, or is it one contiguous block (area)?

1) What are your criteria? Please show your formula.
Refer Column B:B.. Values must be stored in array only if counts are greater than 1.
2) Do you want the Row numbers in the array, or the values of the cells?
I want values to stored in an array--Column D:D values.. later i need to loop through this array and check for specific values.
3) Will there be gaps between "TRUE" cells, or is it one contiguous block (area)?
No Gaps

Please refer attached sample file

I put them under your table - try:

Please Login or Register  to view this content.

Are you sure that your problem was not addressed?

Try this:

Please Login or Register  to view this content.

And you will see that the array "Dic" was, indeed, stored - at least as long as the book is up