I want to collect the cells in one column which begins with specific number

[atakantekel]

Hi,

I want to collect the cells which begins with the same number or specified text in one column. Those cells are located in different columns in every row. Sample text is attached. I tried several solutions, and may be I'm doing it wrong in mac version (excel 2011), as I'm new to even keyboards in mac.

I appreciate your help.

Atakan sample.xlsx

[alansidman]

I don't understand your explanation of your request. Perhaps if you showed us a solution (manually prepared) then it would be clearer.

[atakantekel]

In every row, required cell is located in different columns randomly (e.g. S1,T2). I want them in Z column.
There are 1000 rows and it is difficult yo monitor them in different columns.
sample2.png

[alansidman]

Using the example in post 3, you can use the following VBA solution:

Please Login or Register  to view this content.

[mehmetcik]

Selam

This is quite simple really, the question is how much data you have and how often you need to do this.

Three formula got the job done, with some manual work.

A macro could easily automate this.

[atakantekel]

< Using the example in post 3, you can use the following VBA solution:>
Thank you for the great useful answer.

[atakantekel]

Using the example in post 3, you can use the following VBA solution:

Please Login or Register  to view this content.

Thank you for the great answer. I worked 10.000 lines perfectly )

[atakantekel]

Selam

This is quite simple really, the question is how much data you have and how often you need to do this.

Three formula got the job done, with some manual work.

A macro could easily automate this.

Thank you very much Mehmet. I appreciate your answer.
Your formulas will probably benefit someone if he or she wants to drive the "cell unique content".