Combining Filter and Address functions

[Khiss]

Hoping someone can help me with this. I have a long series of IDs in a working document to which I add a new cell every other day with a new ID. What I'm trying to do is to identify if the ID exists already in the list and if so ad the addresses to an adjacent cell of ALL matching cells so that I can easily go and find them. I was thinking of combining ADDRESS and FILTER functions to get all the results and the TEXTJOIN to combine them into a nice format within the cell. However I can't figure out a way of extracting original cell address values for a filter formula.

In essence I need to be able to pull the Cell addresses of multiple cells as long as it matches a specific criteria. The solution needs to be dynamic since the list expands by about 10-15 entries each week.

I've attached a potential outcome that I came up with, but I'm open to alternatives. The main things is somehow getting a dump of all Cell Addresses

Screenshot 2022-06-13 172419.png

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[dosydos]

using the picture provided The formula i have will work for every cell excluding A1 because it is the first row and how the cell references are set up.
But based on your logic, A1 should always return "N/A" regardless so just enter that one manually.


In C2 please use the below formula and then drag down.

Please Login or Register  to view this content.

If your data is in some other column other than Column A then you will need to updated the red portion of the formula. I could have used a column() formula in there as well but i was lazy.
Please make sure to set column B to WRAP TEXT.

[dosydos]

same instructions as above but this one will update if you change columns:

Please Login or Register  to view this content.

[Khiss]

That works perfectly, thank you.