Need help in searching certain keywords from a array and displaying them

[hone]

Hi I am new to this forum, so if the questions is already answered please redirect me to that post, i have though searched entirely for this and couldnt find the answer, here is my query

I have set of array something like this with column names as x, y, z etc...

gzip
2.3.6 160dpi 320x480 samsung GT-S5830M
Android 4.0.3 GT-N7000 Build IML74K)
Android 4.1.1 en-us GT-I8190L Build
Profile MIDP-2.0 Configuration CLDC-1.1
Android 4.1.2 en-us GT-I8190L Build
Android 4.0.4 en-gb GT-I9300 Build
Android 2.2 en-us GT-I5500L Build
4.1.2 320dpi 720x1280 samsung GT-I9300
Android 4.1.2 en-us GT-I9300 Build
Android 4.0.3 GT-I9100 Build IML74K)
Android 4.1.2 en-us GT-I9100 Build
2.3.6 160dpi 320x480 samsung GT-S5690L
Android 4.2.2 en-us GT-I9500 Build
2.3.6 120dpi 240x320 samsung GT-S5360L
Android 4.0.4 GT-I9300 Build IMM76D)
Android 4.0.3 en-gb GT-I9100 Build

i wanted to have a formula or vba which will give me cell value based on a search for e.g. if i search for gt- then a last column should give me value

GT-S5830M
GT-N7000
GT-I8190L

and so on ... so as you see it will be search for all the rows and then based on the criteria it will be produce the value in the last column also if there is more than one value matching the criteria then it will be produced in next column to that so on .. can anybody please help me

[Jakobshavn]

What is your arrangement of columns?

[hone]

Hi Jak, thanks for the reply .. you mean how are the columns separate they are separated by tabs

[Jakobshavn]

No, I mean in which columns is your data stored. For example is all of:

2.3.6 160dpi 320x480 samsung GT-S5830M

stored in cell A1 or is some of it stored in B1 or C1

[hone]

its stored in multiple columns A1, B1, C1 and so ...

A1 will have 2.3.6
B1 will have 160dpi
C1 will have 320x480
D1 will have samsung
E1 will have GT-S5830M

this is the first row example .. some of the rows have more columns ..

[Jakobshavn]

Very good!

So the "GT......." data may appear in different columns for any row.

What is the maximum number of columns? (I need to know in which column to store the result)

[hone]

there are in total 10 columns

[hone]

thanks Jak, you can store results in 11 column onwards ..

so if GT is present 2 times then it should paste it in 11 and 12th column ...

[Jakobshavn]

Try this macro:

Please Login or Register  to view this content.

[hone]

thanks Jak, let me try this

[hone]

wow .. this works great ... jack this is stupendous .. i m trying few more things .. gimme some time ... never ever thought this will be so fast ... your great ...

[Jakobshavn]

Thanks for the feedback!

[hone]

Jak .. just have few more questions ... if u have time then u can modify the code and send it

the code is case sensitive, can we make it case in-sensitive
in some rows it was not able ot find the cells where GT was present ... here are the examples

when it started with "(" or when it started with "-" or when it started with "space" or whenever there was a word further to that like "samsungGT"

in all these rows no value was pasted in the last column .... any specific reasons it could be?

[Jakobshavn]

This will fix most of the problems:

Please Login or Register  to view this content.

[hone]

Great ... Marvelous .. this works perfect ... this is great work Jak ... many thanks and thanks a lot for this ... excellent ... god bless you