Store String Values to Avoid Re-Using

[visualnotsobasic]

Hello friends!

I have a macro that loops through a column, and for each cell in that column, assigns the value to the string variable "railcar".
The problem is that there can be duplicates of these values.

Normally I would remove the duplicates, but the duplicates are also important.
Is there a way to store the values so that once a string has been used, the cell will be flagged if it is reused?

I know I can also just identify and highlight the duplicates manually, but there are other processes that occur once the string has been assigned.

Thanks for any and all answers!

[Norie]

What do you want to happen when a duplicate is encountered?

[1aaaaaaaaaaaaaaa]

Conceptually, you could store unique value occurrences on a separate sheet, then as you are looping through you can check to see if that string exists already, or you can store the values in a string list in memory (faster, but not persistent)

In practice, upload a sample workbook and it will help us work through your use case.


Thank you

[visualnotsobasic]

Hi Norie, thanks for the reply.

Please see the below code:

Please Login or Register  to view this content.

As you can see, after it finds the value it sets an adjacent cell value to the offloaded date from the other worksheet.
Since it is looping through the column to get the railcar value, and then for each cell starting at the top of the search column to match it, it will pick the date for the first match it encounters.

I would like it to go to the next instance of the value, and then use that date, etc, etc

Does this make sense?

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

[visualnotsobasic]

Hi Norie,

Thanks again. I understand that that would be hugely useful unfortunately, a lot of the data involved is confidential as per work policy. I can try and drum up an example workbook if that's necessary.